Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.