Microsoft SQL Server 2000 Virtual Server Setup Dave Whitney SQL Cluster Support Specialist DSDB Developer Support Micros

1. Microsoft SQL Server 2000 Virtual Server SetupDave WhitneySQL Cluster Support SpecialistDSDB Developer SupportMicrosoft Corporation

2. Pre-setup Checklist • Understand basic server cluster concepts • Install on an HCL certified solution • Microsoft® Windows NT® event logs are free of warnings and errors • Server cluster is fully operational and correctly configured • Service account for Microsoft SQL Server™ has been created and has correct permissions • Static unique IP address for SQL Server

3. Overview • Microsoft Distributed Transaction Coordinator (MS DTC) installation on a server cluster • Base SQL Server 2000 virtual server installation • SQL Server 2000 service pack installation • SQL Server 2000 maintenance mode walkthrough • SQL Server uninstallation • SQL Server security recommendation • Reference links

4. MS DTC • MS DTC may be configured as a clustered resource either before or after the SQL Server installation • MS DTC cluster setup is performed from a cmd window using the command “comclust” as shown below

5. SQL Server Setup • Insert the SQL Server CD-ROM • Select “SQL Server 2000 Components” • Select “Install Database Server”

6. SQL Server Setup (2) • The setup process initializes the InstallShield Wizard

7. SQL Server Setup (3) • SQL Server detects the server cluster is present and prompts you to provide a virtual server name

8. SQL Server Setup (4) • In this case, the name chosen is “VSS1”

9. SQL Server Setup (5) • Setup prompts you for the name and company you want to register SQL Server with (the default entries will be provided for the node originating the installation, but they are editable)

10. Software License Agreement • This is the End User License Agreement (EULA) that must be accepted to continue

11. CD Key • Enter the 25-digit CD Key from the back of your CD case

12. SQL Server IP Address • Before entering an IP address, verify that the “Network to Use” field displays the correct network

13. SQL Server IP Address (2) • Provide at least one unique static IP address for this instance of SQL Server to use

14. SQL Server IP Address (3) • Click Add to add additional IP addresses or Next to continue

15. SQL Server Cluster Disk Selection • The SQL Server virtual server will require a server cluster disk for data file use

16. SQL Server Cluster Disk Selection (2) • If you try to use the Quorum drive, you will be warned not to do so • For additional information, seeQ280345, "Quorum Drive Configuration Information"

17. SQL Server Cluster Disk Selection (3) • Select a cluster disk that is not a Quorum disk and continue

18. SQL Server Cluster Definition • By default, all nodes are selected to participate in the SQL Server cluster definition

19. SQL Server Remote Information • Enter the domain account information of a domain user account that belongs to the Local Administrators Group • Use of SQL Server or the Cluster Services service account is recommended

20. Default Instance of SQL Server • SQL Server permits one default instance per cluster • This is the default setting

21. Named Instance of SQL Server • This installation will be of a named instance

22. Named Instance of SQL Server (2) • This installation will use the name “INST1”

23. Virtual Server and Instance Names • Naming virtual servers can be confusing, so here are some examples of valid and invalid names for multiple virtual servers in the same domain • VSS – Valid (default instance) • VSS\INST1 – Not valid • VSS1\INST1 – Valid • VSS1\VSS1 – Valid (not recommended) • VSS1\INST2 – Not valid • VSS2\INST1 – Not valid • VSS2\INST2 – Valid

24. SQL Server Setup Type • Select the type of installation you want • Typical • Minimum • Custom

25. SQL Server Service Account • Enter the SQL Server service account information

26. Authentication Method • Select whether your instance of SQL Server will use the default and preferred Windows Authentication, or both Windows Authentication and SQL Server Authentication

27. Start of File Copy • This is only an informational screen

28. Licensing Model Selection • Select the licensing model based on your product purchase

29. Additional Licensing Information • Additional information can be found at: • Q175276, "Licensing Policy Implementation with MSCS" • Microsoft Licensing • http://www.microsoft.com/licensing/

30. Progress Indicators • As the installation continues, you will see informational pop-up windows informing you of the installation progress; sometimes the screen will appear blank as shown

31. Completed • At this point your SQL Server failover instance has successfully completed installation

32. Cluster Administrator View • This is how the installation will appear in the Cluster Administrator

33. SQL Server 2000 Setup Service Pack Installation

34. SQL Server Service Packs • After you have completed your installation of the SQL Server failover clustering instance, Microsoft recommends that you apply the current SQL Server Service Pack • The following will demonstrate a typical SQL Server Service Pack installation WARNING: • If you remove or add servers to the SQL Server virtual server definition the way you did with SQL Server setup after installing a SQL Server Service Pack, the latest service pack must be reapplied (see Q295589 for details)

35. Obtaining SQL Server Service Packs • To obtain a SQL Server Service Pack, visit http://www.microsoft.com/sql/ to download the latest version

36. Obtaining a SQL Server Service Packs (2) • When downloading, you will be prompted to save the service pack to a local location for extraction

37. Obtaining a SQL Server Service Packs (3) • After the download is complete, the service pack will be extracted and applied

38. Service Pack Preparation • Locate and run the downloaded SQL Server Service Pack executable file • In this example, the file is located at: C:\temp\SQL2KSP2.EXE

39. Extracting the Service Pack • Microsoft recommends you accept the default location for the expanded files as shown

40. Starting Service Pack Setup • Locate the Setup.bat in the folder that the SQL2KSP2.EXE contents were extracted to, and run it

41. Starting Service Pack Setup (2) • Setup will then prepare the InstallSheild Wizard as noted in the screen pop-up window

42. Setup Warning • You will receive a warning about restarting • If you already restarted, click Next

43. Setup Warning (2) • A pop-up window will appear that indicates it is searching for installed components for the instance that had the service pack applied to it

44. Service Pack Welcome • The informational welcome message will appear

45. Computer Name • An dialog box will request the computer name of the virtual server that the SQL Server Service Pack will be applied to

46. Computer Name (2) • Enter the name of the virtual server that the service pack will be installed on

47. Computer Name Verifications • After the computer name is known, setup will search for additional information about the installed components • During this process, there will be times when the screen will not display any progress dialog boxes

48. Authentication Method • Select the authentication method to use when you connect to the SQL Server

49. Connectivity Verification • Connectivity is verified and the SQL Server state is verified as able to support an upgrade

50. Remote Information • Verify your Administrator account