[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 187
  • Last Modified:

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
0
jskfan
Asked:
jskfan
  • 2
1 Solution
 
nemws1Commented:
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
 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now