MS SQL problems

[tothlac]

Dear EA Experts,

I have a permanent and very annoying issue with EA and MS SQL. I use EA Corporate version that supports MS SQL DBMS. We use MS SQL DBMS repository in our firm. Our administrator has run the specified DBMS script from the EA site so the DBMS is prepared for us. I can connect to DBMS via EA desktop using OLE DB Provider for SQL Server. The connection test works.

 Every time when I start using the EA with DBMS  it complains that there are not any valid modell and tries upload one. After that I get a message "Reopening connection to database" and the EA will be crashed. The logs show that EA teaches the server despite this fact. But we can not use it.

I have the same issue with the latest build. 

Has anybody any solution or any idea?

Thanks for advance: László Tóth

[smendonc]

There are two parts to creating a repository when using a dbms like SQL Server.  First the script needs to be run to create the database schema.  It appears that your administrator has already done this.  Second the empty schema needs to be seeded with the base model (assuming you want to start with an empty model).  This can be done by using the model transfer functionality of EA to transfer the 'EA Base' empty model to the SQL repository.  The repository should now be ready to use.

The error message is indicating that the empty schema has not been seeded with a starter model.

From you message it appeared you might be trying to do the seeding but its failing.  Validate with your administrator that you have read/write capability on the EA schema.

Stan.