Solved

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

Posted on 2010-09-20
6
553 Views
Last Modified: 2012-05-10


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 ..
0
Comment
Question by:chokka
  • 3
  • 2
6 Comments
 
LVL 1

Expert Comment

by:Malhovic
ID: 33720385
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
 
LVL 1

Expert Comment

by:Malhovic
ID: 33720392
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
 

Author Comment

by:chokka
ID: 33720432
Imagine i dont have SQL Management Studio .. Just Express Edition installed ..

Then, how should i find the SQL Instances ..!
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:chokka
ID: 33720478
There is a way to find from services.msc

Go to Services

_ It will list all SQL Installed ..
0
 
LVL 1

Expert Comment

by:Malhovic
ID: 33721334
You can download the SQL Management Studio for free from Microsoft.
0
 
LVL 1

Accepted Solution

by:
amarsale earned 500 total points
ID: 33723606
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now