SQL Server Account for Creating Archive Databases
When an archiving job runs it creates a separate new database on the SQL Server instance hosting your Alloy Navigator database. That means that you must specify an SQL Server account that will be used for creating archive databases. In order to create new databases on the SQL server and access them, this SQL Server account must be a member of dbcreator and securityadmin server roles. You can specify any of the existing SQL server accounts or create a new one, as long as this account has the required dbcreator and securityadmin roles on the SQL server. This can be a dedicated account for the job, or a real user’s account who is responsible for maintaining data archives.
To grant these mandatory roles to the SQL Server account
- On the SQL Server computer, start SQL Server Management Studio.
- In the Object Explorer, locate and expand the node for your server.
- Expand the Security folder.
- Double-click Logins to display SQL Server accounts in the Object Explorer Details.
- Right-click the desired account and choose Properties from the pop-menu.
- In the Login Properties dialog box, select the Server Roles page.
- Under Server roles, select dbcreator and securityadmin roles.
- Click OK.