cpjitservices Posted June 2, 2016 Posted June 2, 2016 Hi all, This is the first time installing SCCm and what a nightmare. Ive gotten to the bit before Begin Install.. So I am at Pre-Requisite check. Its failing on the following: SQL Server Edition Configuration for SQL Server Memory Usage SQL Server process memory allocation. I have been into SQL studio and configured the memory allocation as 8192 and still SCCM setup moans. Any ideas ? Thanks
Norphy Posted June 2, 2016 Posted June 2, 2016 Memory usage and allocations are warnings. As long as you have an appropriate version of SQL installed, it will install. Which version of SQL do you have on your box? Standard? Enterprise? Express? 2012/14/16? Which service pack?
Steve21 Posted June 2, 2016 Posted June 2, 2016 Main site has to be a proper SQL edition unless they changed it. Express is only valid for secondary sites. SCCM includes SQL standard rights for free as part of it's license (Only for use with SCCM on the same server) Steve 1
maddocks1993 Posted June 2, 2016 Posted June 2, 2016 (edited) Helloo, As Norphy said the SQL Memory allocation is just a warning and you can change that in the SQL Management Studio once SQL Server has been installed. I would recommend SQL Server 2012 with SP2 and get the latest Cumulative Updates for SQL or use SQL Server 2014. A basic Standard SQL Edition will be fine for the job. Have you also configured the SQL Server Configuration Manager Ports and added them to the Firewall? Please provide the error code. Chris. Edited June 2, 2016 by maddocks1993 1
sparkeh Posted June 2, 2016 Posted June 2, 2016 Side note to this but if you are installing sccm you should be installing the Current Business Branch versions now not 2012. Current base version is v1511 which updates to v1602. Latest version has added goodies for managing Windows 10. 2
cpjitservices Posted June 2, 2016 Author Posted June 2, 2016 I tired to install SCCM 1511 but it wouldnt install uneless I had server 2016. ?? Right I think ive got licensing for SQL Standard anyway so Ill try that
Steve21 Posted June 2, 2016 Posted June 2, 2016 I tired to install SCCM 1511 but it wouldnt install uneless I had server 2016. ?? Right I think ive got licensing for SQL Standard anyway so Ill try that You get a free one as part of SCCM install as above. SQL Server 2014 SP1 – Standard, Enterprise You can use this version of SQL Server with no minimum cumulative update version for the following: Central administration site Primary site Secondary site SQL Server 2014 Express SP1 You can use this version of SQL Server with no minimum cumulative update version for the following: Secondary site When you do install the standard one remember to leave a nice chunk of ram (from the machine) free from the SQL reservation, else it struggles. So like say 8GB to SQL and 8GB to server etc (random figures) Steve 1
cpjitservices Posted June 2, 2016 Author Posted June 2, 2016 You get a free one as part of SCCM install as above. When you do install the standard one remember to leave a nice chunk of ram (from the machine) free from the SQL reservation, else it struggles. So like say 8GB to SQL and 8GB to server etc (random figures) Steve Cheers... Ill do that I have 32GB Ram in this server anyway. So how does the SQL work then do I just download latest standard version ? and then install SCCM ?
sparkeh Posted June 2, 2016 Posted June 2, 2016 I tired to install SCCM 1511 but it wouldnt install uneless I had server 2016. ?? ?? I have it installed on Server 2008r2 and 2012r2 Pre-reqs here confirm this: https://technet.microsoft.com/en-us/library/mt589738.aspx 1
Steve21 Posted June 2, 2016 Posted June 2, 2016 Cheers... Ill do that I have 32GB Ram in this server anyway. So how does the SQL work then do I just download latest standard version ? and then install SCCM ? When you download SCCM off VLK there's a SQL installer within the same part that comes with a presinstalled key. System Center 2012 with SP1 - Virtual Machine Manager Server Multilanguage 32/64 bit 1320 MB ISO SQL Server 2014 Standard 64 Bit English 64 bit 2486 MB ISO System Center 2012 Configuration Manager and Endpoint Protection With Service Pack 2 Multilanguage 32/64 bit 1158 MB ISO Again last time I did it, but seeing it's still there looks like nothing changed Steve 1
cpjitservices Posted June 2, 2016 Author Posted June 2, 2016 ok, just downloading SQL 2012 standard right now will install that and see how it goes.... i Presume it will update my current install of express edition ? Thanks all much appreciated!
maddocks1993 Posted June 2, 2016 Posted June 2, 2016 I have SCCM in a virtual Machine running on 4GB Max with SQL installed tis perfectly fine! SCCM Current Branch should work completely fine on Server 2012 R2. It is down to the SQL Server. Member to change SQL Server Collation as well before installing the actual database, you don't need the entire SQL Features for the installation, you only need Database and Reporting Features plus the Management Studio. Chris. 1
maddocks1993 Posted June 2, 2016 Posted June 2, 2016 Not certain if the Standard Edition will update SQL Express, I would be inclined to actually get rid of the SQL Express and let SCCM carry out the SQL Express as part of the SCCM installation. Chris. 1
cpjitservices Posted June 2, 2016 Author Posted June 2, 2016 Not certain if the Standard Edition will update SQL Express, I would be inclined to actually get rid of the SQL Express and let SCCM carry out the SQL Express as part of the SCCM installation. Chris. All right Ill try that.
maddocks1993 Posted June 2, 2016 Posted June 2, 2016 Hi, I would follow this guide for a starting point about SCCM, mainly to do with the SQL Process but it is very simple when you have installed it once - https://www.windows-noob.com/forums/topic/13368-how-can-i-install-system-center-configuration-manager-current-branch/ You don't have to create that amount of users nor install WSUS as a pre-Req, SCCM won't show as Failed it will show as a Warning but again Windows Deployment Services and Windows Server Updates Service integrates with SCCM. Chris. 1
Norphy Posted June 2, 2016 Posted June 2, 2016 When installing SQL for ConfigMgr, it's very important that you choose the correct collation type. You need to use SQL_Latin1_general_CP1_CI_AS otherwise it will still refuse to install. 1
cpjitservices Posted June 2, 2016 Author Posted June 2, 2016 When installing SQL for ConfigMgr, it's very important that you choose the correct collation type. You need to use SQL_Latin1_general_CP1_CI_AS otherwise it will still refuse to install. Yep. Got that. Selected. Install SQL Now. Cheers
Norphy Posted June 2, 2016 Posted June 2, 2016 At the risk of sounding like a broken record, SCCM is a big and complex product. You're not likely to get the best out of it unless either you get some training or get some help from someone who is experienced with it. Sites like this and Windows Noob help but I would still suggest going on a course if you can.
maddocks1993 Posted June 2, 2016 Posted June 2, 2016 Or just keep trying and re-installing the product numerous times as you aren't actually harming anything via imaging etc. Keep looking around for guides , videos on youtube (they have a lot) or do a course on MVA (Microsoft Virtual Academy) if they still have SCCM on there.
Norphy Posted June 2, 2016 Posted June 2, 2016 (edited) Or just keep trying and re-installing the product numerous times as you aren't actually harming anything via imaging etc. Keep looking around for guides , videos on youtube (they have a lot) or do a course on MVA (Microsoft Virtual Academy) if they still have SCCM on there. There's no harm, no but it isn't necessarily the most efficient way of learning the product either. Going on a course gets you takes you through all aspects of the product and gets you a useful background into why things are the way they are. I have been on three SCCM courses (One for 2007 R3 and both the installation and management courses for 2012) and they were absolutely invaluable. Edited June 2, 2016 by Norphy 1
cpjitservices Posted June 9, 2016 Author Posted June 9, 2016 Thanks all have been looking at CBT Nuggets etc and have got SCCM working... next question is where do I get SCVMM from ? All I can find online is a VHD ? Will it be part or our Technet Subscription ? I presume SCVMM integrates with SCCM. Thanks for all the help folks!! Wonderful as always!
Norphy Posted June 9, 2016 Posted June 9, 2016 Thanks all have been looking at CBT Nuggets etc and have got SCCM working... next question is where do I get SCVMM from ? All I can find online is a VHD ? Will it be part or our Technet Subscription ? I presume SCVMM integrates with SCCM. Thanks for all the help folks!! Wonderful as always! 1) Try here: https://www.microsoft.com/en-gb/evalcenter/evaluate-system-center-2012-r2 2) Maybe. Depends on your subscription. Bear in mind that all stuff you download from Technet or MSDN can't be used in production, it's purely for evaluation purposes. If you want to use them in anger, you'll have to buy a full license. 3) Depends what you mean by integrates. They are two separate programs which can talk to each other to an extent but you can't drive both from a single interface if that's what you're asking 1
cpjitservices Posted June 9, 2016 Author Posted June 9, 2016 1) Try here: https://www.microsoft.com/en-gb/evalcenter/evaluate-system-center-2012-r2 2) Maybe. Depends on your subscription. Bear in mind that all stuff you download from Technet or MSDN can't be used in production, it's purely for evaluation purposes. If you want to use them in anger, you'll have to buy a full license. 3) Depends what you mean by integrates. They are two separate programs which can talk to each other to an extent but you can't drive both from a single interface if that's what you're asking Thats fine, we have licenses and Technet, but I'm wanting to try it first before we go fully fledged. Its System Center 2012 Ive got install... I have just downloaded R2 from that same page So Ill use that as I think that is what I need. Thanks.
cpjitservices Posted June 9, 2016 Author Posted June 9, 2016 Thanks everyone, everything installed and working now. Correct licenses in place etc. Ready for testing.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now