Determine installed SQLServer version without running SQLServer?

Hello

I have a hard-drive from a Win7 system that had SQL Server 2008 Express on it. The OS will no longer boot, but the file system is accessible.  I need to know if the SQLServer version was 2008 or 2008 R2. Is there a way for me to determine this from within the filesystem given that I can't actually run SQLServer?  

Thanks
PMH4514Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
go to the installation folder, typically:
C:\Program Files\Microsoft SQL Server
and check which folders are there, and the content, for example:
C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn

in there, you shall have the sqlservr.exe file, right-click => properties => details tab.
you will see "file and product version" that shall match the version information listed here:
https://support.microsoft.com/kb/321185
0
 
Alex Green3rd Line Server SupportCommented:
Go into all users, check the start menu in there and see what it says

C:\ProgramData\Microsoft\Windows\Start Menu\Programs

It'll be something like that for your start menu
0
 
PMH4514Author Commented:
Perfect, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.