Post reply

configuring port

  • April 4, 2008 at 2:31 pm

    #184257

    I Have 3 sqlserver instances. all are on default port. I want to configure 3 different port for these instances.Pls help me

    Binu

  • April 4, 2008 at 2:47 pm

    #798698

    You need to open configuration manager to change the port the instance is running on. If you open Configuration manager, There is a tab for SQL Networking Configuration. You select the instance and then tcp/ip. You then click on the IP addreses tab and at the bottom you will see tcp port.


    My blog: http://jahaines.blogspot.com

  • April 4, 2008 at 3:14 pm

    #798714

    Thanks. But there it showing only default instance. How I can add other instances ?

    Binu

  • April 4, 2008 at 3:30 pm

    #798718

    If you are using SQL Server 2005's SQL Server Configuration Manager, if you expand the SQL Server 2005 Network Configuration in the left pane, you should see Protocols for *** where *** is an instance name. There should be one of those for each instance installed on the server. If you click on the instance you want to modify, you'll see the protocols in the right pane. Then you should be able to edit TCP/IP and set the port.

    K. Brian Kelley
    @kbriankelley

Viewing 4 posts - 1 through 3 (of 3 total)

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