Post reply

Sql errors 10061 and 17

  • May 2, 2005 at 8:48 am

    #88859

    Hello,

    I am getting the following errors when I try to connect to MY SQL server from a different SQL server:

    Connection Failed.

    SQL State '01000'

    SQL Server Error:10061

    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]

    ConnectionOpen(COnnect()).

    Connection Failed.

    SQL State '08001'

    SQL Server Error:17

    [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

    This connection is on a VPN tunnel.  As far as I know the ports are open.  I did a netstat -an and 1433 is listening. I have tried to connect from a different IP address and the connection is fine. I have seen a lot of postings for this problem on the web but no real answers to solve the problem.

    TIA

    Joe

  • May 2, 2005 at 4:24 pm

    #556417

    Hi Joe,

    This message is most probably Firewall. Please ask your infrastructure support to verify that the Firewall is open from your IP address. They usually open it from a particual IP or range of IPs to a particualr IP. Please, verify that your computer has a static IP address. It is often that people are able to connect being on the network when they are getting DHCP IPs from the DHCP server and the port is open from the range this DHCP server assigns. But the same people with the same laptops are unable to connect from home because when they use VRAS they are getting IPs in a different range. 

    And one other thing: when you say MY SQL server, do you mean "my server" or "MYSQL"

    Yelena

     

    Regards,Yelena Varsha

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

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