Setting dbowner permissions on BoringBase

During the installation of Boring Server version 5 a SQL database called BoringBase is created but, in some cases, additional permissions will need to be manually added.  Specifically, if the Milestone Services are running as a Windows logon user vs NETWORK SERVICE.  

If you are running your Milestone services as NETWORK SERVICE then this step is not necessary.

Checking your Milestone services

To check if your Milestone services are running using a Windows user vs NETWORK SERVICES do the following: 

• Click the Windows menu button
• Search for services.msc
• When in the services dialog, look for services starting with Milestone
• If you see anything other than NETWORK SERVICES in the Log On As then continue
• Make note of the username in the Log On As column for later use

Checking permissions on BoringBase

If you installed Boring Server while logged in to Windows as the user identified as running you Milestone services, then chances are the permissions have already been added to the BoringBase.  Here is how you check.

• Open up Microsoft SQL Management Studio
• Log in
• Expand Databases > Boring Base > Security > Users
• Double click on the dbo user
• Check the Login name
  • As in the image below, if the Login name matches that of the user running your Milestone services you can stop here
  • If the user is different please continue to the next step

Adding permissions to BoringBase

We will now add the user that we identified in the first step as dbowner of the BoringBase database.

• Open up Microsoft SQL Management Studio
• Log in
• Expand Databases > Boring Base > Security > Users
• Right click on the Users folder and select New User

• Database User - New dialog will appear
• Change User Type to Windows User
• Click the ... next to the User name and search for the name of the user you identified above.
  • In our screenshot the user is milestone
• Do the same for Login Name

• Click on Membership
• Check the box for dbowner
• Click OK