April 4, 2008 at 2:31 pm
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
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.
April 4, 2008 at 3:14 pm
Thanks. But there it showing only default instance. How I can add other instances ?
Binu
April 4, 2008 at 3:30 pm
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