Error 27506. Error executing SQL script CreateSEEMSDb. Line 185. Changed database context to 'master'. (5701)

Products

• Endpoint Encryption

Issue/Introduction

Error when installing Symantec Endpoint Encryption 7.0 Manager with SQL 2005.

Symptoms
You receive the above error during the installation of the SEE manager.

The installation log shows one of the following errors:

1. Error executing SEEMSDb creation script: login [dbuser] creation failed The server principal 'dbuser' already exists.
2. Error executing SEEMSDb creation script: login [dbuser] creation failed Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.
3. Error executing SEEMSDb creation script: database [SEEMSDb] creation failed Cannot create file

'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SEEMSDb.mdf' because it already exists.

Cause

Something is preventing the SQL script from completing.

Resolution

There are multiple solutions for this error depending on the cause listed in the installation log.

First, ensure the database user does not exist in the SQL instance.

1. Log into the SQL Server Management Studio
2. Expand the instance and go to Security
3. Go to Logins
4. If the user account you were attempting to create already exists, delete the account. (Note: This is not the 'sa' account.)

Once the account is deleted, proceed with the installation again and ensure that the password you supply the new database user is complex enough.

For the following error:
"Error executing SEEMSDb creation script: database [SEEMSDb] creation failed Cannot create file
'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\SEEMSDb.mdf' because it already exists."

This error can occur if the SEEMSDb is not removed from SQL Server prior to uninstalling SQL Server. The mdf/ldf files will be left in the DATA directory. If you would like to proceed with a fresh installation, you will need to remove these mdf/ldf files from the DATA folder.

For all other errors, please generate a log of the installation using the following command and contact technical support.

MSIEXEC /i "[path]\Symantec Endpoint Encryption Management Server.msi" /lvx [logpath]\logfile.log