Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to find all the sql installations in our network.

I found more than 100 machine names which has sql installation.

I tried to connect to those machines via client tool, but was not able to. This may happen either I do not have the rights or it may be a client installation.

How can I know what version, edition or basic details about the sql installed in those machines.

Thanks in advance

share|improve this question
How did you find them if you can't connect to them? What do you mean "client installation"? – joeqwerty Oct 25 '12 at 15:45
xp_cmdshell 'osql -L' – harsha Oct 26 '12 at 11:33

If you have admin rights on the systems to read the registry but not SQL rights, this powershell script works well:

How do I check for the SQL Server Version using Powershell?

I would change the registry key that it looks at for the version from "Version" to "PatchLevel" though if you wanted to know exactly what version it was running, not just the last servicepack.

share|improve this answer

For internal auditing of your SQL installations (especially when they are so many) you should seriously consider Microsoft Assessment and Planning (MAP) Toolkit. If you have never used it before you will wonder why not!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.