URGENT: Error 11004 When Connected Via VPN

  • garyjh00

    SSC Veteran

    Points: 216

    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?

    Thanks!!

     

  • Rodrigo Acosta

    SSC-Insane

    Points: 21261

    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.

  • garyjh00

    SSC Veteran

    Points: 216

    Yes... the client network utility is configured.

  • John Pfeffer

    SSC Enthusiast

    Points: 121

    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?

     

  • bjkrame

    Mr or Mrs. 500

    Points: 542

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


    BK

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

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