Installing SQL Server 2. Configuration Manager 2. Download Microsoft. Download Ozzy Garmin Voice Free Software. NET Framework 4. 5. Offline Installer for Windows Vista SP2, Windows 7 SP1, Windows 8, Windows 8. Windows Server 2008 SP2, Windows. Complete installation guide about how to install SCCM 2012 Application Catalog. Pre. Microsoft. NET Framework 4. Web Installer for Windows Vista SP2, Windows 7 SP1, Windows 8, Windows 8. Windows Server 2008 SP2 Windows Server 2008 R2. Install .Net 3.5 Sp1 Server 2012 R2' title='Install .Net 3.5 Sp1 Server 2012 R2' />R2. In this post we will be looking at the steps for Installing SQL Server 2. Configuration Manager 2. R2. In this deployment series of Configuration Manager 2. R2 we started with system center 2. R2 Configuration Manager system requirements which tells more about the new features of SCCM 2. R2 and system requirements for Configuration Manager 2. R2, in the next post we saw the steps for installing prerequisites for SCCM 2. R2. After installing prerequisites the next step is to install SQL server. Most of the users have a question on where should the SQL server be installed, should it be installed locally on the server where SCCM is installed or on a remote server The answer is you can install it on local server or host the database on remote server. I would prefer to install SQL locally because this it requires less administrative overhead, the license for SQL is included with System Center so no additional license needs to be purchased and with local SQL you can achieve better performance than remote. In this post we will be installing SQL server 2. SP1 on windows server 2. R2, if you have only SQL server 2. SQL server 2. 01. For System Center 2. R2 Configuration Manager you can install the SQL server with combinations 1 Install SQL Server 2. Min Cumulative Update 2. Install SQL Server 2. Service Pack 1 no cumulative update required3 Install SQL Server 2. Service Pack 1 no cumulative update requiredIf you are planning to use SQL server other than 2. SQL Server Requirements for Configuration Manager 2. R2. Here is a video tutorial that shows the steps to install SQL server for SCCM. So lets look at the steps to install SQL Server 2. SP1 x. 64 Bit. I have mounted the DVD on to the Windows Server 2. R2, open the SQL server folder, run the setup as administrator. Click on Installation and click on New SQL server standalone installation. Click OK once the Setup support rules are run and verified. Check the box for I accept the license terms and click on Next. After the Setup Support Rules are completed click on Next. Select the Setup Role as SQL Server Feature Installation and click Next. On the Feature Selection window, select Database Engine Services, Reporting Services Native and Management Tools Complete. Note The features that we have selected are the ones which are required for deploying Configuration Manager 2. R2. However you can select all features and install them if you want to. For Instance Configuration click on Default Instance, the instance ID MSSQLSERVER would be created. Note If you are creating a Named Instance, then during the SCCM 2. R2 setup you might come across this error The specified SQL Server instance is not configured to use dynamic ports unless you have not configured dynamic ports for SQL server instance. To fix this error launch the SQL Server Configuration Manager, expand SQL Server Network Configuration. Click on Protocols for Instance Instance is your Named Instance. On the right side pane, right click on the TCPIP and click on Properties. Click on IP Addresses tab and scroll down to the bottom and under the IPALL, set TCP Port value to 1. Click on Apply and after this change you must restart SQL Server Service. For Service Accounts, Microsoft recommends you to use domain service accounts and not the local system accounts. We will be using the account named sccmadmin which is a member of domain admins group. This account will be also used for installing and managing Configuration Manager 2. R2. You can also create a separate user accounts for each of the SQL server services. Specify the account name and password and click on Next. Important During the SQL install, the collation should be SQLLatin. GeneralCP1CIAS. Click Add Current User, this will add the current user to SQL server administrators. Choose the Authentication Mode as Windows authentication mode. Click Next. Choose Reporting Services Native Mode and click on Install and Configure. Click on Next. Click on Install to start the installation. We have installed SQL server 2. SP1 on Windows Server 2. R2 Datacenter Edition. Click on Close. During the installation of Configuration Manager 2. R2, the configuration manager checks if the SQL server memory limit is limited. If the memory is not limited, then a warning is displayed. To avoid that lets limit our server with a memory limit. Launch the SQL Server Management Studio. Login to the server and right click the Server and click on Properties. Click on Memory, set Minimum server memory value to 8. MB The minimum value can be less that 8. MB and set Maximum server memory as 8. MB. Click on OK and close the SQL management studio. Cisco Virtualization Solution for EMC VSPEX with Microsoft Hyper V 2. R2 for up to 1. 00. Virtual Machines. Table Of Contents. About the Authors. Acknowledgments. About Cisco Validated Design CVD Program. Cisco Virtualization Solution for EMC VSPEX with Microsoft Hyper V 2. R2 for up to 3. 00 Virtual Machines. Executive Summary. Introduction. Target Audience. Purpose of This Guide. Business Needs. Solution Overview. Technology Overview. Cisco Unified Computing System. Microsoft Hyper V 2. R2. EMC Storage Technology and Benefits. Architectural Overview. Memory Configuration Guidelines. Hyper V Memory Management Concepts. Storage Guidelines. Virtual Server Configuration. Storage Protocol Capabilities. Storage Layout. Storage Building Blocks. Networking Guidelines. Recommended NICs. Optional NICs. Quality of Service. Solution for up to 3. Hyper V Virtual Machines. Stateless Computing. Sizing Guidelines. Configuration Guidelines. Pre deployment Tasks. Configuration Workstation. Physical Setup. Cisco UCS Components. Preparing Cisco Nexus Switches. Preparing EMC VNX5. Cable Connectivity. Configure Cisco Nexus Switches. Set Up Initial Cisco Nexus 5. Switch. Enable Appropriate Cisco Nexus Features. Configure Fibre Channel Ports. Create Necessary VLANs. Add Individual Port Descriptions for Troubleshooting. Create Necessary Port Channels. Add Port Channel Configurations. Configure Virtual Port Channels. Configure Fibre Channel Ports. Link Into Existing Network Infrastructure. Initial Configuration of Cisco Unified Computing System. Logging Into Cisco UCS Manager. Create the VSPEX Environment with Cisco UCS Power. Tool. Create the VSPEX Environment with Cisco UCS Manager. Synchronize Cisco UCS to NTPAdd a Block of IP Addresses for KVM Access. Edit the Chassis Discovery Policy. Create an Organization. Enable Quality of Service in Cisco UCS Fabric. Create a Power Control Policy. Create a Scrub Policy. Create Maintenance Policy. Create a Local Disk Configuration Policy. Create a Server BIOS Policy Enable Fabric Interconnect Port Definitions. Create Uplink Port Channels to the Cisco Nexus 5. Switches. Create v. NIC Templates. Create v. HBA Templates. Create Boot Policies. Create Service Profile Templates and Service Profiles. Create EMC VNX5. 40. LUNs for VSPEXConfigure Zoning on Cisco Nexus 5. Switches. Gather Necessary Information. Create Device Aliases and Create Zone for First Server. Install Initial Microsoft Windows Server 2. R2. Sysprep the Initial Image. Cloning the Sysprepped Image. Boot from Sysprepped LUNs. Zone the Network. Mask Boot LUNs to Service Profiles. Complete Image Builds from Sysprepped Images. Configure Networks. Install EMC Power. Path. Install EMC Unisphere Host Agent. Create Hyper V Failover Cluster. Create Shared Storage. Run Cluster Validation Wizard. Create Cluster. Sample Power. Shell Scripts. Cisco Scripts. Ucs. Config. ps. 1Ucs. Config. xml. Add Ucs. Hyper. VFeatures. Set Ucs. Hyper. VAdapters. Set Ucs. Hyper. VRemote. Mgmt. ps. 1EMC Sample Scripts. MasterBootLun. xml. StorageLuns. xml. Prep. Master. Boot Add. Via. WWPN. ps. 1Process. Storage. Requests. Process. Clones. ps. Process. Clones. xml. Post. CloneAdd. Via. WWPN. ps. 1Cisco Nexus 1. V Installation. Create Two Virtual Supervisor Module Virtual Machines. Configure the VSMConfigure Virtual Switch Extension Manager in VMMCopy Virtual Ethernet Module Installation Packager to the VMM Virtual Machines. Configure a Logical Switch in VMMCreate the Logical Switch on the Hyper V Hosts. Create a Virtual Machine Network. Configure the Virtual Machine Manager Virtual Machine Properties. Customer Configuration Worksheets. Common Server. Hyper V Servers WWNNWWPNEMC VNX5. Array. WWNNWWPNCisco UCS Network Infrastructure. VLAN Information. Service Information. Cabling. Cisco Nexus 5. ACisco Nexus 5. 54. BCisco 6. 24. 8 Fabric Interconnect ACisco 6. Fabric Interconnect BAppendix. FCo. E Configuration. VLANs. Cabling. Nexus Configuration. Cisco Unified Computing System Configuration. Create FCo. E Uplink Ports. Create VSANs. Create a Fibre Channel Policy. Create VHBA Templates. Determine VNX FCo. E Ports and WWNs. Cisco Virtualization Solution for EMC VSPEX with Microsoft Hyper V 2. R2 for up to 3. 00 Virtual Machines. Last Updated January 8, 2. Building Architectures to Solve Business Problems About the Authors Tim Cerling, Technical Marketing Engineer, Cisco Tim Cerling is a Technical Marketing Engineer with Ciscos Datacenter Group, focusing on delivering customer driven solutions on Microsoft Hyper V and System Center products. Tim has been in the IT business since 1. He started working with Windows NT 3. DEC Alpha product line during his 1. DEC, and he has continued working with Windows Server technologies since then with Compaq, Microsoft, and now Cisco. During his twelve years as a Windows Server specialist at Microsoft, he co authored a book on Microsoft virtualization technologies Mastering Microsoft Virtualization. Tim holds a BA in Computer Science from the University of Iowa. Prashanto Kochavara, Solutions Engineer, EMC Prashanto has been working for the EMC solutions group for over 3 years. Prashanto is a SME on EMC Storage and Virtualization technologies including VMware and Hyper V. He has vast amount of experience in end to end solution planning and deployments of VSPEX architectures. Prior to joining the solutions group at EMC, Prashanto has interned as a Systems Engineer EMC and Software Developer MBMS Inc. Prashanto holds a Bachelors degree in Computer Engineering from SUNY Buffalo and will be graduating with a Masters Degree in Computer Science from North Carolina State University in December 2. Acknowledgments For their support and contribution to the design, validation, and creation of this Cisco Validated Design, we would like to thank Mike MankovskyTechnical Lead, Cisco Mehul BhattTechnical Lead, Cisco About Cisco Validated Design CVD Program The CVD program consists of systems and solutions designed, tested, and documented to facilitate faster, more reliable, and more predictable customer deployments. For more information visit www. ALL DESIGNS, SPECIFICATIONS, STATEMENTS, INFORMATION, AND RECOMMENDATIONS COLLECTIVELY, DESIGNS IN THIS MANUAL ARE PRESENTED AS IS, WITH ALL FAULTS. CISCO AND ITS SUPPLIERS DISCLAIM ALL WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT OR ARISING FROM A COURSE OF DEALING, USAGE, OR TRADE PRACTICE. IN NO EVENT SHALL CISCO OR ITS SUPPLIERS BE LIABLE FOR ANY INDIRECT, SPECIAL, CONSEQUENTIAL, OR INCIDENTAL DAMAGES, INCLUDING, WITHOUT LIMITATION, LOST PROFITS OR LOSS OR DAMAGE TO DATA ARISING OUT OF THE USE OR INABILITY TO USE THE DESIGNS, EVEN IF CISCO OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. THE DESIGNS ARE SUBJECT TO CHANGE WITHOUT NOTICE. USERS ARE SOLELY RESPONSIBLE FOR THEIR APPLICATION OF THE DESIGNS. THE DESIGNS DO NOT CONSTITUTE THE TECHNICAL OR OTHER PROFESSIONAL ADVICE OF CISCO, ITS SUPPLIERS OR PARTNERS. USERS SHOULD CONSULT THEIR OWN TECHNICAL ADVISORS BEFORE IMPLEMENTING THE DESIGNS. RESULTS MAY VARY DEPENDING ON FACTORS NOT TESTED BY CISCO. CCDE, CCENT, Cisco Eos, Cisco Lumin, Cisco Nexus, Cisco Stadium. Vision, Cisco Tele. Presence, Cisco Web. Ex, the Cisco logo, DCE, and Welcome to the Human Network are trademarks Changing the Way We Work, Live, Play, and Learn and Cisco Store are service marks and Access Registrar, Aironet, Async.