AD Connector Utility installer fails to create database

Products

• Information Centric Analytics

Issue/Introduction

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;
GO
SELECT *
FROM sys.databases
WHERE [name] = 'ActiveDirectoryDW'
;

Environment

Release : 6.5.4

Component : Active Directory Import Utility

Cause

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.

Resolution

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.