Connecting to SQL Server on VPN RSS

• • Reply
  

  ftbadolato

  Member

  1 Points

  34 Posts

  Connecting to SQL Server on VPN

  Mar 09, 2010 04:08 AM|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! 

  Connection String VPN

• • Reply
  

  amalhashim

  Participant

  832 Points

  144 Posts

  Re: Connecting to SQL Server on VPN

  Mar 09, 2010 05:25 AM|LINK

  ConnectionStrings.com - Forgot that connection string? Get it here!

  In case of VPN, make sure you are providing the IP Address instead of host name.
  

  Thanks,
  A.m.a.L
  [Don't hate the hacker, hate the code]
  .Net Goodies
  • Marked as answer by Jian Kang - MSFT on Mar 15, 2010 02:50 AM
• • Reply
  

  ftbadolato

  Member

  1 Points

  34 Posts

  Re: Connecting to SQL Server on VPN

  Mar 09, 2010 03:28 PM|LINK

  OK, so is this the correct format?

  Connect via an IP address
  
  Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

  If so, what is Network Library?

• • Reply
  

  amalhashim

  Participant

  832 Points

  144 Posts

  Re: Connecting to SQL Server on VPN

  Mar 10, 2010 04:31 AM|LINK

  Data Source=190.190.200.100;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;

  This will be fine
  

  Thanks,
  A.m.a.L
  [Don't hate the hacker, hate the code]
  .Net Goodies
• • Reply
  

  bhupal

  Member

  39 Points

  30 Posts

  Re: Connectingjavascript:__doPostBack('ctl00$ctl00$bcr$bcr$PostForm$ctl04$ctl03$ctl02$QuoteButton...

  Aug 12, 2010 06:49 PM|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

  bhupal

  
  

• • Reply
  

  itsjp

  Member

  24 Points

  106 Posts

  Re: Connecting to SQL Server on VPN

  Nov 19, 2012 12:56 AM|LINK

  Hi,

  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