There are multiple ways through which we can check the No. of SQL Server instances which are running on a server like:
• Check the SQL services for different Instances
• SQL Server Configuration Manager Start- all programs – Microsoft SQL Server 2008 R2 -> configuration tools –> Microsoft SQL Server configuration Manager
• List out SQL Services from Net Start command
• Using Powershell commands
• Readging the Registry Keys, Regedit-> HKEY_LOCAL_MACHINE–>SOFTWARE ->Microsoft ->Microsoft SQL Server –>
InstalledInstance
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment