Prepare the databases

The Mediasite databases are a core component of any Mediasite Video Platform deployment. You need two databases: one for Mediasite Video Platform and one for the site. Mediasite Video Platform supports Microsoft SQL Server as its database servers. For all installations, you must prepare the databases before you install Mediasite Video Platform software.

To prepare the Mediasite databases:

1.  Create two empty databases on the database server. When you configure Mediasite Video Platform, one database will be the Mediasite Platform database while the other one will be the site database.

2.  Enable snapshot isolation and read committed snapshot on the site database. If these features are not enabled when you add a site and specify the site database, you will receive a message that provides a SQL query script that should be run by your database administrator.

3.  Create a database user with owner-level permissions for the empty databases. The Mediasite Video Platform installer uses these credentials, specified during the configuration process, to create the tables in the databases and populate them with values.

4.  If using Windows integrated security, specify a database user with full permissions for ASP.NET on the server.