Error using model wizard: User does not have permission...

[KenM]

Hi there,

We've recently deployed Sparx EA 13, and are in the process of working out our own internal processes on how to use the tool.  We've created a SQL Server instance as our backend, and are using Windows Integrated Authentication to connect to the database.

Everything seems to work well (changes persist in the database!), but we get the following error when adding models using the Model Wizard:

"User does not have permission to import model images"

We end up getting default icon's in the project navigator view, although they seem to correct themselves after a 'period of time' (not sure how long it takes).

Anyone have any ideas?  We have datareader and datawriter permissions to the database, and have NOT enabled version control in the system as of yet. 

Thanks!

[Glassboy]

What are the user permissions on the Sparx folders under %ProgramFiles% ?

[KenM]

Administrator has full control, Users have Read/Execute.  Do users need write access to this folder??

[Glassboy]

Administrator has full control, Users have Read/Execute.  Do users need write access to this folder??

No but I've seen different organisations cause problems with apps by changing the defaults for these directories.  If it's not a SQL permission error it could be a problem with permissions on %APPDATA% if EA writes something temporarily before importing into the DB.
 

[KenM]

Unfortunately, it appears that I have full control over %APPDATA%.

Data is being persisted correctly in the DB, so I'm honestly not sure what the root cause of the issue is.

[qwerty]

IIRC there's also an EA security setting for this kind of operation.

q.

[Gus Gunn]

We have just recently had the same problem. It was only occuring with models that were in SQL DB.  Local DB temp type models worked fine.  We found the resolution was to create an AD group called "SQL Enterprise Architect Update" and then:
GRANT ALTER ON [dbo].[t_image] TO [SQL Enterprise Architect Update].

Were were using version 13.309 of EA and did not have model security enabled.

[skiwi]

Wow, this is timely, I've just encountered this issue, so will attempt the fix

[Geert Bellekens]

I think Sparx has released a new schema that doesn't need these permissions on the t_image table, but IIRC this schema can only be used by v14 and is not backwards compatible.

Geertr