SQL Server 2008 R2 SP1 CU3 Slipstreamed

Hi Everyone,


Today, I am going to show you how to create new source media that will slipstream the original source media, SQL Server 2008 R2 to SQl Server 2008 R2 SP1 then to SQL Server 2008 R2 SP1 CU3. Once you have created this drop, you can install SQL Server 2008 R2 SP1 CU3 in a single step.
These instructions are for English SQL Server but will work with any language of SQL Server if you obtain the correct language.
Each time a new Service pack or CU is released, you can repeat these steps.


Download the PDF guide on SQL SERVER 2008 R2 Slipstream + SP1 + CU3

Adding a group policy rule to allow remote management of machines

Purpose

This procedure allows you to create a group policy object (domain GPO) to allow remote management service on joined domain machines.

Procedure

Action	Screen Shot
Go to Start, Administrative Tools and click Group Policy Management
Enroll Forest:Forest-Name, Domains, Domain-Name, Group Policy Objects
Right-click on Group Policy Objects and select New
Type a name for your new GPO in the Name field (Enable Remote Management Service)
A new GPO should appear in the Group Policy Objects field
Right-click Name-of-new-GPO and select Edit
Go to Inbound rules under Computer Configuration, Policies, Windows Settings, Windows Firewall With Advanced Security, Windows Firewall With Advanced Security –LDAP...
Right-click Inbound Rules and select New Rule
In Predifined choose Remote Administration and click Next
Click Next
Choose Allow the connection and click Finish
Under Domains, right-click Domain-Name and select Link an Exisiting GPO...
Choose the Created GPO and click OK
The GPO must appear under Domain-Name
To apply the GPO in the desired machine, you can either: -Go to a command prompt (in the desired machine), tape gpupdate /force and press Enter OR -Reboot the desired machine