SQL Database for SCCM2012

I have installed SCCM on Windows server 2012. I have installed SQL server 2012 on the same computer as SCCM 2012.
SCCM is working fine with no issue. However I noticed in SQL Visual Studio Manager there is no database related to SCCM, it shows just system Databases.
Any idea ?

Thanks
sq
jskfanAsked:
Who is Participating?
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.

nemws1Database AdministratorCommented:
We're running SCCM on SQL 2012 as well.  We have one instance that has an SCCM_CAS database and a couple SSRS (Reporting) related databases.  However, one of our "config "databases for SCCM is as you describe - it looks blank.  I asked our Operations team about this (I wanted to turn this server off) but they insist it needs to be there and that SCCM is configured to use it.  I'm behooved as well, since I can't see it using it for anything.

I'd be interested to hear if anybody has any experience/explanation of this.
0
Mike TLeading EngineerCommented:
Hi,

You're looking at the wrong SQL instance. A SQL instance is a unique name that identifies a database, so you can install SQL and have lots of databases hosted by the same install.

To see the CM database connect to the server\<your ConfigMgr site code>

ADK sounds like the Windows ADK at a guess, but whatever it is, it's empty.

It's simply not possible to install SCCM without creating a SQL database, so whatever it is you have in that screenshot it's not the SCCM instance.

See this walkthrough:
http://blogs.technet.com/b/aviraj/archive/2013/05/14/system-center-2012-sp1-configuration-manager-sccm-2012-installation-sql-server-database-error-when-using-named-instance.aspx

Mike
0

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
jskfanAuthor Commented:
You are correct Mike, it was the ADK, I changed the instance and managed to see the Databases of SCCM
0
jskfanAuthor Commented:
Thank you
0
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
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.