Como configurar un alias para conectarse a una instancia en puerto no default

Configure a SQL client alias
If you block UDP port 1434 or TCP port 1433 on the SQL Server computer, you must create a SQL client alias on all other computers in the server farm. You can use SQL Server client components to create a SQL client alias for computers that connect to SQL Server 2000 or SQL Server 2005.

1.
Run Setup for SQL Server 2005 on the target computer and select the following client components to install:

1.
Connectivity Components

2.
Management Tools


2.
Open SQL Server Configuration Manager.

3.
In the left pane, click SQL Native Client Configuration.

4.
In the right pane, right-click Aliases, and select New Alias.

5.
In the Alias dialog box, enter a name for the alias and then enter the port number for the database instance. For example, enter SharePoint_alias.

6.
In the Port No field, enter the port number for the database instance. For example, enter 40000. Ensure that the protocol is set to TCP/IP.

7.
In the Server field, enter the name of the SQL Server computer.

8.
Click Apply, and then click OK.


Test the SQL client alias
Test connectivity to the SQL Server computer by using Microsoft SQL Server Management Studio, which is available by installing SQL Server client components.

1.
Open SQL Server Management Studio.

2.
When you are prompted to enter a server name, enter the name of the alias that you created, and then click Connect. If the connection is successful, SQL Server Management Studio is populated with objects that correspond to the remote database.


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

Comments

Popular posts from this blog

Desempeño de SQL Server 2008 R2 y Max Worker Threads

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

SQL Server La longitud de los datos LOB (2200100) que se van a replicar excede el máximo configurado 65536.