Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SCCM Install Cannot Connect to SQL Database

Posted on 2016-07-27
8
Medium Priority
?
440 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 2000 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

In this article I will describe the Backup & Restore 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.
The following article discusses and demonstrates the advantages of using Pull Distribution Points in SCCM 2012 SP1 or higher as opposed to traditional push based architecture
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

722 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