Last post Nov 18, 2012 08:56 PM by itsjp
Mar 09, 2010 12:08 AM|ftbadolato|LINK
I need the syntax for a connection string in web.cong to connect to a SQL Server 2005 database that is on a VPN. I have an account on the DB that I can use....just don't know how to construct the connection string properly.
Thanks in advance!
Mar 09, 2010 01:25 AM|amalhashim|LINK
In case of VPN, make sure you are providing the IP Address instead of host name.
Mar 09, 2010 11:28 AM|ftbadolato|LINK
OK, so is this the correct format?
Connect via an IP address
Data Source=188.8.131.52,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
If so, what is Network Library?
Mar 10, 2010 12:31 AM|amalhashim|LINK
Data Source=184.108.40.206;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;
This will be fine
Aug 12, 2010 02:49 PM|bhupal|LINK
hi can u please give me suggessition
I have access to vpn in my local system,
how can i create new web site in vpn system using visual studio 2008 and what i need to connect vpn using visual studio
thanks in advance
Nov 18, 2012 08:56 PM|itsjp|LINK
I have the same problem...How can I get IP address instead of Hostname??? An this host name is the SQLServer hostname or VPN connection host name??
Can you please help me