Troubleshooting: Database ‘AED moble’ is already open and can only have one user at a time

From AutoCount Resource Center

Question: When I try setting database to multi users, system prompted message “Database ‘AED_moble’ is already open and can only have one user at a time.”


Possible Reason:

There is a user still accessing the database.


Solution:

1)Run the following query to find out the SPID:

select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid where d.name = ‘db_name’


  • db_name = AED_moble



2) From my example, the SPID from the result is 54.


3) Then run the following query to kill SPID and set multi users.

kill 54
GO

exec sp_dboption 'AED_moble', 'single user', 'FALSE'
GO


OR

ALTER DATABASE AED_moble SET MULTI_USER WITH ROLLBACK IMMEDIATE


By: Michelle 220616, Lay Swan 220628, P220629


Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations