Can anyone please post the tutorial for connect SQL server over the WAN. I have been using my SQL server in the LAN without problem. I am not able to connect with the STATIC ip and this is connection string for LOCAL.
conString="PROVIDER=SQLOLEDB;SERVER=192.168.1.1;UID=XXX;PWD=XXX;DATABASE=TEST"
I have tried with coneectionstrings.com and helpless.
Thanks in advance.
Jump to Postthis is 99% a network problem, connection string is OK
this is 99% a network problem, connection string is OK
Hi,
Check the connection string here :
http://www.connectionstrings.com/?carrier=sqlserver
It is slightly different there..
Regards
Veena
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.