Post reply

Making a Named Instance listen on a certain port.

  • September 13, 2011 at 10:00 am

    #247638

    Hello,

    I just read an artical on configuring SQL Server to listen multiple ports and this was done under the IPALL part of the IP Address tab of the SQL Server Network Configuration part of configuration mamanger.

    Now I need the named instance to always use the port that it has dynamically assigned itself so that should a restart occur, all the third party apps still work.

    My question is, do I need to specify the port under IP4 (currently blank, with TCP Dynamic Ports set to 0), or do I put the port number under IPALL, enter the port number into TCP Port and take the port number out of TCP Dynamic Ports and set that to 0 and restart the SQL service? Or, is it ok just to have the port number in TCP Port under IPALL and leave the same port number in TCP Dynamic Ports (also under IPALL)?

    I hope that makes sense and would appreciate any advice.

    Kind Regards,

    D.

  • September 13, 2011 at 10:21 am

    #1380792

    In the past, i've changed it where i've circled it below under IPAll. that has been how i assigned a static port for my express isntance to listen to.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 13, 2011 at 5:52 pm

    #1381001

    Use IPALL TCPPort.

    Thank You,

    Best Regards,

    SQLBuddy

  • September 14, 2011 at 2:03 am

    #1381101

    Thank you, that clears it up nicely.

    Regards,

    D

  • September 15, 2011 at 6:44 am

    #1381891

    Hi, Installed a sql server 2008 cluster. Could not connect from client machine to this named instance. It is listening to port no. 52096. Verified in the configuration manager.

    Please suggest a solution.

    Regards

    Govind

  • September 15, 2011 at 7:18 am

    #1381922

    You mean you cant connect through SSMS? What are you entering to connect?

  • September 15, 2011 at 7:54 am

    #1381978

    verify SQL browser it's running and firewall rules to admit that port.

  • September 15, 2011 at 5:37 pm

    #1382319

    Did you assign a static port number to the Named Instance or is it using dynamic ports ?

    As Aiello mentioned, check if SQL Browser service is stopped and start it if it's stopped.

    If you have a static port assigned or know the port number you can connect to it by using the following format from SSMS

    SQLServerInstanceName,PortNumber

    Thank You,

    Best Regards,

    SQLBuddy

  • September 16, 2011 at 5:09 am

    #1382471

    Hi,

    it is using dynamic port. Yes. I am not able to connect thru SSMS from client. I am entering servernameamedinstance for connection. The SQL browser is running from both nodes. Firewall is turned off.

    Thanks for your prompt reply.

    Regards

    Govind

  • September 16, 2011 at 6:54 am

    #1382519

    If i recall you have to take the cluster offline and start sqlserver locally to make the change. The problem is when you failover the change won't go along with it. When you run sql server locally the config overwrites the cluster config.

  • September 16, 2011 at 7:43 am

    #1382545

    I think to connect you should be doing Cluster_name\Instance.

    D.

  • September 19, 2011 at 2:22 am

    #1383177

    Hi All,

    Thanks. I am able to connect from Client with CLUSTERNAME\instance_name.

    Regards

    Govind

Viewing 12 posts - 1 through 11 (of 11 total)

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