how to find no. of instances installed on single sql sever 2005

Question

how to find no. of instances installed on single sql sever 2005

anand1807

Grasshopper

Points: 21
More actions
July 15, 2008 at 5:59 am

#193906

is there any sp or some script to find total no of instances installed in sql server 2005

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

SQL Server 2005 is a single instance. It is self contained. If you install multiple instances, they are all installed on Windows as separate pieces of software.

I'm not sure if there is one, but you could read the registry and look for the various installs. MSSQL.1, MSSQL.2, etc. Since they could be named anything, on various ports, service names changed between versions, etc., not sure how else you could do this.

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 2

You can use the free SQLPing 3.0 utility available on the link below to find SQL Server instances on one or more servers.

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

RPSQL Hall of Fame Points: 3229 More actions · Answer 3

You can know the number of instance by looking services in sql server configuration manager

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 4

I'd recommend SQLPing as well.

K. Brian Kelley
@kbriankelley

Marios Philippopoulos SSC Guru Points: 57190 More actions · Answer 5

It's possible to write a powershell script to enumerate through all services available on the server and pick only those pertaining to SQL (2000, 2005).

__________________________________________________________________________________
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]