Home Forums Programming Powershell powershell WMI error: "Could not obtain SQL Server Service information. An attempt to connect to WMI ... failed with the following error: access is denied." RE: powershell WMI error: "Could not obtain SQL Server Service information. An attempt to connect to WMI ... failed with the following error: access is denied."

  • opc.three (6/21/2011)


    Please have a look at this MSDN forum post. It references an MSDN article related to SSIS but see the section "Eliminating the "Access Is Denied" Error. The original poster resolved his own issue referencing that article so DCOM settings may be a common root cause to both your issue and the SSIS issue referenced in the article:

    http://social.msdn.microsoft.com/Forums/en-NZ/sqltools/thread/7431a5a3-ef26-4e61-8a53-64cd616dcf84

    Thank you, I'll check it.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]