Solved

SCCM Install Cannot Connect to SQL Database

Posted on 2016-07-27
8
52 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:ejefferson213
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
You're very welcome. Good luck.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Sql Query Lookup based on range 2 28
Help with SQL Query 23 39
SQL Transaction logs 8 6
BULK INSERT most recent CSV 19 17
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

743 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

13 Experts available now in Live!

Get 1:1 Help Now