EEPOS:Database Not Online and Multi-User

From EnablerWiki
Jump to navigationJump to search

Database Offline or in Single-User Mode

The database may be put into ‘offline’ or single user mode due to a failed\interrupted windows update or unexpected shutdown.

Perform the below steps to mark the database as online or to mark the database as multi-user.


Bring EEPOS Database Online

Stop EEPOS Service

EEPOS and the POS Service need to be closed before performing the steps to bring the database online or set to multi-user.

1. Close EEPOS.

2. Open the Windows Services screen (Control Panel → Administrative Tools → Services)

3. Stop the EEPOS Service – MAGENTAPOS service.


Backup EEPOS Database Files

Perform a backup of the EEPOS Database files.

1. Browse to C:\Program Files\Microsoft SQL Server\MSSQL11.MAGENTAPOS\MSSQL\DATA

2. Make a copy of the EEPOSdat.mdf and EEPOSlog.ldf files.

Note: If a prompt appears saying that the files are currently in use you will need to temporarily stop the SQL Service.


3. Open the Windows Services screen (Control Panel → Administrative Tools → Services)

4. Stop the SQL Server (Magentapos) service.

5. Attempt to copy the EEPOSdat.mdf and EEPOSlog.ldf files again.

6. Start the SQL Server (Magentapos) service again.


Connect to Magentapos SQL Instance

Open SQL Management Studio on your EEE Server. Then connect to the tills local SQL Database over the network using the below details.

Server Name – Hostname\magentapos Example: If hostname of till is Server40, then Server name should be Server40\magentapos

Authentication – SQL Server Authentication

Login – Magentasupport

Password – Please contact Magenta Support for the SQL Database Password.



Bringing Database Online

Once connected to the till’s Magentapos SQL Instance you will notice that the EEPOS database is shown as offline as per the screenshot below.



Follow the below steps to bring the database back online.

1. Begin a new query by selecting New Query (CTRL+N).

2. Copy the below SQL command into the new query window. 

ALTER DATABASE EEPOS SET ONLINE

3. Select Execute (F5) to run the command.

4. Once this command has been run, select refresh in the Object Explorer (Red square below). The EEPOS database should show as online.




Set Database Multi-User

If your database was diagnosed as being in Single-User mode, please follow the steps below.


Stop EEPOS Service

EEPOS and the POS Service need to be closed before performing the steps to bring the database online or set to multi-user.

1. Close EEPOS.

2. Open the Windows Services screen (Control Panel → Administrative Tools → Services)

3. Stop the EEPOS Service – MAGENTAPOS service.


Set Database as Multi-User

1. Connect to the SQL Instance using the above Connect to Magentapos SQL Instance instructions.

2. Begin a new query by selecting New Query (CTRL+N).

3. Copy the below SQL command into the new query window. 

USE master
ALTER DATABASE EEPOS
SET MULTI_USER;
GO

4. Select Execute (F5) to run the command.

5. Once completed the results windows should show Command(s) completed successfully message as per the below screenshot.


If the command fails to complete, please contact Magenta Support for additional assistance.

Retrieved from "https://theoracle.magentaretail.com.au/index.php?title=EEPOS:Database_Not_Online_and_Multi-User&oldid=1494"