Skip to main content

Database Preparation

Login to SQL server as a user with server admin role and execute the following commands to create a database " MM " and a user " MM " with password " MM123! " (or another one):

Enable clr, and create the database and user:

EXEC sp_configure 'clr enabled', 1;
RECONFIGURE;
Go
 
CREATE LOGIN MM WITH PASSWORD = 'MM123!';
CREATE DATABASE MM;
ALTER DATABASE MM SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE MM SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE MM SET MULTI_USER WITH ROLLBACK IMMEDIATE;
ALTER AUTHORIZATION ON DATABASE::MM to MM;

Warning: The product relies on one assembly (named MIRRepo) which is loaded from binary and not from file. This binary is created with the SAFE permissions. So in addition to being the database owner, the MM user should be granted the CREATE ASSEMBLY permission.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!