SQL Instance Names (Full Version)

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003



Message

gwenger -> SQL Instance Names (9/29/2008 1:53:32 PM)

Can anyone assist in modifing this mof change to also provide the SQL instance names of 64bit installations?

http://www.myitforum.com/articles/8/view.asp?id=10576

Thanks -Gary



skissinger -> RE: SQL Instance Names (9/30/2008 9:36:12 AM)

Are you saying it doesn't pull back instances on 64 bit SQL?  I just checked on my server 08 x64, with sql2005 x64, and that WMI location showed the instance.  I only have one on this box... but it was there.

On the server w/SQL 64; if you go to
start, run   wbemtest
Connect
type in    root\Microsoft\SqlServer\ComputerManagement
hit connect
hit Enum Classes... leave the field blank, change the radio button to Recursive & hit OK
Wait a few seconds...
scroll down to "ServerSettings" & doubleclick it.
hit Instances
That should be your sql instance names.  It's not correct?



gwenger -> RE: SQL Instance Names (10/2/2008 10:32:47 AM)

Thanks Sherry-
It's there, which means than the problem lays within my Report query.
-Gary



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.1875