Solved

Determine installed SQLServer version without running SQLServer?

Posted on 2014-02-13
3
331 Views
Last Modified: 2014-02-13
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
0
Comment
Question by:PMH4514
3 Comments
 
LVL 9

Expert Comment

by:Alex Green
ID: 39856199
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
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 300 total points
ID: 39856202
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
 

Author Comment

by:PMH4514
ID: 39856232
Perfect, thanks!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question