-
Title
"Could not obtain exclusive lock on database 'model'. Retry the operation later." -
Description
When adding a SQP PI repository database, the process fails because it couldn't get a lock on the model database.
A message similar to the following appears in the log files
Caused by: java.sql.SQLException: Failed to execute SQL:
create database [{DBNAME}] on primary ( name=N'{DBNAME}',filename=N'{FILE LOCATION}\{DBNAME}.mdf',size=65536KB,filegrowth=65536KB) log on ( name=N'{DBNAME_log',filename=N'{FILE LOCATION}\{DBNAME}.ldf',size=65536KB,filegrowth=65536KB)
Param: [N/A]
Connection Details: MSSQLProfile{host='{HOSTNAME}', instance= '{INSTANCENAME}', username='{DOMAIN\USERNAME}', authType= 'WINDOWS_CUSTOM', port= '0' useNTLMv2= 'true', socketTimeout= '0', database= 'null', secureConnection= 'REQUEST', packetSize= '0', ApplicationIntent= 'NONE', enforceSSLVersion= 'NONE', lockTimeout= '10000', codePageOverride = '', selectMethod='' }Cause:
Could not obtain exclusive lock on database 'model'. Retry the operation later.
Error Code: 1807
SQL State: S0003 -
Cause
SQL Server creates a copy of the model database to build new databases.
-
Resolution
Close any open SSMS or SQL application connections presently accessing the Model database.