locked
Instance connection prob RRS feed

  • Question

  • Hi Team,

    Few days back i have installed named instance everything was fine.

    default instance:

    abc,1433--its connecint

    Named instance

    abc\Kin01 -- its connecting but

    i want to connect  like this " abc,60265 ". In the sql server configurations Mananger TCP IP port was not showing anything

    Now can i add the same port in TCP/IP 60265.

    What actions i have to take to connect abc,60265 please suggest me.

    Regards


    subu

    Tuesday, March 12, 2013 1:04 PM

Answers

  • Hi Team,

    I have changed TCP/IP Protocol  60265 now its connecting

    Thanks for your suggestions.


    subu

    • Marked as answer by subu999 Tuesday, March 12, 2013 3:54 PM
    Tuesday, March 12, 2013 3:53 PM

All replies

    1. Make sure SQL SERVER is up and the instance you try to connect is running.
    2. Your system Firewall should not block SQL Server port.
    3. Go to Computer Management >> Service and Application >> SQL Server Configuration >> Network Configuration
      Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 60265.
    4. Create an alias for your named instance (note that the alias works for that computer only).
    Tuesday, March 12, 2013 2:48 PM
  • I presume you did this: Configuring a Fixed Port http://msdn.microsoft.com/en-us/library/ms345327(v=SQL.100).aspx

    Check the SQL Server error log to confirm that SQL Server is listening on that TCP port.

    Check the Windows Firewall to make sure you have opened the TCP port (60265) in the firewall.

    And presuming that SQL Server is listening on TCP (which I think you did already), then connecting to abc,60265 should work.

    If not, detailed troubleshooting steps are here How to Troubleshoot Connecting to the SQL Server Database Engine


    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    Tuesday, March 12, 2013 3:27 PM
  • Hi Team,

    I have changed TCP/IP Protocol  60265 now its connecting

    Thanks for your suggestions.


    subu

    • Marked as answer by subu999 Tuesday, March 12, 2013 3:54 PM
    Tuesday, March 12, 2013 3:53 PM