Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Patch Manager > Creating database failed. Details: An exception occurred while executing a Transact-SQL statement or batch.

Creating database failed. Details: An exception occurred while executing a Transact-SQL statement or batch.

Created by Leif Amland, last modified by MindTouch on Jun 23, 2016

Views: 121 Votes: 0 Revisions: 4

Overview

This article addresses the issue where the following error message appears after completing the Patch Manager Configuration Wizard:

The configuration wizard has failed

Creating database failed. Details: An exception occurred while executing a Transact-SQL statement or batch.

Details: Could not obtain exclusive lock on database 'model'. Retry the operation later.

Environment

Patch Manager 2.1

Cause 

This can occur when the Configuration Wizard is running on top of an existing Patch Manager Database.

Resolution

​Option 1

  1. Uninstall SQL Server 2008 R2. 
  2. Install Patch Manager Full 2.1 w/ SQL.  

Option 2

Choose a different database instance to install Patch Manager on.

 

 

Last modified
01:01, 23 Jun 2016

Tags

Classifications

Public