Hi,
I have some problems using SMO with MSSSQL Server 2000 MSDE on Windows 2003 R2 Sp2.
I have installed:
-SMO 2008 R2
-System CLR Types
-SQL Server 2008 R2 natvie client along with SDK
SQL Server is running but im not able to enumerate server instances due to the following exception:
Unhandled Exception: Microsoft.SqlServer.Management.Smo.SmoException: SQL Server
WMI provider is not available on SERVER-G0H941. ---> System.Management.Manage
mentException: Invalid namespace
at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStat
us errorCode)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer.TryConnectUsingPath
(ManagementPath path)
--- End of inner exception sta ...
Go to the complete details ...