Hi When I tried to create a search service application got this error.

----------------------------------------------------------------------------------------------------------------------------

Errors were encountered during the configuration of the Search Service Application.
System.Data.SqlClient.SqlException: Could not obtain exclusive lock on database 'model'. Retry the operation later. CREATE DATABASE failed. Some file names listed could not be created. Check related errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.SharePoint.Administration.SPDatabase.EnsureSqlDatabase(SqlConnectionStringBuilder connectionString, Version& actualVersion) at Microsoft.SharePoint.Administration.SPDatabase.SetDatabaseOptions(SqlConnectionStringBuilder connectionString, Dictionary`2 options) at Microsoft.SharePoint.Administration.SPDatabase.Provision(SqlConnectionStringBuilder connectionString, TextReader provisioningScriptStream, Dictionary`2 options) at Microsoft.Office.Server.Search.Administration.SearchDatabase.Provision(Boolean sqlRestore) at Microsoft.Office.Server.Search.Administration.SearchPropertyStoreDatabase.CreateNewOrUseEmpty(SPFarm farm, SPDatabaseParameters databaseParameters) at Microsoft.Office.Server.Search.Administration.SearchServiceApplication.Create(String name, SearchQueryAndSiteSettingsService service, SPIisWebServiceApplicationPool applicationPool, SPIisWebServiceApplicationPool adminApplicationPool, SearchServiceApplicationType applicationType, SPDatabaseParameters adminDBParameters, SPDatabaseParameters propertyStoreDBParameters, SPDatabaseParameters crawlStoreDBParameters, SPPartitionOptions partitionOptions) at Microsoft.Office.Server.Search.Administration.SearchService.<>c__DisplayClass1.b__0() at Microsoft.Office.Server.Search.Administration.SearchService.CreateApplication(String name, CreateSearchApplicationDelegate createSearchAppDelegate) at Microsoft.Office.Server.Search.Administration.SearchService.CreateApplication(String name, SearchServiceApplicationType applicationType, SPDatabaseParameters adminDBParameters, SPDatabaseParameters propertyStoreDBParameters, SPDatabaseParameters crawlStoreDBParameters, SPIisWebServiceApplicationPool applicationPool, SPIisWebServiceApplicationPool adminApplicationPool, SPPartitionOptions partitionOptions) at Microsoft.Office.Server.Search.Administration.SearchService.CreateApplication(String name, SearchServiceApplicationType applicationType, SPIisWebServiceApplicationPool applicationPool, SPIisWebServiceApplicationPool adminApplicationPool) at Microsoft.Office.Server.Search.Administration.SearchService.CreateApplicationWithDefaultTopology(String name, Type serviceApplicationType, SPIisWebServiceApplicationPool applicationPool, SPIisWebServiceApplicationPool searchAdminApplicationPool, SearchServiceApplicationType ssaType) at Microsoft.Office.Server.Search.Administration.SearchConfigWizard.CreateSearchApp() at Microsoft.Office.Server.Search.Administration.SearchConfigWizard.ProvisionSearchServiceApplication() at Microsoft.Office.Server.Search.Administration.SearchConfigurationJobDefinition.ExecuteTimerJob()

-------------------------------------------------------------------------------------------------------------------------------------------

Please assist to create it

You should check this with DBAs:

System.Data.SqlClient.SqlException: Could not obtain exclusive lock on database 'model'. Retry the operation later.

SP is not able to acquire lock on model DB. It needs to acquire lock to create new DBs for search.

Hope this

Hi,

This issue is about SQL. it may be caused by the following reasons:

1. Somebody exclusively open the Model database in different session
2. If more than one create database statements attempt to run simultaneously

Please disconnect and reconnect your SQL Server Management Studio Session.

There are two similar posts for your reference:

http://celticcodingsolutions.com/Blog/post/2014/01/22/SQL-Server-Unable-to-create-database-Exclusive-Lock-on-Database-model.aspx

http://aviadezra.blogspot.com/2015/01/could-not-obtain-exclusive-lock-on.html

Thanks,

Wendy