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
Did not work for me, but I can see both (1) and (2) I just can't see the SQL services other than Integration Services under SQL Services. (32 bit version)
This not work for me
does not work for me as well.
Me neither. I think this solution is for a specific issue (i.e. corrupted dll). I have a 2-node SQL Cluster and the 64-bit options are missing on one of the servers, but there on the 2nd.