AD Connector Utility installer fails to create database
search cancel

AD Connector Utility installer fails to create database


Article ID: 232328


Updated On:


Information Centric Analytics


When attempting to reinstall the Active Directory Import Utility after deleting the ActiveDirectoryDW database from SQL Server, the following error is returned when selecting the Create new database option and providing the name ActiveDirectoryDW:

SQL Server database name [ActiveDirectoryDW] already exists.
Use existing database or choose a new name.

The ActiveDirectoryDW database is not visible in SQL Server Management Studio's Object Explorer but is confirmed to exist by the following query:

USE msdb;
FROM sys.databases
WHERE [name] = 'ActiveDirectoryDW'


Release : 6.5.4

Component : Active Directory Import Utility


This issue occurs because the ActiveDirectoryDW database reference is removed from Object Explorer but the database files remain on the file system and the database is still registered with SQL Server. When this occurs, the explicit permission VIEW SERVER STATE is required to view the database's properties. Accounts assigned to the sysadmin role may also be affected. See Microsoft KB article KB2714785 for additional information.


If using SQL Server 2012, install cumulative update package 2 (CU2).

For later versions of SQL Server, grant the permission VIEW SERVER STATE to the account under which the Active Directory Connector Utility installer is being run, then cancel and re-run the installer.