Go Premium for a chance to win a PS4. Enter to Win

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

SCCM Install Cannot Connect to SQL Database

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
ejefferson213
Asked:
ejefferson213
  • 4
  • 4
1 Solution
 
Mike TLeading EngineerCommented:
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
 
ejefferson213Author Commented:
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
 
ejefferson213Author Commented:
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
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
Mike TLeading EngineerCommented:
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
 
ejefferson213Author Commented:
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
 
Mike TLeading EngineerCommented:
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
 
ejefferson213Author Commented:
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
 
Mike TLeading EngineerCommented:
You're very welcome. Good luck.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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