Help w Microsoft SQL Server

[Hurra]

Hello!

We are about to transfer our local model to an SQL Server and my colleague have set up a Microsoft SQL Server.

I have no experience working on "that side" and have problems connecting to the server.

I have downloaded the EASchema_1220_SQLServer.sql and executed it on a new databse. I don't see any new tables or anything though. Is it permissions in Microsoft SQL struggling? I executed through SSMS.

Is this the reason I can't connect? The script has to be run correctly berfore connecting? How can I make sure the script is executed?

I am not sure what questions I should ask you guys to solve this, please guide me!

Thanks,

Robert.

[Geert Bellekens]

Did the schema SQL execute properly?
If in doubt execute something like
select * from t_object
If that doesn't return an error about a missing table you should be fine.
(there will not be any results, but that is fine, the table is empty but exists)

Next step is to transfer an existing .eap model to the sql server model using Model transfer.

Geert

[Hurra]

Thanks Geert!

I realized that I ran the scripts on another DB. I can now connect and use the SQL Server, however, every time I login and connect it claims I entered the wrong password in the connection setup and is asked to enter it again. I enter the same password and get connected. Minor problem, but will probably be annoying in the long run.

Heard of anything like it? (:

Robert

[Geert Bellekens]

Must be something wrong in the connection string.
Try setting it up again, and check the "allow saving password" checkbox if you are using an SQL server user to connect (as opposed to using Windows Authentication)

Geert

[Hurra]

Must be something wrong in the connection string.
Try setting it up again, and check the "allow saving password" checkbox if you are using an SQL server user to connect (as opposed to using Windows Authentication)

Geert

 thanks

[prome4]

Must be something wrong in the connection string.
Try setting it up again, and check the "allow saving password" checkbox if you are using an SQL server user to connect (as opposed to using Windows Authentication)

Geert

Wow, it helps to me too, Thanks dude,+