locked
Cannot connect to SQL Server 2008 Named Instance RRS feed

  • Question

  • Hello,

    I am trying to connect to our internal sqlserver\tech instance (2008r2/sqlserver2008r2) from a 2008r2 server in our DMZ using sql authentication.  The error message is:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (.Net SqlClient Data Provider)

    I can connect to the default instance from the DMZ server with no problem

    I can connect to the sqlserver/tech instance from inside the firewall

    I have port 1433 and 1434 open in the DMZ firewall

    PortQuery from the DMZ server gives me the following:

    ==== End of SQL Server query response ====

    UDP port 1434 is LISTENING
    portqry.exe -n sqlserver -e 1434 -p UDP exits with return code 0x00000000.
    =============================================

     Starting portqry.exe -n sqlserver -e 1433 -p TCP ...


    Querying target system called:

     sqlserver

    Attempting to resolve name to IP address...

    Name resolved to 10.10.0.24

    querying...

    TCP port 1433 (ms-sql-s service): LISTENING
    portqry.exe -n sqlserver -e 1433 -p TCP exits with return code 0x00000000.

    I have TCP connections enabled on the sql server.

    I have the sql browser service running.

    I have tried turning off the firewall on the DMZ server - same error

    I have opened ports 1433 and 1434 on the firewall in the dmz server - same error

    The firewall on the SQL server is not enabled.

    Any help you could offer on this problem would be greatly appreciated.

    thank you in advance.



    Friday, February 21, 2014 5:44 PM

Answers

  • I have opened ports 1433 and 1434 on the firewall in the dmz server - same error

    Hello Patrick,

    Port 1433 is used by the default instance, your named instance is using a different IP port and you have to unblock this port for in-/outbound as well.

    See http://msdn.microsoft.com/en-us/library/cc646023.aspx


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Alberto MorilloMVP Friday, February 21, 2014 6:34 PM
    • Marked as answer by Sofiya Li Monday, March 3, 2014 9:42 AM
    Friday, February 21, 2014 5:50 PM
  • I ended up going into the network configuration and setting different port numbers for the different instances.
    • Marked as answer by PatrickSteiner Tuesday, October 28, 2014 8:26 PM
    Tuesday, October 28, 2014 8:26 PM

All replies

  • I have opened ports 1433 and 1434 on the firewall in the dmz server - same error

    Hello Patrick,

    Port 1433 is used by the default instance, your named instance is using a different IP port and you have to unblock this port for in-/outbound as well.

    See http://msdn.microsoft.com/en-us/library/cc646023.aspx


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Alberto MorilloMVP Friday, February 21, 2014 6:34 PM
    • Marked as answer by Sofiya Li Monday, March 3, 2014 9:42 AM
    Friday, February 21, 2014 5:50 PM
  • Thank you Olaf.  I will try this Monday and respond back.
    Friday, February 21, 2014 6:16 PM
  • Thank you Olaf.  I will try this Monday and respond back.

    Hi PatrickSteiner,

    I’m writing to follow up with you on this post. Was the problem resolved after performing our action plan steps? If you are satisfied with our solution, I’d like to mark this issue as "Answered". Please also feel free to unmark the issue, with any new findings or concerns you may have.

    Thanks,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Monday, March 3, 2014 9:42 AM
  • I ended up going into the network configuration and setting different port numbers for the different instances.
    • Marked as answer by PatrickSteiner Tuesday, October 28, 2014 8:26 PM
    Tuesday, October 28, 2014 8:26 PM