1 / 53

Chapter Two

Chapter Two. Installing and Upgrading SQL Server 2000. Objectives. Understand hardware and software requirements before installing or upgrading SQL Server 2000 Install SQL Server 2000 Upgrade an existing installation of SQL Server 2000 Troubleshoot installations and upgrades.

mae
Download Presentation

Chapter Two

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. Chapter Two Installing and Upgrading SQL Server 2000

  2. Objectives • Understand hardware and software requirements before installing or upgrading SQL Server 2000 • Install SQL Server 2000 • Upgrade an existing installation of SQL Server 2000 • Troubleshoot installations and upgrades

  3. SQL Server 2000 Hardware/Software Requirements Table 2-1: Minimum hardware requirements

  4. SQL Server 2000 Hardware/Software Requirements Table 2-2: Operating system requirements

  5. Additional Software Requirements • Some additional software requirements for SQL Server 2000 installations include: • Internet Explorer 5 • If SQL Server 2000 is being installed on Windows NT Server, Service Pack 5 or higher must be installed prior to installation of SQL Server 2000 • If the XML features are going to be used, Internet Information Services must be installed prior to a SQL Server 2000 installation

  6. Installing SQL Server 2000 • For the sample installation, the following assumptions are made: • SQL Server will be used by a large-scale Web site for storing catalog information and processing transactions • The target computer will be running Windows 2000 Advanced Server and has two processors • The target computer has a single hard drive

  7. Installing SQL Server 2000 • Before inserting the SQL Server 2000 CD-ROM: • Be sure computer on which SQL Server 2000 will be installed meets hardware and software requirements • If installing on a machine with a version of SQL Server already installed, back up current installation • Understand the availability requirements for the installation and plan accordingly • Choose appropriate collation during installation process • Collation specifies the binary patterns representing each character available and rules by which characters are sorted and compared

  8. Installing SQL Server 2000 • Additional requirements to be met prior to beginning setup process: • Log on to operating system with an account that has local administrator rights on the computer • Shut down any instances of operating system Event Viewer and Registry Editors that are open • Shut down any services on the computer that are dependent on SQL Server • Create valid domain user account(s) that will enable SQL Server 2000 components to log on and provide network access to the SQL server 2000 installation

  9. Running the Setup Program Figure 2-1: SQL Server 2000 Enterprise Edition installation screen

  10. Running the Setup Program Figure 2-2: SQL Server Components installation options

  11. Running the Setup Program • SQL Server Components screen is starting point for installing: • Install Database Server • Begins installations of database engine and administrative tools installation • Install Analysis Services • Begins the installation of data warehousing components • Install English Query • Installs special set of facilities that allows users of SQL Server 2000 to query the database using logical English language statements

  12. Running the Setup Program Figure 2-3: Computer Name screen

  13. Installing SQL Server on a Local Computer Figure 2-4: Installation Selection screen

  14. Installing SQL Server on a Local Computer • Options regarding type of installation to run: • Create a new instance of SQL Server or install Client Tools • Upgrade, remove or add components to an existing instance • Advanced options

  15. Installing SQL Server on a Local Computer Figure 2-5: User Information screen

  16. Installing SQL Server on a Local Computer Figure 2-6: Installation Definition screen

  17. Options Provided by Installation Definition Screen • Client Tools Only • Installs only the client management tools like Enterprise Manager and query analyzer, as well as client connectivity components • Server and Client Tools • Installs database components and client tools • Connectivity Only • Installs the Microsoft Data Access Components (MDAC 2.6) and network libraries

  18. Multiple Instances in SQL Server 2000 • When multiple instances of SQL Server 2000 are installed on a single computer, a unique set of the following resources are created for each instance: • System and user databases • SQL Server and SQL Server Agent services • Registry keys associated with the MSSQL and SQL Server Agent services • Network connection addresses used by applications to connect specific instances of SQL Server 2000

  19. Multiple Instances in SQL Server 2000 • Components shared by multiple instances: • Only one instance of the Administrative Tools is installed on any single computer • Only one copy of the MS Search Service is installed on any single computer • Only a single copy of English Query and Analysis Services is installed on any single computer

  20. Multiple Instances in SQL Server 2000 Figure 2-7: Instance Name screen

  21. Multiple Instances in SQL Server 2000 Figure 2-8: Setup Type screen

  22. Setup Type Screen Options • Typical • Installs all of the components and assumes the default installation options • Minimum • Installs only the minimum components required • Custom • Allows administrator to explicitly select components and subcomponents as well as customize the collation settings for an installation

  23. Components of SQL Server 2000 Figure 2-9: Select Components screen

  24. Components of SQL Server 2000 • The following Server components are included when the option for Server and Client Tools is selected as an installation definition: • SQL Server • Upgrade Tools • Replication Support • Full-Text Search • Debug Symbols • Performance Counters

  25. Components of SQL Server 2000 • The following Management tools are included when the Client Tools option is selected as an installation definition: • Enterprise Manager • Profiler • Query Analyzer • DTC Client Support • Conflict Viewer

  26. Components of SQL Server 2000 • Client Connectivity component • Books Online component • Development Tools component • Code Samples component

  27. Components of SQL Server 2000 Figure 2-10: Service Accounts screen

  28. Creating Windows Users Accounts for Use by SQL Server 2000 • The following features can only be implemented if the services are configured to use a domain user account: • Replication • Remote procedure calls • Backups to network hard drives • Heterogeneous joins across servers

  29. Creating Windows Users Accounts for Use by SQL Server 2000 • Using user management facilities of the Computer Management program in Windows 2000, SQLServer and SQLAgent are created • Both users must have the following rights on the computer on which the installation is occurring • “Log on as a service” permission • Permission to modify the registry keys associated with SQL Server 2000 • “Access and Change “permissions on the SQL Server installation folder and the drives and folders on which the database and log files reside

  30. Creating Windows Users Accounts for Use by SQL Server 2000 Figure 2-11: Creating domain user accounts in Windows 2000

  31. Associating Windows Logons with SQL Server 2000 Services Figure 2-12: Authentication Mode screen

  32. SQL Server 2000 Authentication Modes • SQL Server 2000 authenticates user logons in one of two ways: • Windows Authentication Mode • User logs on to server using a Windows NT or Windows 2000 user account • Mixed Authentication Mode • Both Windows and SQL Server-based authentication are implemented

  33. SQL Server 2000 Authentication Modes • Windows Authentication Mode is strongly recommended with SQL Server 2000 • Provides the following benefits over SQL Server authentication: • Secure validation and encryption of passwords • Auditing • Password expiration and minimum password lengths • Account lockout after multiple invalid logon requests

  34. Collation Considerations • In most all cases, the default collation chosen by the SQL Server Setup application is acceptable • The default collation is based on the Windows locale of the computers on which SQL Server 2000 is being installed • Locale refers to the Windows operating system attribute that defines certain behaviors related to language

  35. Collation Considerations Figure 2-13: Collation Settings screen

  36. Collation Components • Code page • Defines the bit patterns that represent specific letters, numbers and symbols • Unicode • Defines a set of letters, numbers and symbols by using two bytes per character • Sort orders • Define the sequence in which characters are sorted and how characters are evaluated in comparison operations

  37. Collation Components • Collations specify three things: • Sort order for Unicode data • Sort order for non-Unicode data • Code page used for non-Unicode data

  38. Selecting an Appropriate Collation • When determining the appropriate collation to choose when installing SQL Server 2000, look at the people who will use the system • An important improvement of SQL Server 2000 over earlier versions is that collations can be selected for instances, databases and individual columns

  39. Networking Libraries Figure 2-14: Network Libraries screen

  40. Networking Libraries • Network libraries available through SQL Server 2000 Setup program: • Named Pipes • Required when installing SQL Server 2000 in Windows 2000 or Windows NT • TCP/IP Sockets • Allows communication through standard Windows sockets • Multi-Protocol • Single library offering support for TCP/IP, Named Pipes and NWLink IPX/SPX

  41. Networking Libraries • Network libraries available through SQL Server 2000 Setup program (cont.): • NWLink IPX/SPX • Provides support for Novell NetWare clients connecting to SQL Server 2000 • AppleTalk ADSP • Allows client on an AppleTalk network to communicate with SQL Server 2000 • Banyan VINES • Supports Banyan Vines clients

  42. SQL Server 2000 Licensing Options Figure 2-15: Licensing Mode screen • SQL Server 2000 has two licensing schemes: • Per Seat Licensing • Processor Licensing

  43. Failover Clustering Considerations • Failover clustering is implemented with SQL Server 2000 when there is high availability requirement for deployment • Node • Each SQL Server computer in a cluster • Cluster groups • Shared resources of the cluster • Heartbeats • Network messages passed between nodes on failover clusters that are used to determine which nodes are operational

  44. Advanced Installation Options • The Advanced options selection on the Installation Selection screen offers three choices: • Recorded Unattended .ISS file • Registry Rebuild • Maintain a virtual server for failover clustering

  45. Unattended Installation Table 2-3: Sample unattended installation batch files on the SQL Server 2000 CD

  46. Registry Rebuild • Registry Rebuild option will rebuild the registry entries for a corrupted SQL Server 2000 installation • Will prompt the user for all typical installation options and then repair the registry accordingly • Will not repair any data errors or the master database

  47. Upgrading from SQL Server 7.0 • There are two ways to upgrade databases to SQL Server 2000 from version 7.0: • SQL Server 2000 setup program • Updates all of the underlying components as well as existing databases • Copy Database Wizard • Used to copy or move databases between multiple instances of SQL Server 2000 • Used to upgrade databases from SQL Server version 7.0 to SQL Server 2000

  48. Upgrading from SQL Server 6.5 • Much different than updating from version 7.0 • Straight upgrade cannot be performed from version 6.5 to SQL Server 2000 • In this type of upgrade, SQL Server 2000 components are installed without affecting the existing version 6.5 installation

  49. Upgrading Editions ofSQL Server 200 Table 2-4: Edition upgrade chart

  50. Troubleshooting Installations and Upgrades • Most problems are caused by: • Too little disk space • Conflicts with other running applications • Shared files that are locked • Problems like these can usually be avoided if all pre-installation requirements are met

More Related