Install Sana into Microsoft Dynamics 365 Business Central

When you install Microsoft Dynamics 365 Business Central Server, you must identify the active directory account to provide credentials for the server. By default, Microsoft Dynamics 365 Business Central Server runs under the Network Service account. It is recommended to create a domain user account to run Microsoft Dynamics 365 Business Central Server service. This account should not be an administrator either in the domain or on any local computer. A dedicated domain user account is considered more secure because no other services and therefore no other users have permissions for this account.

Give the necessary SQL database privileges to the Microsoft Dynamics 365 Business Central Server service account

Step 1: Open SQL Server Management Studio and connect to the instance where Microsoft Dynamics 365 Business Central database is installed.

Step 2: Create a login for the Microsoft Dynamics 365 Business Central Server account.

Step 3: Add the login as a user on the master database.

Step 4: Grant the Microsoft Dynamics 365 Business Central Server login permissions on the master database. Grant "Select" permissions for this user under the properties of the "dbo.$ndo$srvproperty" system table.

Step 5: Grant the login the following database roles on the Microsoft Dynamics 365 Business Central database: db_datareader, db_datawriter, db_ddladmin.

Step 6: Under the permissions properties of the Microsoft Dynamics 365 Business Central database, on the "Explicit" tab, grant the "View database state" permissions for Microsoft Dynamics 365 Business Central Server login.

Set up Microsoft Dynamics 365 Business Central Server service to run under the domain user account

Step 1: Open Microsoft Windows Services console.

Step 2: Select "Microsoft Dynamics 365 Business Central Server" service and open its properties.

Step 3: On the "General" tab, select "Automatic" startup type.

Step 4: On the "Log On" tab, select "This account" option and specify the domain user account that you have created to run the Microsoft Dynamics 365 Business Central Server service.

Step 5: Restart the Microsoft Dynamics 365 Business Central Server service.