Issue:
Autodesk Vault Server uses a Microsoft SQL database. There are several types (Express, Standard, Enterprise) and versions (RTM, CU XX) of SQL. It is necessary to know the type of SQL database used by Vault when troubleshooting errors or planning a Vault upgrade. Autodesk Vault does not display which SQL is being used.
Solution:
The instructions below provide three different methods to determine the type and version of SQL.
Method 1: View the ERRORLOG.
The simplest method to determine the Vault SQL type and version is to view the ERRORLOG.
Open File Explorer and navigate to the Autodesk Vault Microsoft SQL Server instance. It’s possible to setup SQL to install on a separate drive or folder but the default location is below.
C:\Program Files\Microsoft SQL Server\MSSQL14.AUTODESKVAULT\MSSQL\Log
Find the ERRORLOG file. Select the file and right click to select “Open with”.
Select Notepad as the app to open the file.
The ERRORLOG will display the SQL type and version at the top of the log. As shown below, the ERRORLOG is open in Notepad and shows this system is using the Express Edition of Microsoft SQL Server 2017 with CU31 (Cumulative Update 31).
SQL Express is the default type of SQL installed with the Vault Server and has a 10GB database limit.
Method 2: Run commands from an Administrator Command Prompt.
Select Windows search and type CMD for Command Prompt. Right click on Command Prompt and select “Run as administrator”.
Notice the Command Prompt Dialog box shows “Administrator:Command Prompt” at the top. Copy and past the text below into the Command Prompt and then hit Enter on the keyboard.
osql -S localhost\AUTODESKVAULT -E -Q"select @@version"
As shown in the dialog box below, the version of Microsoft SQL Server is 2019 CU 32 and is Standard Edition.
*This command uses the term “localhost” and is intended to be used on the same system that has SQL installed. It will not return the SQL information if SQL is installed on another server.*
Method 4: Use Microsoft SQL Server Management Studio.
There are two options within the Management Studio to easily view information about the Vault instance of SQL.
Launch Microsoft SQL Server Management Studio and login.
*Microsoft SQL Management Server Tools can be downloaded if they are not already installed* ( https://learn.microsoft.com/en-us/ssms/install/install )
Option 1: View the Properties of the AUTODESKVAULT instance.
Right click on the AUTODESKVAULT instance, at the left section of Management Studio in the Object Explorer, to select Properties.
On the General tab, you will see that product type and version. The image below shows Microsoft SQL Server Express is version 14.0.3456.2.
Option 2: Run a Query from Microsoft SQL Management Studio
Expand the Databases folder and right click on your Vault to select “New Query”.
Input SELECT @@VERSION and select Execute or right click to select Execute.
The version of SQL will appear. As Seen in the image below, this is Microsoft SQL Server 2017 CU 31.
These are the best methods to find more information about the SQL version used by Vault.
About the Author
Follow on Linkedin More Content by Shawn Heator
