Murray Brown
asked on
Azure SQL Connection String not working
Hi
I just added a new SQL database to my Azure account. For some reason the connection string provided isn't working.
What might cause this?
Thanks
I just added a new SQL database to my Azure account. For some reason the connection string provided isn't working.
What might cause this?
Thanks
ASKER
In Azure they provide a connection string as follows
Server=tcp:xxxx.database.w indows.net ,1433;Init ial Catalog=xxxxxx;Persist Security Info=False;User ID=xxxxx;Password=xxxxx;Mu ltipleActi veResultSe ts=False;E ncrypt=Tru e;TrustSer verCertifi cate=False ;Connectio n Timeout=30;
Server=tcp:xxxx.database.w
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And when you connect from SSMS, you need to set the database in the Options dialog of the Login window.
ASKER
Thanks Ste5an. Yes I am connecting from the same IP address
ASKER
Thanks David. I got my connection string from a similar looking screen in Azure
ASKER
Thanks for the help
https://www.experts-exchange.com/questions/29065679/restructure-connection-string-for-Azure.html
once you get the connection string just change the line where you are setting the connection.