SQL Database for SCCM2012

Posted on 2014-08-07
Last Modified: 2014-08-08
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 ?

Question by:jskfan
    LVL 23

    Expert Comment

    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.
    LVL 16

    Accepted Solution


    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:


    Author Comment

    You are correct Mike, it was the ADK, I changed the instance and managed to see the Databases of SCCM

    Author Closing Comment

    Thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    The article will show you how you can maintain a simple logfile of all Startup and Shutdown events on Windows servers and desktops with PowerShell. The script can be easily adapted into doing more like gracefully silencing/updating your monitoring s…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now