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

From AutoCount Resource Center
Revision as of 09:27, 29 June 2022 by LaySwan (talk | contribs) (Created page with "'''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.” File:Set multiuser error1.png <u><b>Possible Reason:</b></u> There is a user still accessing the database. <u><b>Solution:</b></u> 1)Run the following query to find out the SPID:<br/> select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame from sysprocesses p inner join sysda...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.”

Set multiuser error1.png


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


Set multiuser error2.png


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

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations