Setup guide

Migrating a Media Services Database
43
After you move the database, delete and recreate the dms user in the SQL database as
described in the following procedure.
Recreating the dms User in the Updated Database
This procedure is only required if you are migrating an existing database to the AS3000.
The Media Services Engine automatically creates a user named “dms.” After you migrate
the database you must delete this user and recreate it.
To delete and recreate the dms user:
1. Open the Microsoft SQL Server Management Studio Express application on the
AS3000.
2. Navigate to Databases/dmsdb/Security/Users and select the dms user, as shown in the
following illustration.
3. Right-click the dms user and delete it.The system may state that the user owns a schema
and ask if you want to delete it. Click OK and follow the system prompts to delete the
user.