Access SQL Server through VPN 1

[skunk2K]

Hi all,

I was wondering if anyone has had much luck accessing a SQL server through vpn using Enterprise manager. I would appreciate any hints tips or tricks. I am using win2k and trying to connect to a sql 7 server. I can connect to the network fine and do normal stuff but am not having much luck with enterprise manager and sql 7.

Thanks for any help,,

 

[tlbroadbent]

Without knowing the specifics of your connection or any messages you might receive when attempting to connect, I can only guess at the difficulty. I suspect, you may need to change the Network Library used to connect to SQL Server. The default library is named pipes and it may not work over VPN.

Start the Client Network Utility and view the connection properties. You may or may not have a connection defined. If you don't have a connection defined, then create one and set the Network Library to TCP/IP or Multiprotocol. If the connection exists, you may need to change the network library from named pipes to TCP/IP or multiprotocol. Make sure SQL Server can accept the protocol you choose.

If you've tried the available protocols with no success, try to ping your SQL server so you can know if it is reachable from your connection. Terry

http://members.home.net/tlbroadbent/index.htm