Connect to Server cause error

[Sophia]

I am trying to connect to SQL server with the 'Connect to server' option on Start Page.  I select 'Microsoft OLE DB Provider for SQL Server'. Select the server name and the DB Name. Test connection works successfully.  I give it a connection name.  But then start getting all types of errors. One after the other, most of them stating 'Invalid object_name'  examples:
(Microsoft OLE DB Provider for SQL Server [-2147217865] Invalid object name 'usys_system'.)
then the next is (Microsoft OLE DB Provider for SQL Server [-2147217865] Invalid object name t.datatypes'.)
this continues with a number of errors more until finally I get a question to transfer model.  But then gets the same errors until I get a message salying that EA will close due to a serious error. Does anyone know what causes this or if I have forgotten to set something.

[Geert Bellekens]

Sophia,

The connect to server is used to connect EA to an EA model stored in SQL Server (iso eap file), not for reverse engineering a database. Is this what you are trying to achieve?
In that case, did you first run the database creation script?

Geert

[Sophia]

Hi Geert
Not trying to reverse engineer.  Have created the model in EA, and created an empty model in SQL, and want to connect to the empty model before doing a transfer.  You mention database creation script?

[Geert Bellekens]

Yes, database creation script. They are available in the download section (where you download the setup files)
This will create the tables and stuff EA needs to build a model.

Geert

[juhi]

Sophia,

Also please see the following links...

http://www.sparxsystems.com/enterprise_architect_user_guide/projects_and_teams/connecttosqlserver.html

http://www.sparxsystems.com/enterprise_architect_user_guide/projects_and_teams/upsizingtosqlserver.html

HTH

Juhi