Error Message

When running Deployment Scanner the following query is executed against the master database.

select Name from sysdatabases where Name like 'EV%' or Name like 'EnterpriseVault%'

In the above diagram the vault service account default database is set as tempdb instead of master and the query is likely to fail.

Check the settings below as part of the troubleshooting/solution for this issue:

1. Open Registry Editor and check the version in the following registry hive

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion

2. Check the connectivity with ODBC(Object Database Connectivity) and Telnet.

3. Add Enterprise Vault Service account into the local admin group on the SQL Server.

Note: Although not a mandatory step, it has always helped to overcome this issue due to possible other environmental issues.

4. Open SQL Server Management Studio and Expand Security | Logins and Access the properties of Enterprise Vault Service account.

Check the Default Database as it has to be master and not any other database selected.

Warning: Incorrect use of the Windows registry editor may prevent the operating system from functioning properly. Great care should be taken when making changes to a Windows registry. Registry modifications should only be carried-out by persons experienced in the use of the registry editor application. It is recommended that a complete backup of the registry and workstation be made prior to making any registry changes