By Kim Hyde
Cadline has written several Blogs regarding Microsoft SQL used as the database engine for all Autodesk Vault products. Having a compliant version / service pack level is important as Autodesk will only officially support Vault on tried and tested environments, system requirement details for which are available via the following link:
Trying to find the build information for an SQL already installed can be a bit of a challenge and there are several ways you can do this. However, I have recently found the following method using the `SQL Server Installation Centre’ (the Microsoft standard application for initially installing SQL). Even if you have installed SQL Express by default via Autodesk Vault media, the Installation Centre will be available and is accessible via the Windows Start Button.
The reports produced using this tool are comprehensive and provide specific SQL build numbers which can be crossed-referenced to confirm the edition and service pack level.
Please refer to the following steps to produce the report:
Working from the server that includes the SQL instance for Vault, access and open the SQL Server Installation Centre.
Select `Tools’ from the left-hand category list, then select the `Installed SQL Server discovery report’ from the feature listings.
A report is produced in html format and is written to an SQL report folder (sample folder location and image of report below is from my laptop):
C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20170330_124531\SqlDiscoveryReport.htm
Using the main 4-digits from the version number (circled above) cross-reference this for the exact release and service-pack level. The following link provides a comprehensive list:
(Selected window showing release details)