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?
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
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
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