Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Hurra on February 19, 2018, 11:19:42 pm

Title: Help w Microsoft SQL Server
Post by: Hurra on February 19, 2018, 11:19:42 pm

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.

Title: Re: Help w Microsoft SQL Server
Post by: Geert Bellekens on February 19, 2018, 11:32:44 pm

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

Title: Re: Help w Microsoft SQL Server
Post by: Hurra on February 20, 2018, 01:43:03 am

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

Title: Re: Help w Microsoft SQL Server
Post by: Geert Bellekens on February 20, 2018, 02:05:12 am

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

Title: Re: Help w Microsoft SQL Server
Post by: Hurra on February 20, 2018, 09:14:46 pm

Quote from: Geert Bellekens on February 20, 2018, 02:05:12 am

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 ;D

Title: Re: Help w Microsoft SQL Server
Post by: prome4 on February 21, 2018, 02:21:53 am

Quote from: Geert Bellekens on February 20, 2018, 02:05:12 am

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,+