If you received the message above, the steps down below will walk you through how to re-enable your SQL Server Service. In order for Retail Management System (RMS) to function properly, it will need the SQL Server (MSSQLSERVER) Service enabled.
Before we begin, we will need to locate the computer that is hosting the RMS database. If you only have 1 register then we have nothing to worry about, please continue on to the next section of this article (SQL SERVICE).
If you have multiple registers on site here is how to locate the RMS server.
- Use the start menu and search "Store Operations Administrator"
- Launch Store Operations Administrator
- Located at the top left is "File"
- Select "Configuration"
- You will want to write down the "Server Name" (picture down below).
- In the example above it says "local" meaning the database is stored on your current computer. If you have a different server name other than "local", please write this down for future reference.
- Once the server name has been acquired, all we need to do is match the "Server Name" to the computer's "System Name". We will need to go to each computer and check the "System Name" to figure this out.
- Easiest way is to search using the "Windows Start Menu", search for "System Info".
- Another way is to use the "Windows Key + Pause Break Key" located on your keyboard.
- Once you have figured which computer is the RMS Server, please continue on to "SQL SERVICE" steps down below.
- Launch the Task Manager by "CTRL + ALT + DELETE" and then select "Task Manager"
- Select the "Services" tab located at the top.
- Locate "SQL Server (MSSQLSERVER)"
- Right-click "MSSQLSERVER" and select start.
- Launch RMS!
Please reach out to our technical support team for further assistance.