View source for EEPOS:Database Not Online and Multi-User

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


[[File:SSMSLogin.jpg]]



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


[[File:EEPOSOffline.jpg]]



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.

<pre>ALTER DATABASE EEPOS SET ONLINE</pre>

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.


[[File:EEPOSOnline.jpg]]




== 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 [http://theoracle.magentaretail.com.au/index.php?title=EEPOS:Database_Not_Online_and_Multi-User&action=submit#Connect_to_Magentapos_SQL_Instance 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.
<pre>
USE master
ALTER DATABASE EEPOS
SET MULTI_USER;
GO</pre>

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.

[[File:CommandComplete.jpg]]


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