Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

What connection string you are setting. See this link how you can get the actual connection string -

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.
Avatar of Murray Brown

ASKER

In Azure they provide a connection string as follows

Server=tcp:xxxx.database.windows.net,1433;Initial Catalog=xxxxxx;Persist Security Info=False;User ID=xxxxx;Password=xxxxx;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
And when you connect from SSMS, you need to set the database in the Options dialog of the Login window.
Thanks Ste5an. Yes I am connecting from the same IP address
Thanks David. I got my connection string from a similar looking screen in Azure
Thanks for the help