Solved

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

Posted on 2010-09-20
6
562 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 

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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …

749 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