Author Topic: Help w Microsoft SQL Server  (Read 1560 times)

Hurra

  • EA User
  • **
  • Posts: 128
  • Karma: +0/-0
    • View Profile
    • Find me at LinkedIn!
Help w Microsoft SQL Server
« 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.
always learning!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9821
  • Karma: +298/-30
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Help w Microsoft SQL Server
« Reply #1 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

Hurra

  • EA User
  • **
  • Posts: 128
  • Karma: +0/-0
    • View Profile
    • Find me at LinkedIn!
Re: Help w Microsoft SQL Server
« Reply #2 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
always learning!

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 9821
  • Karma: +298/-30
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Help w Microsoft SQL Server
« Reply #3 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

Hurra

  • EA User
  • **
  • Posts: 128
  • Karma: +0/-0
    • View Profile
    • Find me at LinkedIn!
Re: Help w Microsoft SQL Server
« Reply #4 on: February 20, 2018, 09:14:46 pm »
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
always learning!

prome4

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
  • Play hard, work hard, learn hard
    • View Profile
    • drupal development
Re: Help w Microsoft SQL Server
« Reply #5 on: February 21, 2018, 02:21:53 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,+
I'm part of the b-works team. We are engaged in drupal development  for long-term success and enjoy popularity. I will be glad to talk to you about new technologies!