Opening a Connection to SQL Server via a VPN Connection
Posted on 2015-01-01
I'm trying to open a connection to a SQL Server instance via a VPN connection. The connection string I have is not working:
Provider=SQLNCLI11;Data Source=MySQLServer;Initial Catalog=MyDatabase;User Id=MyUSerID;Password=MyPassword;
I get this error:
Named Pipes Provider: Could not open a connection to SQL Server .
I also tried this connection string:
Provider=SQLNCLI11;Data Source=MySQLServer;Initial Catalog=MyDatabase;Integrated Security=SSPI
With what I think are my Windows credentials added to the list of security logins in SQL Server. To create the login, I used the VPN login credentials. I can't figure out how to add my workstation's Windows credentials - the workstation being the workstation on which I am running the VPN client.
What am I missing?