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.