{"id":22,"date":"2009-04-16T23:26:14","date_gmt":"2009-04-16T22:26:14","guid":{"rendered":"https:\/\/harun.se\/blog\/?p=22"},"modified":"2009-04-16T23:27:02","modified_gmt":"2009-04-16T22:27:02","slug":"sql-2008-for-sccm-r2-step-by-step-guide","status":"publish","type":"post","link":"https:\/\/harun.se\/blog\/?p=22","title":{"rendered":"SQL 2008 for SCCM R2 – STEP by STEP GUIDE"},"content":{"rendered":"

\u00a0<\/p>\n

1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Server 2008\u00a0 Installation & Provisioning<\/p>\n

\u00a01.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Server 2008 Installation
\n\u00a01.1.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pre-Installation tasks
\nReboot your machine prior to starting the SQL Server installation process to make sure that you do not have any pending reboot requests which will block the SQL Server installation process.<\/p>\n

Create following Service Accounts in the Domain: SQLAgent, SQLReporting, SQLService<\/p>\n

1.1.2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Installation Step by Step
\nInstall Dotnet 3.5 SP1 and Windows Installer 4.5. These are the prerequisities for SQL 2008.<\/p>\n

\u00a0<\/p>\n

Start the setup from the media by running “setup.exe”.<\/p>\n

\"\"
\n\u00a0<\/p>\n

\u00a0Once prerequisites have been installed, you will see the main installation screen, as shown below.
\nClick the New SQL Server stand-alone installation link to launch the SQL Server installation.\u00a0\u00a0\u00a0
\n\u00a0
\n\"\"
\n\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0
\n\u00a0
\n\u00a0Installation will execute a system configuration check. Once the check completes successfully, your screen should look similar to the following: Click “OK”<\/p>\n

\"\"
\n\u00a0\u00a0 Accept the default product key Click NEXT.<\/p>\n

\"\"
\n\u00a0\u00a0
\n\u00a0\u00a0 Select “I accept the license terms” as show below and then click Next.<\/p>\n

\"\"
\n\u00a0\u00a0
\n\u00a0\u00a0 Click “Install” to “Setup Support Files”.<\/p>\n

\"\"
\n\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\nVerify that all the rules has status = Passed\u00a0 and click Next.<\/p>\n

\"\"
\nSelect the SQL Server features and Change the Feature directories to the Disk path as shown below then click Next.<\/p>\n

\"\"
\nSelect Default Instance as shown below then click Next.<\/p>\n

\"\"\u00a0<\/p>\n

Verify the disk space requirements and click Next.<\/p>\n

\"\"
\nEnter the Domain service accounts that you created earlier for the appropriate services. When complete, your screen should look similar to the following:\u00a0 Click NEXT<\/p>\n

\"\"<\/p>\n

Select “Windows authentication mode” as shown below, Click “Add” and Choose “SCCM Admins” Group from the Active Directory as SQL Server Administrators.<\/p>\n

\"\"
\nClick the Data Directories tab and Change the settings as shown Below, Click NEXT.<\/p>\n

\"\"<\/p>\n

Choose “Install but do not Configure the report server” as shown below, Click NEXT.<\/p>\n

\"\"
\nIn the “Error and Usage Reporting” section, Click NEXT.<\/p>\n

\"\"
\nVerify that all the rules has status = Passed or Not applicable and click Next.<\/p>\n

\"\"
\n\u00a0
\nClick “Install” on the “Ready to Install” section<\/p>\n

\"\"
\nVerify that the Installation Status\u00a0 is = “Success” and Click NEXT<\/p>\n

\"\"
\nVerify the final installation report and Click “Close” to Finish the installation<\/p>\n

\"\"
\n\u00a0\u00a0<\/p>\n

\u00a0
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0
\n\u00a0\u00a0\u00a0
\n1.2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Server 2008 Provisioning & Optimization
\nPOST SCCM Installation steps on the Sql server for optimization purposes.<\/p>\n

1.2.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SCCM Database Parameters
\nCalculate the initial database size based on 2 MB per client (Workstations and Servers), e.g. 50,000 client * 2MB per client = 100,000 MB or 100 GB.<\/p>\n

\u00a0<\/p>\n

\u00a0\u00a0 Central Site<\/p>\n\n\n\n\n\n\n\n\n
Setting <\/strong>\u00a0<\/td>\nValue <\/strong>\u00a0<\/td>\n<\/tr>\n
Name\u00a0<\/td>\nSMS_123\u00a0<\/td>\n<\/tr>\n
Data File:\u00a0<\/td>\n100 Gb\u00a0<\/td>\n<\/tr>\n
Log File:\u00a0<\/td>\n20 Gb\u00a0<\/td>\n<\/tr>\n
Autogrowth <\/strong>\u00a0<\/td>\nBy 10%, unrestricted growth\u00a0<\/td>\n<\/tr>\n
Users\u00a0<\/td>\n50\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/p>\n

Regional Primary Sites<\/p>\n\n\n\n\n\n\n\n\n
Setting <\/strong>\u00a0<\/td>\nValue <\/strong>\u00a0<\/td>\n<\/tr>\n
Name\u00a0<\/td>\nSMS_<<SiteCode>>\u00a0<\/td>\n<\/tr>\n
Data File:\u00a0<\/td>\n40 Gb\u00a0<\/td>\n<\/tr>\n
Log File:\u00a0<\/td>\n8 Gb\u00a0<\/td>\n<\/tr>\n
Autogrowth <\/strong>\u00a0<\/td>\nBy 10%, unrestricted growth\u00a0<\/td>\n<\/tr>\n
Users\u00a0<\/td>\n20\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/p>\n

\u00a0<\/p>\n

4.2.1.1\u00a0\u00a0 Follow the steps defined below to do the changes on the SCCM Databases<\/p>\n

Click Start -> Microsoft SQL Server 2008 -><\/p>\n

Right Click on the “SQL Server Management Studio” and choose to “Run as administrator”, as shown in the picture below;<\/p>\n

\"\"<\/p>\n

4.2.1.2\u00a0\u00a0 Click “Connect” to start managing the local SQL Server, as shown in the picture below<\/p>\n

\"\"
\n\u00a0<\/p>\n

4.2.1.3\u00a0\u00a0 Expand the “Databases” and Right Click\u00a0 “SMS_XYZ” and choose “Properties” as shown in the picture below;<\/p>\n

\"\"<\/p>\n

4.2.1.4\u00a0\u00a0 Click “Files” on the “Select page” to the left and change the “initial Size” of the “SMS_XYZ” file to\u00a0\u00a0 “40000 MB” and the “SMS_XYZ_log” file to “8000 MB” on the right pane and Click “OK”<\/p>\n

\"\"
\nDo Not Close the “Microsoft SQL Management Studio console”, it will be used to optimize the TempDB in the following steps.<\/p>\n

1.2.2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TempDB Optimization
\nFor best performance, increase or request the TempDB size as such:<\/p>\n

\u00a0<\/p>\n

\u00a0\u00a0 Central Site<\/p>\n

\u00a0<\/p>\n\n\n\n\n\n\n\n
Setting <\/strong>\u00a0<\/td>\nValue <\/strong>\u00a0<\/td>\n<\/tr>\n
Name\u00a0<\/td>\nTempDB\u00a0<\/td>\n<\/tr>\n
Data File:\u00a0<\/td>\n20Gb (= 20% of the SCCM DB)\u00a0<\/td>\n<\/tr>\n
Log File:\u00a0<\/td>\n10Gb (= 50% of the TempDB)\u00a0<\/td>\n<\/tr>\n
Autogrowth <\/strong>\u00a0<\/td>\nBy 10%, unrestricted growth\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Regional Primary Sites<\/p>\n

\u00a0<\/p>\n\n\n\n\n\n\n\n
Setting <\/strong>\u00a0<\/td>\nValue <\/strong>\u00a0<\/td>\n<\/tr>\n
Name\u00a0<\/td>\nTempDB\u00a0<\/td>\n<\/tr>\n
Data File:\u00a0<\/td>\n8 Gb (= 20% of the SCCM DB)\u00a0<\/td>\n<\/tr>\n
Log File:\u00a0<\/td>\n4 Gb (= 50% of the TempDB)\u00a0<\/td>\n<\/tr>\n
Autogrowth <\/strong>\u00a0<\/td>\nBy 10%, unrestricted growth\u00a0<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

4.2.2.1\u00a0\u00a0 Expand the “Databases” and “System Databases” tree to see the “TempDB” in the console,\u00a0 Right Click\u00a0 “TempDB” and choose “Properties” as shown in the picture below;<\/p>\n

\"\"
\n\u00a0<\/p>\n

4.2.2.2\u00a0\u00a0 Click “Files” on the “Select page” to the left and change the “initial Size” of the “tempdev” file to “8000 MB” and the “templog” file to “4000 MB” on the right pane and Click “OK”<\/p>\n

\"\"
\nClose the “Microsoft SQL Management Studio console”<\/p>\n

1.2.3\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Change the RAM settings for the SQL server
\nI choose to fix the RAM usage for the SCCM Sql server running on the same server as the SCCM Primary site servers,<\/p>\n

my servers had 8 GB Ram Memory and I have allocated 5 GB for the SQL server using the OSQL commands below:<\/p>\n

\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Server 2008\u00a0 Installation & Provisioning \u00a01.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQL Server 2008 Installation \u00a01.1.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pre-Installation tasks Reboot your machine prior to starting the SQL Server installation process to make sure that you do not have any pending reboot requests which will block the SQL Server installation process. Create following Service Accounts in the Domain: SQLAgent, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/harun.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/22"}],"collection":[{"href":"https:\/\/harun.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/harun.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/harun.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/harun.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=22"}],"version-history":[{"count":3,"href":"https:\/\/harun.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions"}],"predecessor-version":[{"id":24,"href":"https:\/\/harun.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions\/24"}],"wp:attachment":[{"href":"https:\/\/harun.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/harun.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/harun.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}