Problem
Earlier versions of NorthStar Order Entry did not add the Administrators group to the SQL Server sysadmins role. This meant that users could not access the NorthStar databases in SQL Server.
This document demonstrates how to add the Administrators group to the sysadmins server role.
Procedure for current versions of Order Entry
In current versions of NorthStar Order Entry, Web Admin has a tool specifically for this task. Choose "Fix SQL Authentication" on the Utilities page.
Procedure for previous versions of Order Entry
| Warning |
|---|
This requires restarting SQL Server and possibly Order Entry, so we recommend doing this while the site is closed. |
...
If you are using Windows 10, SQL Server Configuration Manager may not be listed in the Start menu. In this case go to Start → Run and run one of the following commands:
- "SQLServerManager12.msc" (SQL Server 2014)
- "SQLServerManager11.msc" (SQL Server 2012)
- "SQLServerManager10.msc" (SQL Server 2008)
Step 2: Putting SQL Server in single-user mode
In the "SQL Server Services" node, stop all SQL Server services. Make a note of which ones were started, you will need to restart them in step 4.
Find the SQL Server service named "SQL Server (SQLEXPRESS)". The instance name might be something other than "SQLEXPRESS", but the name should just be "SQL Server". Right-click and click Properties.
Under the Startup Parameters tab, add a new parameter "-m" (this is a hyphen and a lowercase m, with no whitespace).
Save these settings and restart ONLY the "SQL Server (SQLEXPRESS)" service.
...
Restart SQL Server and continue with step 4.