System Center VMM 2012 and SQL 2008

Hi All,

I am trying to setup a test environment for SCVMM 2012, and i hitting point where i cant get the Install to get past the SQL DB part.

We have a SQL server 2008 on our network but not on the Domain.

I have been able to contact the SQL DB using ODBC data sources wizard and see the DB that i have created for the SCVMM, but when i try to connect to the SQL using the SCVMM wizard it keeps saying "The Remote SQL Server administrator credentials provided are not valid BLah Blah BLah"

Does anyone here know why this is happening please as i have checked and the SA password is correct for the SQL DB and i have also tried creating a USER in the Admin group of the SQL server, but still no joy.

Any help would be greatly appreciated.


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Milind KoyandeCommented:
It could be due to SQL account didn't have any permissions to the vmm server. Try to add the SQL account as local admin on the VMM.
YellowbusTeamAuthor Commented:
How do you add a none Domain SQL server account to the admin group when it cant find it in its network directory?
Deepak ChauhanSQL Server DBACommented:
You have to add SCVMM admin account in to SQL server login with sysadmin permissions.
SolarWinds® IP Control Bundle (IPCB)

Combines SolarWinds IP Address Manager and User Device Tracker to help detect IP conflicts, quickly identify affected systems, and help your team take near instantaneous action. Help improve visibility and enhance reliability with SolarWinds IP Control Bundle.

YellowbusTeamAuthor Commented:
I already have a SCVMM account on the sql server in the local admin group but still nothing
Deepak ChauhanSQL Server DBACommented:
@I already have a SCVMM account on the sql server in the local admin group but still nothing

Ok can you check the permissions for this account in sql server.

1. connect sql server using ssms.
2. expand security folder > Login
3. check the property of SCVMM login account and assign sysadmin role if not already have.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
YellowbusTeamAuthor Commented:
Hi Deepak,

I have done the above and still am not getting any DBs showing, when i click on the instance name drop down, i get the credential error still even though i know is correct.

YellowbusTeamAuthor Commented:
This Strange, i have now got the SCVMM to connect to the SQL DB, whats strange is that when i use the local user account to try and connect to the DB it says wrong username or password etc, but when i use our domain as the prefix it connects.

There is a domain account called scvmm in a group for SCVMM that i have created on our DC this is what i have used to connect the SCVMM to the DB.

SQL is not on the Domain but i can still connect using Domain credentials???

Any idea why this would happen?

Deepak ChauhanSQL Server DBACommented:
Because Domain group\account has added in sql server logins.  If you will expand the security\login folder in ssms you can find that names there. But local user account does not exist there.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2012

From novice to tech pro — start learning today.