SQL Server 2008 Configuration Manager on a 64 bit machine does not display Network configuration & Native Client configuration options

PROBLEM:

When you open SQL Server 2008 configuration manager you do not see the following options :

Scenario 1 (64 bit options):
1)            SQL Native Client 10.0 configuration
2)            SQL Server Network configuration

Scenario 2 (32 bit options):
1)            SQL Native Client 10.0 configuration(32 bit)
2)            SQL Server Network configuration (32 bit)

CAUSE:

SQL Server configuration manager pulls the details with the help of SQLMGMPROVIDER.DLL.
This DLL has got two versions - one is 64 bit and the other is 32 bit :
The location 64 bit DLL is: C:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmprovider.dll and the location 32 bit DLL is: C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmprovider.dll

If this DLL is corrupted then you will see this issue. In this case when I checked the property of the 64 bit DLL it was blank.

RESOLUTION:

Read more: Microsoft SQL Server Tips & Tricks

Posted via email from jasper22's posterous