Deployment Scanner report fails on the SQL Server Permissions section when using the SQL Server name.

book

Article ID: 100029923

calendar_today

Updated On:

Description

Error Message

Enterprise Vault requires database creator or higher permissions on SQL Server.
Test Failed for the following reason: [DBNETLIB][ConnectionOpen (Invalid Instance()).] Invalid connection.

Resolution

Overview:
This error is seen when Enterprise Vault is installed in the non default instance of SQL.  In order for the Deployment Scanner to communicate successfully, the SQL Server named instance must be used instead of the fully qualified server name of the SQL Server.  When running the Deployment Scanner Server Configuration the Microsoft SQL Server named instance should be entered.

Example:
SQLServer.MyDomain.com\InstanceName


Solution:
Enter the instance name in the format above in the Microsoft SQL Server section in the Server Configuration of the Deployment Scanner.  (For more information on the Deployment Scanner, see article 289859 in the Related Documents section.)

[For Windows Server 2008]
If you run deployment scanner on Windows Server 2008 environment (x64 as well) , need to check your FIREWALL setting carefully. (e.g. temporary disable the firewall and try its connection)
May requires to run SQL Server Browser in SQL Server as well.

Issue/Introduction

Deployment Scanner report fails on the SQL Server Permissions section when using the SQL Server name.