URGENT: Error 11004 When Connected Via VPN

  • I have a remote user connected to our server via VPN. Whenver he tries to create an ODBC connection to our SQL Server, he get this error:

    Connection failed: SQL State: '01000' SQL Server Error: 11004 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection Failed: SQL State: '08001' SQL Server Error: 6 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

    He is using the IP address when referencing the server.

    Can anyone shed light on this problem?



  • Did you try creating an alias in the client pc, from the Client Network Utility?

    Specify the ip adress in the servername and in the alias the real name of the server.

  • Yes... the client network utility is configured.

  • not to ask a dumb question but is he using the true ip of the server? rathe than a NAT address?  can he use enterprise manager or query analyzer ok?


  • Not 100% sure,  but make sure your WAN administrator is allowing traffic on Port 1434 on the firewall.


Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply