Killing individual connections to the SiriusSQL database

A good way to ensure that no one is using the database is to kill any individual connections to the SiriusSQL database.

To kill individual connections to the database in SQL Server 2008/2012:

1. Run SQL Server Management Studio; log in as the SA user.

2. Select double-click on Activity Monitor icon within the toolbar

3. Click on Processes to bring up a dialog of all open connections.

4. Any running Salesware modules are connected as the sirius or siriusweb user to the SiriusSQL database. If you see any connection where the User column is sirius or siriusweb and the Database column is SiriusSQL, right-click on that row and select Kill Process.

Note: The row may not be deleted, but the connection is killed (causing that Salesware application to eventually error out with a connection error).

5. If any other connection is using the SiriusSQL database but is not the sirius or siriusweb user, the case may be that someone is connected via another non-Salesware application, such as MS Excel or Crystal Reports. You can kill those connections as well.