Came across an issue today where we were unable to change our SQL database from Single to Multi User Mode. The error we received when trying to do this was.

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SQLServer.Connectioninfo)

Database ‘databasename’ is already open and can only have one user at a time. (Microsoft SQL Server, Error: 924

Basically this is due to a connection open on the database as specified in the above error. So the first step was to find out what was connected to do this. To do this we ran the following SQL query (add your database name in the query below)

select spid from master..sysprocesses where dbid = db_id(‘databasename‘) and spid <> @@spid

This will display the SPID name in our case it was 60.

Now we need to kill the SPID so that we are allowed to connect via running the below query (amend to your SPID Value)

Kill 60

We were then able to change the database to multi user mode.

Had an issue recently where we couldn’t get the “SQL Server Reporting Services (MSSQLSERVER)” service to start.

In the end it was quite a simple fix, we added the below registry key.

• Open Reg Edit
• Navigate to the following registry key “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control”
• Right-click Control, and create a new DWORD with the name “ServicesPipeTimeout”, and then press ENTER.
• Right-click “ServicesPipeTimeout”, and then click Modify.
• Select Decimal, and type 60000 (this will allow the service 1 minute to start)
• Restart Machine

This sorted it for us.