Error: 'SQL Server message 911: Could not locate entry in sysdatabases for database 'sqlcqr_master'. (NETIQKB38208)

fact
VigilEnt Security Agent for Microsoft SQL Server 1.0x

symptom
Error: 'SQL Server message 911: Could not locate entry in sysdatabases for database 'sqlcqr_master'. No entry found with that name. Make sure that the name is entered correctly.(line 1)'

cause
The sqlcqr_master database has not been created on the target Microsoft SQL Server.

fix
To correct this error, create a sqlcqr_master database on each monitored Microsoft SQL Server prior to installing the Audit Managerschema.

note

The following is a sample script for creating the sqlcqr_master database:

-- =============================================
-- Sample Create Template for the
-- 'sqlcqr_master' database.
-- =============================================

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'sqlcqr_master')
 DROP DATABASE [sqlcqr_master]

GO

CREATE DATABASE [sqlcqr_master]  ON (NAME = N'sqlcqr_master_Data',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\sqlcqr_master_Data.MDF' ,
SIZE = 50, FILEGROWTH = 10%) LOG ON (NAME = N'sqlcqr_master_Log',
FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\sqlcqr_master_Log.LDF' ,
SIZE = 5, FILEGROWTH = 10%)

GO

Formerly known as NETIQKB38208