I have a SQL server 2005 which is working internally within the LAN network, now my task is to make this query process to be done anywhere (Instead of LAN) because some of them may be on tour so I need to make it available to everyone so that those who are using the VB.Net form they will get connected with the SQL server.
The below are the connection strings which is working fine internally (within the LAN)
connetionString = "Server=.\SQLEXPRESS;Database=MyDB;User Id=MyUserID;Password=MyPassword;"
connetionString = "Server=AGW064\SQLEXPRESS;Database=MyDB;User Id=MyUserID;Password=MyPassword;"
Anyone please add your valuable suggestion about how to make this SQL server available for online?
Bookmarks