- Switching of Net-Library protocols.
- A new DSN's protocol is used for older DSNs, or vice versa.
Also, from Microsoft Data Access Components (MDAC) 2.6 and later, the default network library is TCP/IP. If you use a server name (in other words, you do not create a server alias), even if you configure your DSN to use named pipes, it will revert back to TCP/IP. To resolve this problem, follow the steps given in the "Workaround" section.
- In the Client configuration utilities for SQL Server, create an alias using a different name than the server name.
- Create or modify a DSN, and for the server name, choose the alias (not the server) from step 1.
- Save the DSN and reopen.
The configuration information of the server aliases is stored in the registry under the following key:
ODBC AdministratorTo add a server alias using the ODBC Administrator, follow these steps:
- In Control Panel, browse to the ODBC Administrator.
- Click Add and select SQL Server as the driver. Then enter a name and description for the DSN. In the Server select box, specify a new server alias name and then click Next.
- Click the Client Configuration button. Enter the SQL Server name in the Server name text box under Connection parameters. Also, select the required Net-Library under Network Libraries. Then click OK and complete the steps to create the DSN.
Client Network UtilityThe Client Network Utility, Cliconfg.exe, ships with several products, including Microsoft SQL Server and Microsoft Data Access Components (MDAC) version 2.1 SP2 and later.
This utility is typically placed in the C:\WINNT\SYSTEM32 folder on Microsoft Windows 2000 and Microsoft Windows NT systems and in the C:\WINDOWS\SYSTEM folder on Microsoft Windows 9x systems.
To start this utility, follow these steps:
- If the SQL Server client is installed, on the Start menu, point to Programs, point to Microsoft SQL Server, and then click Client Network Utility.
- Otherwise, on the Start menu, click Run.
- Type cliconfg in the Open text box and then click OK.
- Click the Alias tab and then click Add.
- Type a new alias name in the Server alias text box and choose the required Net-Library under Network libraries.
- Enter the SQL Server name in the Server name text box under Connection parameters. You can also configure the additional parameters based on the Net-Library. Then click OK.
NOTE: You can use the Remove and Edit buttons under Alias tab to delete and modify the existing server aliases.
For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
ID do Artigo: 289573 - Última Revisão: 04/08/2008 - Revisão: 1