Solved

SCCM Install Cannot Connect to SQL Database

Posted on 2016-07-27
8
300 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 18

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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
LVL 18

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
 

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 18

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 18

Expert Comment

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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
Troubleshooting common task sequence error codes
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

631 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