Alex Rivera | Logout

How can I determine installed SQL Server instances and their versions?

Asked 2008-09-26T18:32:23.457
265

I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this which assumes I'm already connected to a particular instance.

sql-server sql-server-express
Edit
Report

2 Answers

5

SQL Server Browser Service http://msdn.microsoft.com/en-us/library/ms181087.aspx

answered 2008-09-26T18:35:51.123
0

Here is a simple method: go to Start then Programs then Microsoft SQL Server 2005 then Configuration Tools then SQL Server Configuration Manager then SQL Server 2005 Network Configuration then Here you can locate all the instance installed onto your machine.

answered 2012-07-24T13:54:25.113

Your Answer