SEC 5.41 fresh install, DB failing to install.

https://blogs.msdn.microsoft.com/poojakamath/2014/12/23/could-not-obtain-exclusive-lock-on-database-model-retry-the-operation-later-create-database-failed/

looks worth following as does:

https://blog.sqlauthority.com/2016/05/25/sql-server-fix-error-1807-not-obtain-exclusive-lock-database-model-retry-operation-later-part-2/

Regards,

Jak

I saw this reply when searching for a solution and unfortunately with me not being familiar with SQL many of the things they say to do are very foreign to me.  I'm not sure how to go about doing what they are describing.  I am going to see if I can figure out how to change the user access level on the model DB as one comment mentioned but once again I don't even know where to go to change that setting so I'll just be poking around.

I saw this reply when searching for a solution and unfortunately with me not being familiar with SQL many of the things they say to do are very foreign to me.  I'm not sure how to go about doing what they are describing.  I am going to see if I can figure out how to change the user access level on the model DB as one comment mentioned but once again I don't even know where to go to change that setting so I'll just be poking around.

Do you have SQL Management Studio Installed?  That is probably the first step.

Depending on which version of SQL Express you have, here are a few links:

Microsoft® SQL Server® 2008 Management Studio Express
https://www.microsoft.com/en-gb/download/details.aspx?id=7593

Microsoft SQL Server 2008 R2 RTM - Management Studio Express
https://www.microsoft.com/en-gb/download/details.aspx?id=22985

Microsoft® SQL Server® 2012 Express
https://www.microsoft.com/en-us/download/details.aspx?id=29062
Management Studio is part of this package.

Once you have that installed you want to point it at your Sophos SQL instance.
See: https://community.sophos.com/kb/en-us/113030 to determine the one in use.

Then you may need to know which databases belong to which version of Sophos Enterise Console, in this case see: https://community.sophos.com/kb/en-us/17323

Regards,

Jak

I've currently stripped all SQL 2012 programs off, but yes I will be reinstalling 2012 runtime and then the management studio.  Once I have that all on there I will be poking around to see if I can find out how to do this.

"Put model in RESTRICTED_USER mode, then app was able to create a new DB….which was in RESTRICTED_USER mode.  Put both DBs back into MULTI_USER mode."

Since I do not know how to do this.

"So we dropped and recreated the login XLOGIN\Administrator and the issue hasn’t occurred after this."

Once SQL Management Studio is installed I would probably connect to the Sophos SQL instance.  

Then in a new query window execute the commands in this article:

https://blog.sqlauthority.com/2016/05/25/sql-server-fix-error-1807-not-obtain-exclusive-lock-database-model-retry-operation-later-part-2/

If the Kill command is successful, then you can close SQL Management Studio and retry creating the database.

Installed SQL express 2012 SP2 manually, installed the Management studio and then attempted this "fix"

"Put model in RESTRICTED_USER mode, then app was able to create a new DB….which was in RESTRICTED_USER mode.  Put both DBs back into MULTI_USER mode."

And that did not fix it or allow me to install SEC 5.4.1.

I then attempted to run the Kill script from the link on the blog.sqlauthority.com site and I had to run this script multiple times till it came back with no result and then I was able to install SEC 5.4.1  So at this point I'm up and running.

Query that I ran using SQL Server Sanagement Studio.

SELECT 'KILL ' + CONVERT(varchar(10), l.request_session_id)
 FROM sys.databases d, sys.dm_tran_locks l
 WHERE d.database_id = l.resource_database_id
 AND d.name = 'model'

Good news!

Thanks for the update.