1 / 24

Module 3 Installing and Configuring SQL Server 2008 R2

Module 3 Installing and Configuring SQL Server 2008 R2. Module Overview. Preparing to Install SQL Server Installing SQL Server Upgrading and Automating Installation. Lesson 1: Preparing to Install SQL Server. Hardware Requirements – General Hardware Requirements - Memory

anne-hays
Download Presentation

Module 3 Installing and Configuring SQL Server 2008 R2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Module 3 Installing and Configuring SQL Server 2008 R2

  2. Module Overview • Preparing to Install SQL Server • Installing SQL Server • Upgrading and Automating Installation

  3. Lesson 1: Preparing to Install SQL Server • Hardware Requirements – General • Hardware Requirements - Memory • Software Requirements – Operating Systems • Software Requirements - General • Determining File Placement • Service Account Requirements • Working with Collations • Demonstration 1A: Collations

  4. Hardware Requirements - General • Processors • Almost any processor is now fast enough • Number of processors needs to be considered • Disk • Disk space requirements for SQL Server are trivial compared to current drive sizes • User database size is a determining factor • Disk I/O performance is critical to SQL Server performance • Virtualization • SQL Server virtualization is now very common

  5. Hardware Requirements - Memory • 32 bit servers have limited "visible" address space • AWE memory can only be used for data page caching

  6. Software Requirements – Operating Systems • Operating system (General Summary) • Windows Server 2008 R2 • Windows Server 2008 SP2 • Windows Server 2003 R2 • Windows Server 2003 SP2 • Windows 7 • Windows Vista SP2 • Windows XP SP3 • Avoid installation on domain controllers • Prefer 64 bit SQL on 64 bit OS but WOW is supported

  7. Software Requirements – General • .NET Framework • .NET Framework 2.0 SP2 for SQL Server 2008 R2 on Windows Server 2003 R2 64bit Itanium and SQL Server Express • .NET Framework 3.5 SP1 for all other editions • SQL Server Native Client • SQL Server Setup support files • Windows Installer 4.5 or later • Internet Explorer 6 SP1 or later • Network software • Shared memory • Named pipes • TCP/IP • VIA (deprecated)

  8. Determining File Placement Disk Planning and File Placement The most important considerations are the number of disks or spindles available to a particular drive and the speed of the drives involved

  9. Service Account Requirements • Carefully consider service account requirements • Create service accounts that have least privileges • Generally choose domain accounts • Local Service account might be appropriate in some environments • If accounts are set using SQL Server setup, minimal permissions will be configured automatically • Each service account has different permission requirements • Consult BOL for details of specific permissions for each account • Use a different account for each service

  10. Working with Collations A collation encodes the rules governing the proper use of characters for a language such as Greek, or an alphabet, such as Latin1_General. • Windows Collations • Based on the rules for the associated Windows locale • SQL Server Collations • Matches the code page number and sort order that may have been specified in earlier versions of SQL Server • Default Collation and Sort Rules • Default collation applies if you do not designate collation and sort rules

  11. Demonstration 1A: Collations • In this demonstration, you will see how collations affect T-SQL queries.

  12. Lesson 2: Installing SQL Server • Overview of the Installation Process • System Configuration Checker • Post-installation Checks • Demonstration 2A: System Configuration Checker

  13. Overview of the Installation Process Component Update SQL Setup MSI System Configuration Checker Feature Selection Server Configuration Install

  14. System Configuration Checker Checks Installation Requirements: Software Requirements ü Hardware Requirements ü Security Requirements ü System State Requirements ü

  15. Post-installation Checks • Verify that installed SQL Server services are running • SQL Server Configuration Manager is a good place to do this • If errors occur during setup, log files are helpful • Every setup creates a new timestamped log folder • Location is: %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log • Detail, summary, and additional logs created as needed at each phase: • Global rules text • Component update • User-requested action

  16. Demonstration 2A: System Configuration Checker • In this demonstration you will see how to run the first phase of SQL Server installation, the System Configuration Checker. You will see the rules that the SCC implements.

  17. Lesson 3: Upgrading and Automating Installation • Upgrading SQL Server • Unattended Installation • Demonstration 3A: Unattended Installation File

  18. Upgrading SQL Server • Side-by-side installs of SQL Server 2008 R2 and SQL Server 2008 have additional considerations: • Same major version number • Shared components are upgraded to the latest version (they do not co-exist) • Setup support files can work with either version. (You can later change installed SQL Server 2008 components).

  19. Unattended Installation • Can install SQL Server from the command line • Can also upgrade SQL Server from the command line Setup.exe /q /ACTION=CompleteImage /INSTANCENAME=MYNEWINST /INSTANCEID=<MYINST> /SQLSVCACCOUNT="<DomainName\UserName>" /SQLSVCPASSWORD="<StrongPassword>" /SQLSYSADMINACCOUNTS="<DomainName\UserName>" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS Setup.exe /q /ACTION=upgrade /INSTANCENAME=MSSQLSERVER /RSUPGRADEDATABASEACCOUNT="<Provide a SQL Server logon account that can connect to the report server during upgrade>" /RSUPGRADEPASSWORD="<Provide a password for the report server upgrade account>" /ISSVCAccount="NT Authority\Network Service" /IACCEPTSQLSERVERLICENSETERMS

  20. Demonstration 3A: Unattended Installation File • In this demonstration, you will see an unattended installation file that could be used to configure SQL Server

  21. Lab 3: Installing and Configuring SQL Server • Exercise 1: Review installation requirements • Exercise 2: Install the SQL Server instance • Exercise 3: Perform Post-installation Setup and Checks • Challenge Exercise 4: Configure Server Memory (Only if time permits) Logon information Estimated time: 45minutes

  22. Lab Scenario The development group within the company has ordered a new server for the work they need to do on the Proseware system. Unfortunately, the new server will not arrive for a few weeks and the development group cannot wait that long to start work. The new server that was provisioned by the IT Support department already has two instances of SQL Server installed. The support team have determined that the new server will be able to support an additional instance of SQL Server on a temporary basis, until the server for the development group arrives. You need to install the new instance of SQL Server and if you have time, you should configure the memory of all three instances to balance their memory demands, and you should create a new alias for the instance that you install.

  23. Lab Review • When the DEV instance is no longer required, what actions would be needed when removing it from the server? • What does CI indicate as part of the name of a collation?

  24. Module Review and Takeaways • Review Questions • Best Practices

More Related