Solved

Determine installed SQLServer version without running SQLServer?

Posted on 2014-02-13
3
334 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

728 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