TheNovice Posted June 16, 2020 Share Posted June 16, 2020 I am trying to establish MS SQL Server connection to Databse on Microsoft Azure, I am using the same connection string which I normally use to connect to local MS SQL Server DB. Can you have a look and help if I need to change any part of the connection string as it is on Azure Cloud. global string Con_Str = "Driver={SQL Server};Server=abc-xyz.database.pqr.net;Database=SCADA_DB;Uid=UserOne;Pwd=UserPass" global conn= db.OpenEx(Con_Str) Thanks in advance. Quote Link to comment Share on other sites More sharing options...
TheNovice Posted June 16, 2020 Author Share Posted June 16, 2020 14 minutes ago, TheNovice said: I am trying to establish MS SQL Server connection to Databse on Microsoft Azure, I am using the same connection string which I normally use to connect to local MS SQL Server DB. Can you have a look and help if I need to change any part of the connection string as it is on Azure Cloud. global string Con_Str = "Driver={SQL Server};Server=abc-xyz.database.pqr.net;Database=SCADA_DB;Uid=UserOne;Pwd=UserPass" global conn= db.OpenEx(Con_Str) Thanks in advance. I was able to connect fine using different PC on different network. So it seems some networking and firewall thing. Thanks and Sorry to bother Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.