Problem with setting up SQL Server Repository

[STV]

Hi everybody

We have been using Enterprise Architect 10.0.1008, projects have been saved file-based up to now.

Now we'd like to use EA with a Database Repository under MS SQL Server SP1.

According to http://www.sparxsystems.com/enterprise_architect_user_guide/8.0/projects_and_teams/upsizingtomysql.html, the following steps have been carried out:

• A new database has been created using the Script provided under Link above
• "Stage Five: Transfer the Data": everything entered as advised. We have a Group Enterprise_Architect which has been set up for read and write access to our DataBase EnterpriseArchitect --> we use Single-Sign-On --> Testing of the connection is successful!
  

Now click on the Transfer button and as soon as the progress bar is at about 50% and "copying project information for: t_category" is performed, the following error message occurs:

Microsoft OLE DB Provider for SQL Server [-2147217900]

Cannot find the object "t_category" because it does not exist or you do not have permissions.

Checks from our side:

• The Table t_category exists
• it can be accessed e.g. via Excel

Any hints are highly appreciated!

Best regards, STV

[OpenIT Solutions]

As it happens I saw the same error last week - the fix for me with to run the project consistency check on the EAP and fix the errors reported. Then trying the migration again....

[STV]

Thanks for your suggestion! Just executed Tools --> Data Management --> Project Integrity Check. Result: No problems found - and same error when trying to transfer the project again...

[Geert Bellekens]

The link you provided talks about MySQL in EA version 8, but you mentioned EA v10 with SQL Server?

Are you sure you are following the correct instructions?

Geert

[Geert Bellekens]

It's actually a permissions problem on the SQL server

Somewhere in the instructions it states

"When transferring a project you must have db_ddladmin permission in order to execute the SET IDENTITY_INSERT ( table )  {ON | OFF} command"

Geert