Article ID: 936491
Article Last Modified on 11/20/2007
APPLIES TO
- Microsoft SQL Server 2005 Standard X64 Edition
- Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
- Microsoft SQL Server 2005 Enterprise X64 Edition
- Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
INTRODUCTION
After you install a 64-bit version of Microsoft SQL Server 2005 on a 64-bit version of a Microsoft Windows operating system, the 32-bit entries for SQL Native Client Configuration and for SQL Server 2005 Network Configuration appear in SQL Server Configuration Manager.
MORE INFORMATION
Some tools that are installed together with a 64-bit version of SQL Server 2005 are available only as 32-bit versions. When you install a 64-bit version of SQL Server 2005, the 32-bit versions of the following tools are installed:
- SQL Server Management Studio
- SQL Server Configuration Manager
- Database Engine Tuning Advisor
The following entries appear in SQL Server Configuration Manager:
- SQL Server 2005 Network Configuration (32bit)
- SQL Native Client Configuration (32bit)
- SQL Server 2005 Network Configuration
- SQL Native Client Configuration
The following table contains information about each entry.
Note Client Network Utility (Cliconfg.exe) is available in SQL Server 2000. In SQL Server 2005, the functionality of this tool is included in SQL Server Configuration Manager. However, to address backward compatibility issues, Client Network Utility is included in SQL Server 2005.
| Entry in SQL Server Configuration Manager | Version | Residence of aliases that are created in SQL Server Configuration Manager | Corresponding subkey in the registry | Applications that are affected by the protocol settings | Availability of aliases to applications | Residence of aliases that are created by Client Network Utility |
|---|---|---|---|---|---|---|
| SQL Native Client Configuration (32bit) | 32-bit | Aliases that are created in this entry reside only in this entry | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo
|
Not applicable | Only 32-bit applications can use aliases in this entry | Not applicable |
| SQL Native Client Configuration | 64-bit | Aliases that are created in this entry reside only in this entry | HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
|
Not applicable | Only 64-bit applications can use aliases in this entry | Resides only in this entry |
| SQL Server 2005 Network Configuration (32bit) | 32-bit | Not applicable | HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\SNI9.0
|
Only 32-bit applications are affected | Not applicable | Not applicable |
| SQL Server 2005 Network Configuration | 64-bit | Not applicable | HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0
|
Only 64-bit applications are affected | Not applicable | Not applicable |
REFERENCES
For more information about the performance issue that you experience when you run 32-bit SQL Server tools on 64-bit operating systems, click the following article number to view the article in the Microsoft Knowledge Base:
906892 You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems
Keywords: kbhowto kbinfo kbexpertiseadvanced kbsql2005tool KB936491
