How can I determine which versions of SQL Server are installed on a machine? I know for sure on my own machine that I have SQL Server 2000 and SQL Server 2008 R2 but aside from just knowing this as I installed them how else can I find out? I've been tasked with finding out all the installed SQL Server instances on different servers so any help would be much appreciated.
Asked
Active
Viewed 217 times
1
-
you can use `SQL Server Configuration Manager` – Milen Feb 14 '14 at 11:51
-
Can you expand a little more? – Srb1313711 Feb 14 '14 at 11:52
-
@Downvoter please explain what was wrong so I dont make same mistakes in the future – Srb1313711 Feb 14 '14 at 11:54
2 Answers
2
Connect to your Sql server DB server using SSMS and run the below command
Select @@version
Also, take a look at this Support/KB document for detailed way of getting the version/edition of SQL Server installed on your machine.
https://support.microsoft.com/kb/321185
To find the installed instances run SQL server Configuration Manager like
Start -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager
Once config manager opened -> click/select the label named Sql Server instances
Other ways to find out the same; look at this posts
How can I determine installed SQL Server instances and their versions?
To identify and enable disabled SQL Server instances in SQL Server 2000, see the below MS KB article.
-
This only tells me the server instance im connected to, the machines I am checking have multiple instances installed and I am unsure how to see all installed instances? – Srb1313711 Feb 14 '14 at 11:52
-
-
-
Cannot see sql server instances, see my comment in the answer by @NagarajS – Srb1313711 Feb 14 '14 at 12:02
-
See my edited answer again. This KB article explains how can you list out all SS2000 instance as well enable/disable them. Take help of `Google`; you will get most of your answer. – Rahul Feb 14 '14 at 12:14
-
2
SELECT @@VERSION
from command line
SQLCMD -L
or use
SQl Server Configuration Manager
use the SQL Server Configuration Manager tool that installs with both SQL Server 2005 and 2008. On the start menu, expand the Microsoft SQL Server [YOURVERSION] menu, and then expand the Configuration Tools submenu. Launch the SQL Server Configuration Manager tool
Find your Installed SQL Server Versions and Instances
Identify a SQL Server Express Instance
How to Find Your SQL Server Instances (Server Name)
How to identify and enable disabled SQL Server instances in SQL Server 2000
How can I determine installed SQL Server instances and their versions
-
This is helpful thank you for image was very useful but when i tried this on a machine With sql 2005 and 2000 and this only showed sql 2005? – Srb1313711 Feb 14 '14 at 11:59