Solved

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

Posted on 2010-09-20
6
548 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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

760 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

21 Experts available now in Live!

Get 1:1 Help Now