The currently logged in account (or the SQL Account you specify) must have either db_creator or SysAdmin rights on the SQL server if a new database is being created. For example if installing for the first time, if upgrading and selecting a different SQL server or if upgrading from RMAD to RMAD Forest Edition as there is Persistence database created.
If need be, use SQL Server Management Studio to grant the account the necessary rights.
For a full SQL installation (not Express version):
- Open SQL Server Management Studio and connect to the SQL server where the RMAD database will be hosted
- Expand Security
- Expand Logins
- If the account already exists, right click it and select Properties
- Click Server Roles
- Select db_creator or sysadmin and click OK
- If the account is not listed, right click Logins and select New Login
- If creating an SQL Login, select SQL Server Authentication and enter the details
- If creating an account for a Domain user select Windows authentication
- Click Search
- Click Locations and change to your domain
- Enter the name of the user and click Check Names
- Click OK
- Click Server Roles
- Select db_creator or sysadmin and click OK
For SQL Express:
- Ensure you have downloaded and installed the correct version of SQL Server Management Studio Express based on the version of SQL Express you have installed
Open SQL Management Studio Express and connect to the Express instance:
- If using versions prior to 8.6, the default instance name is servername\questrmad
- If using versions 8.6 and later the default instance name is servername\dellrmad
Once connected, expand the servername | Security
Expand Logins
If the account already exists, right click it and select Properties
Click Server Roles
Select db_creator or sysadmin and click OK
If the account is not listed, right click Logins and select New Login
If creating an SQL Login, select SQL Server Authentication and enter the details
If creating an account for a Domain user select Windows authentication
Click Search
Click Locations and change to your domain
Enter the name of the user and click Check Names
Click OK
Click Server Roles
Select db_creator or sysadmin and click OK
Note: By default, the only account granted SysAdmin rights to an SQL Express instance is the account which installed the instance. If you do not know which account this is or need to grant SysAdmin rights to another account to gain access to the instance, please see the following KB Article:
https://support.quest.com/kb/122000