Manually Configure SQL Server Permissions

The Recast Management Server requires a SQL Server version 4.0 or higher. This can be the free SQL Server Express version or a full version of SQL. The account installing Recast Management Server will need SysAdmin permission in the SQL instance to create the database, after the database has been created the SysAdmin privilege can be removed. The Test SQL Connection button can verify connectivity to the SQL Server if the account running the installation has permissions to remotely connect.

If the account running the Recast Management Server installer does not have access to create a SQL database, you can pre-create the Recast Management Server database and assign permissions manually.

There are two users that will need to be assigned permissions in SQL: the computer account and the IIS AppPool\Recast Management Server account.

NOTE: The IIS AppPool\Recast Management Server account will not exist until after the installation is finished, so db_owner permissions will need to be assigned after installation.

Pre-create the RecastManagementServer Database

If database administrators aren't able/willing to give SysAdmin rights to the user account running the installation, the database administrator can manually create a database named RecastManagementServer.

Add the Computer Account via SQL Server Management Studio (SSMS)

If the computer account for the Recast Management Server computer does not exist in SQL, users will need to add the account manually. The computer account will have the following name format: domain\computername$

The computer account will need to be added in two places, as a Login Account, and as a Database User account.

Add the computer account as a Login Account

To create the account:

1. Open SSMS and expand the folder of the server instance in which you want to create the new login.

2. Right-click on the Security folder.

3. Point to New and select Login.

4. In the Login - New window, on the General page, enter the name of the domain\computer$.

Adding Login Account

5. On the User Mapping page, in the Users mapped to this login section, select RecastManagementServer.

6. In the Database role membership section, select db_owner.

Adding db_owner to User Mapping