Sage 100

Anybody ever seen this when installing Sage 100 Premium? Cannot get the installer to run successfully.

The message ""could not obtain exclusive lock on the database"" may indicate there is another process accessing the database. If you are certain no other processes should be accessing the database you may try either stopping and restarting the SQL services, or if necessary rebooting the server.

I have rebooted both the application server and the SQL server, netiher to any avail. When I run the following queries to find out what and who are using the 'model' database, all that's out there is a sleeping process waiting for input. I have even killed this SPID, but it makes no difference. SELECT request_session_id FROM sys.dm_tran_locks WHERE resource_database_id = DB_ID('Model') exec sp_who SPID

Does the MAS_SYSTEM database exist? If so, and if you have nothing to lose, you could try and DROP the database.

No, unfortunately the MAS_SYSTEM database is failing to get created.

Do you get the same process id if you run this query? SELECT * FROM sys.sysprocesses WHERE DB_NAME(dbid)='model'

Yep.

Try disconnecting and reconnecting in SSMS.

Is it possible the backup is running right now (late at night)? I know with Dell servers the AppAssure backup software caused an issue in this area. Maybe ask when their backup is scheduled to run and you work around that time