LicenseWatch FAQ

Creating the LicenseWatch Database Manually

Run th following script to create the database:

CREATE DATABASE LicenseWatchPlatinum
ON
( NAME = LicenseWatchPlatinum,
FILENAME = 'D:\SQLDATA\LicenseWatchPlatinum.mdf'
)
LOG ON
( NAME = 'LicenseWatchPlatinum_Log',
FILENAME = 'D:\SQLDATA\LicenseWatchPlatinum.ldf'
)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
sp_dbcmptlevel LicenseWatchPlatinum, 80

Create a login:

CREATE LOGIN [LicenseWatch] WITH PASSWORD='', DEFAULT_DATABASE=[LicenseWatchPlatinum], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC sys.sp_addsrvrolemember @loginame = N'LicenseWatch', @rolename = N'dbcreator'
GO

The login must be mapped to user dbo and must be member of db_owner: