How to find list of SQL Instance - Installed on the computer



One of my computer has more than 2 or 3 versions of SQL installed .. like SQL 2005 , SQL 2008 and SQL 2005 Express Edition.

And

One of my client computer has SQL 2005 Express Edition installed on it ..

I want to know their SQL Instance name ..
chokkaAsked:
Who is Participating?
 
amarsaleConnect With a Mentor Commented:
1) click on start
2) In Run, Type services.msc
3) scroll down to sql server to know every instances on sql server installed on the machine.

Regards,
Amar
0
 
MalhovicCommented:
In SQL Server Management Studio:

Double Click your server to open the Object Explorer
Right Click and select Properties
On the General Tab - The server name is the instance name.
0
 
MalhovicCommented:
I forgot, you can also run a SQL query from within the Management Studio with this and it will populate the instance name as the result:

select @@ServerName
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
chokkaAuthor Commented:
Imagine i dont have SQL Management Studio .. Just Express Edition installed ..

Then, how should i find the SQL Instances ..!
0
 
chokkaAuthor Commented:
There is a way to find from services.msc

Go to Services

_ It will list all SQL Installed ..
0
 
MalhovicCommented:
You can download the SQL Management Studio for free from Microsoft.
0
All Courses

From novice to tech pro — start learning today.