Ryfujk

Can a German sentence have two subjects?

Infinite past with a beginning?

A Journey Through Space and Time

Modification to Chariots for Heavy Cavalry Analogue for 4-armed race

How can I hide my bitcoin transactions to protect anonymity from others?

Is there a familial term for apples and pears?

How long does it take to type this?

Shell script can be run only with sh command

How to type dʒ symbol (IPA) on Mac?

Validation accuracy vs Testing accuracy

DOS, create pipe for stdin/stdout of command.com(or 4dos.com) in C or Batch?

Copycat chess is back

Set-theoretical foundations of Mathematics with only bounded quantifiers

What do you call something that goes against the spirit of the law, but is legal when interpreting the law to the letter?

Compute hash value according to multiplication method

When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?

Copenhagen passport control - US citizen

Banach space and Hilbert space topology

I see my dog run

A function which translates a sentence to title-case

Is it possible to make sharp wind that can cut stuff from afar?

Why don't electromagnetic waves interact with each other?

How is the claim "I am in New York only if I am in America" the same as "If I am in New York, then I am in America?

How to report a triplet of septets in NMR tabulation?

Exception Enumerating SQL Server Instances with SMO WMI ManagedComputer

How to read cell data in excel and output to command promptget-adcomputer error: “Invalid Enumeration Context” when running powershell scriptPowershell querying Sharepoint listCan you use SQLite 64 bit odbc from powershellPowershell script to insert SQL Statement with a apostrophe errorpower shell error: Cannot bind parameterPowershell execution policy within SQL ServerWhy is the Set-ClientAccessServer cmdlet throwing a DataValidationExceptionERROR: Invalid syntax. Default option is not allowed more than '2' time(s)

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

1

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. However, I'm getting exceptions after I instantiate the objects when I try to access any data on them. I'm running PowerShell as an administrator.

$computer = New-Object Microsoft.SqlServer.Management.Smo.WMI.ManagedComputer ($env:computername)

$computer.ServerInstances

Results in this error:

The following exception was thrown when trying to enumerate the collection: "An exception occurred in SMO while trying to manage a service.".

At line:1 char:89

+ (New-Object Microsoft.SqlServer.Management.Smo.WMI.ManagedComputer ($env:computername)). <<<< ServerInstances

+ CategoryInfo : NotSpecified: (:) [], ExtendedTypeSystemException

+ FullyQualifiedErrorId : ExceptionInGetEnumerator

Is there some service I have to enable to get this to work? The WMI service is running. Is there some other setting I need? Why can't I enumerate SQL Server instances?

windows-7 sql-server-2008 powershell wmi sql-server

share|improve this question

edited Jun 5 '13 at 19:40

splattered bits

asked Jun 4 '13 at 23:51

splattered bitssplattered bits

6582722

bumped to the homepage by Community♦ 4 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you load the Assembly for SQL WMI Management? [void][System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SQLWMIManagement') ?
  
  – Shawn Melton
  Jun 12 '15 at 3:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I can also note that running that command on my Windows 8.1 machine with two named instances running, shows the ServerInstances is empty.
  
  – Shawn Melton
  Jun 12 '15 at 3:35
  

  
  
  
  

add a comment | 

1

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. However, I'm getting exceptions after I instantiate the objects when I try to access any data on them. I'm running PowerShell as an administrator.

$computer = New-Object Microsoft.SqlServer.Management.Smo.WMI.ManagedComputer ($env:computername)

$computer.ServerInstances

Results in this error:

The following exception was thrown when trying to enumerate the collection: "An exception occurred in SMO while trying to manage a service.".

At line:1 char:89

+ (New-Object Microsoft.SqlServer.Management.Smo.WMI.ManagedComputer ($env:computername)). <<<< ServerInstances

+ CategoryInfo : NotSpecified: (:) [], ExtendedTypeSystemException

+ FullyQualifiedErrorId : ExceptionInGetEnumerator

Is there some service I have to enable to get this to work? The WMI service is running. Is there some other setting I need? Why can't I enumerate SQL Server instances?

windows-7 sql-server-2008 powershell wmi sql-server

share|improve this question

edited Jun 5 '13 at 19:40

splattered bits

asked Jun 4 '13 at 23:51

splattered bitssplattered bits

6582722

bumped to the homepage by Community♦ 4 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you load the Assembly for SQL WMI Management? [void][System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SQLWMIManagement') ?
  
  – Shawn Melton
  Jun 12 '15 at 3:35
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I can also note that running that command on my Windows 8.1 machine with two named instances running, shows the ServerInstances is empty.
  
  – Shawn Melton
  Jun 12 '15 at 3:35
  

  
  
  
  

add a comment | 

I'm trying to use the SMO WMI API/objects in PowerShell 2.0 on Windows 7 with SQL Server 2008 R2 installed to get a list of SQL Server instances on the local computer using the Managed Comuter object. However, I'm getting exceptions after I instantiate the objects when I try to access any data on them. I'm running PowerShell as an administrator.

$computer = New-Object Microsoft.SqlServer.Management.Smo.WMI.ManagedComputer ($env:computername)

$computer.ServerInstances

Results in this error:

The following exception was thrown when trying to enumerate the collection: "An exception occurred in SMO while trying to manage a service.".

At line:1 char:89

+ (New-Object Microsoft.SqlServer.Management.Smo.WMI.ManagedComputer ($env:computername)). <<<< ServerInstances

+ CategoryInfo : NotSpecified: (:) [], ExtendedTypeSystemException

+ FullyQualifiedErrorId : ExceptionInGetEnumerator

Is there some service I have to enable to get this to work? The WMI service is running. Is there some other setting I need? Why can't I enumerate SQL Server instances?

windows-7 sql-server-2008 powershell wmi sql-server

share|improve this question

edited Jun 5 '13 at 19:40

splattered bits

asked Jun 4 '13 at 23:51

splattered bitssplattered bits

6582722

$computer = New-Object Microsoft.SqlServer.Management.Smo.WMI.ManagedComputer ($env:computername)

$computer.ServerInstances

share|improve this question

edited Jun 5 '13 at 19:40

splattered bits

asked Jun 4 '13 at 23:51

splattered bitssplattered bits

6582722

share|improve this question

edited Jun 5 '13 at 19:40

splattered bits

asked Jun 4 '13 at 23:51

splattered bitssplattered bits

6582722

asked Jun 4 '13 at 23:51

splattered bitssplattered bits

6582722

asked Jun 4 '13 at 23:51

splattered bitssplattered bits

6582722

1 Answer
1

active

oldest

votes

0

Are you running this code as administrator? Access to WMI requires WMI privileges. However, there is an alternate method I use. I documented that here: http://www.powershellmagazine.com/2013/04/24/pstip-enumerate-all-sql-server-instances-in-a-network/

[Microsoft.SqlServer.Management.Smo.SmoApplication]::EnumAvailableSqlServers("MyDBServer")

share|improve this answer

answered Jun 5 '13 at 5:50

ravikanthravikanth

29813

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've updated my question to note that I am running as an administrator.
  
  – splattered bits
  Jun 5 '13 at 19:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That's the workaround I tried. Unfortunately, my script also does some other work with SMO.WMI, and I'm getting similar problems. I really need to get the WMI stuff working.
  
  – splattered bits
  Jun 5 '13 at 19:42
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f513278%2fexception-enumerating-sql-server-instances-with-smo-wmi-managedcomputer%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

Are you running this code as administrator? Access to WMI requires WMI privileges. However, there is an alternate method I use. I documented that here: http://www.powershellmagazine.com/2013/04/24/pstip-enumerate-all-sql-server-instances-in-a-network/

[Microsoft.SqlServer.Management.Smo.SmoApplication]::EnumAvailableSqlServers("MyDBServer")

share|improve this answer

answered Jun 5 '13 at 5:50

ravikanthravikanth

29813

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've updated my question to note that I am running as an administrator.
  
  – splattered bits
  Jun 5 '13 at 19:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That's the workaround I tried. Unfortunately, my script also does some other work with SMO.WMI, and I'm getting similar problems. I really need to get the WMI stuff working.
  
  – splattered bits
  Jun 5 '13 at 19:42
  

  
  
  
  

add a comment | 

0

Are you running this code as administrator? Access to WMI requires WMI privileges. However, there is an alternate method I use. I documented that here: http://www.powershellmagazine.com/2013/04/24/pstip-enumerate-all-sql-server-instances-in-a-network/

[Microsoft.SqlServer.Management.Smo.SmoApplication]::EnumAvailableSqlServers("MyDBServer")

share|improve this answer

answered Jun 5 '13 at 5:50

ravikanthravikanth

29813

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I've updated my question to note that I am running as an administrator.
  
  – splattered bits
  Jun 5 '13 at 19:40
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That's the workaround I tried. Unfortunately, my script also does some other work with SMO.WMI, and I'm getting similar problems. I really need to get the WMI stuff working.
  
  – splattered bits
  Jun 5 '13 at 19:42
  

  
  
  
  

add a comment | 

Are you running this code as administrator? Access to WMI requires WMI privileges. However, there is an alternate method I use. I documented that here: http://www.powershellmagazine.com/2013/04/24/pstip-enumerate-all-sql-server-instances-in-a-network/

[Microsoft.SqlServer.Management.Smo.SmoApplication]::EnumAvailableSqlServers("MyDBServer")

share|improve this answer

answered Jun 5 '13 at 5:50

ravikanthravikanth

29813

[Microsoft.SqlServer.Management.Smo.SmoApplication]::EnumAvailableSqlServers("MyDBServer")

share|improve this answer

answered Jun 5 '13 at 5:50

ravikanthravikanth

29813

answered Jun 5 '13 at 5:50

ravikanthravikanth

29813

answered Jun 5 '13 at 5:50

ravikanthravikanth

29813