SCCM-SQL Server via PowerShell

SCCM-SQL Server via PowerShell
5 (100%) 1 vote

Hi All,

the 3rdpost of this series of SCCM via PowerShell, we’ll be looking at the SQL Server Installation & Configuration for SCCM…

1st, we need to create the firewall rules for SQL. I’m assuming the installation will be done using default instance, so the default port will be TCP 1433 and assuming the SSB Port (for SCCM Data replication if you have a hierarchy) will be 4022 (default).
 

 

2nd- Install the SQL Server. For this, you’ll need to have access to the SQL Server 2016 RTM source files. Copy the content of the DVD to c:\SQLSource. I’m also assuming the installation will happen on the C:\SQLServer and C:\SQLServer (x86) for the shared x86 files. I’m using the SYSTEM account for the services and will add the CLASSROOM\SCCM Admins as sysadmin (change as required)
 

 

3rd- Install SQL Management Studio. I’ve downloaded the file to c:\SQLMgmt. Note that the SQL Server 2016 does not have the management studio files built-in, so this is an extra download that you can get from http://go.microsoft.com/fwlink/?linkid=832812.
 

 

4th- Validate the installation. You need to be sure you can connect to the database as well as reporting services. To connect to the reporting services, i’m assuming you’ll be using the user sccmadmin, password Pa$$word and domain classroom (change as required). Also, i’m using the password as plaintext as this is a lab. not a best practices to do. you could use the get-credential to as the username/password instead.
 

 

5th-SQL Max memory. Microsoft recommends it to be at least 8GB.
 

 

6th-SQL Server Reporting Services Recovery Mode. By default, the recovery model for the SSRS database is set to full, for SCCM, we can use Simple without any problem. I my opinion, it is recommended to change it to simple
 

 

7th-finally, confirm that you’re using SQL Static Port
 

 

that’s it for today.

%d bloggers like this: