Set up the account in SQL Server

In this section you will learn: How to create a user account and map it as dbo for the restored databases, using the graphical interface or the script provided.

1. Open the SQL Server Management Studio and login to the instance as an administrator.

2. Select <ServerName>\Security\Logins, right click and select New Login from the context menu.

   1. In the Login name text box enter NT Authority\Network Service, or click Search to search for Network Service.

   2. Select the Windows authentication option.

      

      Note: Additionally, it is possible to use service accounts for connectivity. However, this document does not cover that scenario. Please contact support if you would like to know more.
      Using SQL Server authentication is not recommended.

3. Select User Mapping on the left-hand side.

4. Select the Map check box for the following databases and enable the following options in the Database role membership section:

   • CrudeSync: db_owner, public

   • SuiteServer: db_owner, public