SQL Instance Names

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

SQL Instance Names

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

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

Page: [1]

Message

<< Older Topic Newer Topic >>

SQL Instance Names - 9/29/2008 1:53:32 PM

gwenger

Posts: 67
Score: 6
Joined: 3/13/2006
Status: offline

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

Post #: 1

RE: SQL Instance Names - 9/30/2008 9:36:12 AM

skissinger

Posts: 2167
Score: 135
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline

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?

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to gwenger)