Hi all, I'm having a little bit of a problem with one of the command lines erroring out and I am not sure why. When I try:
"$server = Get-Item SQLSERVER:\SQL\localhost\default"
I get several lines of the same error:
"WARNING: Could not obtain SQL Server Service information. An attempt to connect
to WMI on 'localhost' failed with the following error: An exception occurred
in SMO while trying to manage a service. --> Failed to retrieve data for this"
Any clue why? Any help appreciated. P.S. When I try using the SMO, instead of using the provider, all is fine and dandy.