Find all MSSQL Instances running, Connect and show Version

The diagram below, shows how you can use SQL Management Studio to connect to all instances of SQLServer running on your computer (as indicated in the Services list) and run a simple query to find out the exact version and service pack of SQLServer running.

In the SQL Management Studio, you can connect to a default instance by just typing the computername. To connect to a named (second) instance, you can connect to computername\instancename

Clicking “New Query” opens up the query window, and after typing “select @@version” (intellisense prompting will appear) and pressing F5, runs the query and shows the SQLServer version and service pack.

This entry was posted in IT and tagged . Bookmark the permalink.