Solved

SCCM Install Cannot Connect to SQL Database

Posted on 2016-07-27
8
70 Views
Last Modified: 2016-08-02
Fresh install of Windows Server 2012 R2 and SQL Express 2008 R2 but during install of SCCM, it cannot detect the recently installed SQL (Setup is unable to connect to SQL server with the connection information provided).  All defaults were taken for the SQL install; firewall was stopped. I saw that neither SQL Browser or Agent were started nor the port (1433) active. So I attempted to start the browser and port 1434 came active but I cannot start the agent and there are no errors listed in the event viewer.  Both SQL and  SCCM are on the same machine.
0
Comment
Question by:ejefferson213
  • 4
  • 4
8 Comments
 
LVL 16

Accepted Solution

by:
Mike T earned 500 total points
ID: 41732920
Hi,

SQL Express 2008R2? Why?? I know it's free but that's a bad reason for CM.

Firstly, that version (SQL Express) is *not* supported unless you are installing a Secondary site.
Secondly, SQL 2014 is out and fully supported (with a little caveat you can fix).
Third: You get a SQL Standard license *at no extra cost* when you buy ConfigMgr.

Please uninstall SQL and download/obtain either SQL Server 2012 Standard  or SQL 2014 + SP2.

http://blog-en.netvnext.com/2012/05/supported-sql-versions-in-sccm-2012.html

Mike
0
 

Author Comment

by:ejefferson213
ID: 41733102
Thank you for your assistance!  I failed to mention that this was for the CAS site so it looks like I'm screwed and I'll need to purchase a standard version (my network is far less than 50,000 nodes). What's weird is that this is what is downloaded with the product when the install takes place....
0
 

Author Closing Comment

by:ejefferson213
ID: 41738902
Thank you for your assistance.  I unloaded 2008 express and reloaded 2012 express with same results.  I'm hoping that the express version is acceptable to  SCCM because as a non-profit, we can't afford to pay for the licensed copy.  I'll keep trying....
0
 
LVL 16

Expert Comment

by:Mike T
ID: 41738917
Hi,

Thanks for the points but I'm confused now. Express (any version) won't work as you've no doubt found. Regardless you get SQL with the System Center license. You don't need to buy any SQL licenses.

Also, don't install a CAS. It sounds like you need a Standalone Primary Site.

Are you actually OK now or do you still need help? You've awarded points but say you're still trying.

Mike
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

Author Comment

by:ejefferson213
ID: 41738934
Thank you!! It's been awhile since I attempted the initial install and my (poor) memory tells me that I installed the SQL that was downloaded with the product which was 2008 R2 express.  Having read your post, I figured I must have done it wrong so I downloaded 2012 R2 express (can't afford the non-express version) and installed that with the same results.  When I go and look at the directory that has the downloaded products, downloaded during the install, I see SQL 2008 R2 Express and SQL 2012 R2 Express.  Now I'm fairly certain that I put 2012 R2 Express in this folder but even if I didn't, it got there from the automatic download done when I started the SCCM install.  So I'm confused why the product would download a SQL version that doesn't work with it?.......

And you're right that I don't NEED to use a CAS but since the documentation I've read said that it's impossible to add it later should you want, I thought I'd go through the effort of installing it.

So, you're correct, I still need help .......
0
 
LVL 16

Expert Comment

by:Mike T
ID: 41738988
OK, let's get the CAS out of the way: the document is out of date and you can (with CM R2) add a CAS later at any time you like.

However, there's only a very, very small chance you would need one anyway, so I would forget about it.
It just adds extra cost (you need 2 servers minimum) and complication. You don't want either I would guess!


As for  SQL, I tend to install with no Internet for a start so I can't remember what it tries to download. The method to use is:

1) Install SQL Standard 2012 or 214 (SP2)
2) Create the database files
3) Install CM

As I said, if you have already bought and paid for "Microsoft System Center 2012" it includes a full license for SQL standard. You need SQL for *ALL* 8 products, but you're only using one of them. To sell it without SQL would be like selling a car with an engine.

So, download the FULL SQL ISO and go from there.
https://www.microsoft.com/en-gb/download/details.aspx?id=29066

(The license will change from Eval to Full once you enter the key). You have 6 months to enter the key.

Mike
PS: Invest in a book (the book by Kent Agerlund is best for beginners) as you will need lots of help and there's only so much Googling that will help.
0
 

Author Comment

by:ejefferson213
ID: 41739030
Thank you very, very much for your time and effort!!!!  I'll do as you suggest; as you said, the document I was reading must be old.....   God bless you!!!
0
 
LVL 16

Expert Comment

by:Mike T
ID: 41739244
You're very welcome. Good luck.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A short film showing how OnPage and Connectwise integration works.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

914 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

14 Experts available now in Live!

Get 1:1 Help Now