After you install a 64-bit version of SQL Server 2005 on a 64-bit version of Windows, the 32-bit entries for SQL Native Client Configuration and for SQL Server 2005 Network Configuration appear in SQL Server Configuration Manager

Article translations Article translations
Article ID: 936491 - View products that this article applies to.
Expand all | Collapse all

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.
Collapse this tableExpand this table
Entry in SQL Server Configuration ManagerVersionResidence of aliases that are created in SQL Server Configuration ManagerCorresponding subkey in the registryApplications that are affected by the protocol settingsAvailability of aliases to applicationsResidence of aliases that are created by Client Network Utility
SQL Native Client Configuration (32bit)32-bitAliases that are created in this entry reside only in this entry
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectTo
Not applicableOnly 32-bit applications can use aliases in this entryNot applicable
SQL Native Client Configuration64-bitAliases that are created in this entry reside only in this entry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
Not applicableOnly 64-bit applications can use aliases in this entryResides only in this entry
SQL Server 2005 Network Configuration (32bit)32-bitNot applicable
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\SNI9.0
Only 32-bit applications are affectedNot applicableNot applicable
SQL Server 2005 Network Configuration64-bitNot applicable
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0
Only 64-bit applications are affectedNot applicableNot 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

Properties

Article ID: 936491 - Last Review: November 20, 2007 - Revision: 1.2
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
Keywords: 
kbsql2005tool kbexpertiseadvanced kbhowto kbinfo KB936491

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com