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

  • Article

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:

If you are not able to see the 64 bit options, replace “C:\Program Files\Microsoft SQL Server\100\Shared\sqlmgmprovider.dll” with SQLMGMPROVIDER.dll copied from another working machine.

For the 32 bit options, replace “C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmprovider.dll” with the 32 bit SQL SQLMGMPROVIDER.dll” copied from another working machine.

Amit Khandelwal  
SE, Microsoft SQL Server

Reviewed by

Amit Banerjee
TL, Microsoft SQL Server