How to use Remote Empty Database in SQL server to VMM installation - Step-by-step installation instructions

As you may already know during VMM installation you can use an existing database or specify a remote database. Remote empty database scenario is very important for many customers who've all SQL servers in their environment managed by database admins and all database creation requests go through and performed by DBAs. "As you may imagine […]

As you may already know during VMM installation you can use an existing database or specify a remote database. Remote empty database scenario is very important for many customers who've all SQL servers in their environment managed by database admins and all database creation requests go through and performed by DBAs.

"As you may imagine in these environments permissions that DBAs give to these databases needs to be as limited as possible. A TechNet documentation has the information about configuring a remote instance of SQL server for VMM, or check the step by step instructions on how to perform this operation below. These steps apply to SQL Server 2005 and will walk you through a specific example. It includes the whole process from the empty database creation in SQL server to VMM setup so that you can see the entire picture and granular permissions that are required," revealed Microsoft.

[Source]