This content has been marked as final. Show 1 reply
The following steps describe how to configure a server alias to use either TCP/IP sockets or Named Pipes to connect to a SQL Server directly without using the \\computer_name\instance_name format.
Configure a Server Alias to Use TCP/IP Sockets
NOTE: To configure an alias to use TCP/IP, you must provide the server name and TCP/IP port number. 1. Determine the SQL Server instance port number.
To find the SQL Server instance port number:a. On the Microsoft SQL Server 2000 server, start the SQL Server Network Utility.
b. Click the General tab, and then select the instance that you want from the Instances menu.
c. Click TCP/IP, and then click Properties. The port number for this instance is displayed.
Write down this port number for later use.
2. Configure the server alias on the client computer.a. Start the Client Network Utility. If you have installed the SQL Server client tools, or if you have installed MDSE, this utility is available as a shortcut on your Start menu. If not, you can start it directly. The file name is Cliconfg.exe, and it is usually stored in the System folder.
b. On the General tab of the Server Alias Configuration dialog box, click Add, and then click TCP/IP.
c. Enter an alias name in the Server Alias box. The alias can contain any name.
d. Enter the SQL Server 2000 computer name or IP address in the Computer Name box. Do not add an instance name.
e. In the Port Number box, enter the port number that you recorded in step 1. Click OK twice.