Jump to content


anyweb

How can I install System Center Configuration Manager version 1702 (Current Branch) on Windows Server 2016 with SQL 2016

Recommended Posts

Great article so far. I'm just going through the steps to become familiar with the process and to build a lab environment once I have the process down.

I'm using the script to install SQL Server 2016 and it seemed to ignore my desired location that I configured in your script. It installed to C:\Program Files instead of D:\Program Files. Once the SQL installation was executed in the PowerShell ISE, the install time using the script was about 15 minutes.

This is the configurationfile.ini that was created/updated in the c:\scripts folder.

[OPTIONS]
Action="Install"
ErrorReporting="False"
Quiet="True"
Features="SQLENGINE,RS,CONN,IS,BC,SDK,BOL"
InstanceName="MSSQLSERVER"
InstanceDir="D:\Program Files\Microsoft SQL Server"
SQLSVCAccount="NT AUTHORITY\System"
SQLSysAdminAccounts="windowsnoob\buildtest"
SQLSVCStartupType="Automatic"
AGTSVCACCOUNT="NT AUTHORITY\SYSTEM"
AGTSVCSTARTUPTYPE="Automatic"
RSSVCACCOUNT="NT AUTHORITY\System"
RSSVCSTARTUPTYPE="Automatic"
ISSVCACCOUNT="NT AUTHORITY\System" 
ISSVCSTARTUPTYPE="Disabled"
ASCOLLATION="Latin1_General_CI_AS"
SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
TCPENABLED="1"
NPENABLED="1"
IAcceptSQLServerLicenseTerms="True"

This is from the install sql server 2016.ps1 script:

# below variables are customizable
$folderpath="c:\Scripts"
$inifile="$folderpath\ConfigurationFile.ini"
# next line sets user as a SQL sysadmin
$yourusername="windowsnoob\buildtest"
# path to the SQL media
$SQLsource="J:\"
# configurationfile.ini settings https://msdn.microsoft.com/en-us/library/ms144259.aspx
$ACTION="Install"
$ASCOLLATION="Latin1_General_CI_AS"
$ErrorReporting="False"
$SUPPRESSPRIVACYSTATEMENTNOTICE="False"
$IACCEPTROPENLICENSETERMS="False"
$ENU="True"
$QUIET="True"
$QUIETSIMPLE="False"
$UpdateEnabled="True"
$USEMICROSOFTUPDATE="False"
$FEATURES="SQLENGINE,RS,CONN,IS,BC,SDK,BOL"
$UpdateSource="MU"
$HELP="False"
$INDICATEPROGRESS="False"
$X86="False"
$INSTANCENAME="MSSQLSERVER"
$INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server"
$INSTALLSHAREDWOWDIR="D:\Program Files (x86)\Microsoft SQL Server"
$INSTANCEID="MSSQLSERVER"
$RSINSTALLMODE="DefaultNativeMode"
$SQLTELSVCACCT="NT Service\SQLTELEMETRY"
$SQLTELSVCSTARTUPTYPE="Automatic"
$ISTELSVCSTARTUPTYPE="Automatic"
$ISTELSVCACCT="NT Service\SSISTELEMETRY130"
$INSTANCEDIR="D:\Program Files\Microsoft SQL Server"
$AGTSVCACCOUNT="NT AUTHORITY\SYSTEM"
$AGTSVCSTARTUPTYPE="Automatic"
$ISSVCSTARTUPTYPE="Disabled"
$ISSVCACCOUNT="NT AUTHORITY\System"
$COMMFABRICPORT="0"
$COMMFABRICNETWORKLEVEL="0"
$COMMFABRICENCRYPTION="0"
$MATRIXCMBRICKCOMMPORT="0"
$SQLSVCSTARTUPTYPE="Automatic"
$FILESTREAMLEVEL="0"
$ENABLERANU="False"
$SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
$SQLSVCACCOUNT="NT AUTHORITY\System"
$SQLSVCINSTANTFILEINIT="False"
$SQLSYSADMINACCOUNTS="$yourusername"
$SQLTEMPDBFILECOUNT="1"
$SQLTEMPDBFILESIZE="8"
$SQLTEMPDBFILEGROWTH="64"
$SQLTEMPDBLOGFILESIZE="8"
$SQLTEMPDBLOGFILEGROWTH="64"
$ADDCURRENTUSERASSQLADMIN="True"
$TCPENABLED="1"
$NPENABLED="1"
$BROWSERSVCSTARTUPTYPE="Disabled"
$RSSVCACCOUNT="NT AUTHORITY\System"
$RSSVCSTARTUPTYPE="Automatic"
$IAcceptSQLServerLicenseTerms="True"

 

Have a great day!

Edited by SCCM N00B

Share this post


Link to post
Share on other sites

I am running into a problem when I am installing SCCM from the script. It is telling me the product code is incorrect

7/24/2017 12:30:49 PM: ConfigMgrSetupWizard Verbose: 1 : Received error [The product key is not correct.  You must enter the entire 25 digit product key.] from native code.
 

I know I can install it without the script as it takes the license key just fine manually but I would like to see what I am doing wrong with the script.

Share this post


Link to post
Share on other sites

look at step 15 again, I updated it, see this part:

 

Note: If you are NOT using an evaluation version of SCCM then you need to add the section below in blue to the configuration.ini file which is contained within the PowerShell script, and you need to change  the ProductId open the script in Windows ISE, locate the line that reads $ProductID= and enter your ConfigMgr Product Key.

[SABranchOptions]
SAActive=1
CurrentBranch=1

 

 

did you do that ? and did you enter the product key ?

Share this post


Link to post
Share on other sites

can you email me the log and powershell script so i can take a look niall@windows-noob.com, you can remove the key

Share this post


Link to post
Share on other sites

so we had a chat offline and it seems there were some problems when running the script, paste errors perhaps, anyway, it's now working fine and installing :)

Share this post


Link to post
Share on other sites

hi Jeff, it seemed to be a combination of product key issue (maybe it was pasted incorrectly, try pasting stuff into notepad first, then into the script), and your FQDN's

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.