Exception in SQL SMO service

Question

Code >>

 ManagedComputer comp = new ManagedComputer(serverName, user, password);


            ServiceCollection servcoll = comp.Services;


            foreach (Service service in servcoll)
            {
            }

The exception is 

An exception occurred in SMO while trying to manage a service.

I can see Protection fault on Server

Faulting application name: wmiprvse.exe, version: 6.1.7601.17514, time stamp: 0x4ce79d42

Faulting module name: svrenumapi100.dll, version: 2007.100.2531.0, time stamp: 0x49cfcbb5
Exception code: 0xc0000005

Seems like permission issue. I have given the WMI permissions to the user. Still it is failing.

 

Answer 1

You may want to try restarting the WMI service. This can safely be done without rebooting the machine.

Answer 2

Doesn't work. I have rebooted system multiple times.

I have actually installed SQL Server 2012 (the beta release) and trying to connect it through SMO. Is there a problem?

Answer 3

I haven't tested 2012, I have however had some issues with WMI in pre Windows 2008 R2 SP1, where restarting the service fixed WMI issues.

Answer 4

hi please check, this link may help you.

http://stackoverflow.com/questions/7521069/sql-azure-smo-exception-when-scripting-objects-in-ssms-2008-r2