Como cambiar el puerto por default en una instancia de SQL Server 2005

Configure a SQL Server 2005 instance to listen on a nondefault port
Use SQL Server Configuration Manager to change the TCP port that is used by an instance of SQL Server 2005.

1.
Use SQL Server Configuration Manager to change the TCP port that is used by an instance of SQL Server 2005.

2.
On the SQL Server computer, open SQL Server Configuration Manager.

3.
In the left pane, expand SQL Server 2005 Network Configuration.

4.
Under SQL Server 2005 Network Configuration, click the corresponding entry for the instance that you are configuring. The default instance is listed as Protocols for MSSQLSERVER. Named instances will appear as Protocols for named_instance.

5.
In the right pane, right-click TCP/IP and click Properties.

6.
Click the IP Addresses tab. For every IP address assigned to the SQL Server computer, there is a corresponding entry on this tab. By default, SQL Server is listening on all IP addresses assigned to the computer.

7.
To globally change the port that the default instance is listening on, perform the following:

1.
For each IP except IPAll, clear all values for both TCP dynamic ports and TCP Port.

2.
For IPAll, clear the value for TCP dynamic ports. In the TCP Port field, enter the port that you want the instance of SQL Server to listen on. For example, enter 40000.


8.
To globally change the port that a named instance is listening on, perform the following:

1.
For each IP including IPAll, clear all values for TCP dynamic ports. A value of 0 for this field indicates that SQL Server uses a dynamic TCP port for the IP address. A blank entry for this value means that SQL Server 2005 will not use a dynamic TCP port for the IP address.

2.
For each IP except IPAll, clear all values for TCP Port.

3.
For IPAll, clear the value for TCP dynamic ports. In the TCP Port field, enter the port that you want the instance of SQL Server to listen on. For example, enter 40000.


9.
Click OK. You will receive a message indicating that the change will not take effect until the SQL Server service is restarted. Click OK.

10.
Close SQL Server Configuration Manager.

11.
Restart the SQL Server service and confirm that the SQL Server computer is listening on the port you selected. You can confirm this by looking in the event viewer log after restarting the SQL Server service. Look for an information event similar to the following event:

Event Type:Information

Event Source:MSSQL$MSSQLSERVER

Event Category:(2)

Event ID:26022

Date:3/6/2008

Time:1:46:11 PM

User:N/A

Computer:computer_name

Description:

Server is listening on [ 'any' 50000]


http://technet2.microsoft.com/Office/en-us/library/763613ac-83f4-424e-99d0-32efd0667bd91033.mspx?mfr=true

Comments

Popular posts from this blog

Cómo identificar consultas más pesadas en SQL Server

Permitiendo la administración de los jobs a usuarios que no son System Administrators en SQL Server Agent 2005 o superior

FileTable en SQL Server 2012