how to grant the service account on the MS SQL

Question

I installed MS SQL 2008 R2 on my 2008R2 server, which is required for installing SCVMM2012
When installing the SQL instance, I selected Windows auth only.
When I try to install SCVMM2012, some MS SQL error message appears during SCVMM2012 installation process like following.
"Access to the SQL Server instance DC1 was denied."
This means ,I will likely need to grant the service account so that SCVMM can access to the SQL instance.
So, Please let me know  how to grant the service account on the MS SQL 2012.

Answer 1

You have to create a login in SQL Server. This is the service account which is going to run SCVMM2012. Check this article how to create a login. This is for SQL Login but the procedure is similiar. You just have to check Windows Authentication radiobutton.

http://www.youtube.com/watch?v=w_oMcRGzDNs

You have to grant to the service account login the required permissions to create a database. You can make it temporary a sysadmin (you can do it from the Server Role page when you create the login). And then remove it from sysadmin, but set it as owner for the created database for SCVMM2012.