I am trying to connect to SQL 2005 via our VPN connection. Nothing seems to work. I can ping the server and the IP address but when connecting via management studio I get the "allow remote connections." error. Remote connections are enabled though.
I am trying to connect to SQL 2005 via our VPN connection. Nothing seems to work. I can ping the server and the IP address but when connecting via management studio I get the "allow remote connections." error. Remote connections are enabled though.
Check the correct port is open. The default TCP/IP port for SQL Server is 1433. You can easily check that by opening a telnet session to the machine
telnet <ip address> 1433
If the screen goes blank, then you can connect to that port, otherwise you'll get an error something like: Could not open connection to the host, on port 1433: Connect failed.
If connecting via telnet doesn't work, then check the TCP/IP port the SQL server is running on, make sure it's right. If it is, tax your network guys for help.
If connecting via telnet does work, then check your connection string, you may need to add Network=DBMSSOCN;
to your connection string to force it to connect via TCP/IP.
It might just be simple security. However you're logging in doesn't have permission to the server. A ping shows the server is online, but it doesn't show that you have access.
No one has followed this question yet.