slide1
Download
Skip this Video
Download Presentation
Microsoft SQL Server 2000 Virtual Server Setup Dave Whitney SQL Cluster Support Specialist DSDB Developer Support Microsoft Corporation

Loading in 2 Seconds...

play fullscreen
1 / 88

Microsoft SQL Server 2000 Virtual Server Setup - PowerPoint PPT Presentation


  • 436 Views
  • Uploaded on

Microsoft SQL Server 2000 Virtual Server Setup Dave Whitney SQL Cluster Support Specialist DSDB Developer Support Microsoft Corporation. Pre-setup Checklist. Understand basic server cluster concepts Install on an HCL certified solution

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Microsoft SQL Server 2000 Virtual Server Setup' - Melvin


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

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

pre setup checklist
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
overview
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
ms dtc
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
sql server setup
SQL Server Setup
  • Insert the SQL Server CD-ROM
  • Select “SQL Server 2000 Components”
  • Select “Install Database Server”
sql server setup 2
SQL Server Setup (2)
  • The setup process initializes the InstallShield Wizard
sql server setup 3
SQL Server Setup (3)
  • SQL Server detects the server cluster is present and prompts you to provide a virtual server name
sql server setup 4
SQL Server Setup (4)
  • In this case, the name chosen is “VSS1”
sql server setup 5
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)
software license agreement
Software License Agreement
  • This is the End User License Agreement (EULA) that must be accepted to continue
cd key
CD Key
  • Enter the 25-digit CD Key from the back of your CD case
sql server ip address
SQL Server IP Address
  • Before entering an IP address, verify that the “Network to Use” field displays the correct network
sql server ip address 2
SQL Server IP Address (2)
  • Provide at least one unique static IP address for this instance of SQL Server to use
sql server ip address 3
SQL Server IP Address (3)
  • Click Add to add additional IP addresses or Next to continue
sql server cluster disk selection
SQL Server Cluster Disk Selection
  • The SQL Server virtual server will require a server cluster disk for data file use
sql server cluster disk selection 2
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"
sql server cluster disk selection 3
SQL Server Cluster Disk Selection (3)
  • Select a cluster disk that is not a Quorum disk and continue
sql server cluster definition
SQL Server Cluster Definition
  • By default, all nodes are selected to participate in the SQL Server cluster definition
sql server remote information
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
default instance of sql server
Default Instance of SQL Server
  • SQL Server permits one default instance per cluster
  • This is the default setting
named instance of sql server
Named Instance of SQL Server
  • This installation will be of a named instance
named instance of sql server 2
Named Instance of SQL Server (2)
  • This installation will use the name “INST1”
virtual server and instance names
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
sql server setup type
SQL Server Setup Type
  • Select the type of installation you want
    • Typical
    • Minimum
    • Custom
sql server service account
SQL Server Service Account
  • Enter the SQL Server service account information
authentication method
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
start of file copy
Start of File Copy
  • This is only an informational screen
licensing model selection
Licensing Model Selection
  • Select the licensing model based on your product purchase
additional licensing information
Additional Licensing Information
  • Additional information can be found at:
    • Q175276, "Licensing Policy Implementation with MSCS"
  • Microsoft Licensing
    • http://www.microsoft.com/licensing/
progress indicators
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
completed
Completed
  • At this point your SQL Server failover instance has successfully completed installation
cluster administrator view
Cluster Administrator View
  • This is how the installation will appear in the Cluster Administrator
sql server 2000 setup

SQL Server 2000 Setup

Service Pack Installation

sql server service packs
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)
obtaining sql server service packs
Obtaining SQL Server Service Packs
  • To obtain a SQL Server Service Pack, visit http://www.microsoft.com/sql/ to download the latest version
obtaining a sql server service packs 2
Obtaining a SQL Server Service Packs (2)
  • When downloading, you will be prompted to save the service pack to a local location for extraction
obtaining a sql server service packs 3
Obtaining a SQL Server Service Packs (3)
  • After the download is complete, the service pack will be extracted and applied
service pack preparation
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

extracting the service pack
Extracting the Service Pack
  • Microsoft recommends you accept the default location for the expanded files as shown
starting service pack setup
Starting Service Pack Setup
  • Locate the Setup.bat in the folder that the SQL2KSP2.EXE contents were extracted to, and run it
starting service pack setup 2
Starting Service Pack Setup (2)
  • Setup will then prepare the InstallSheild Wizard as noted in the screen pop-up window
setup warning
Setup Warning
  • You will receive a warning about restarting
  • If you already restarted, click Next
setup warning 2
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
service pack welcome
Service Pack Welcome
  • The informational welcome message will appear
computer name
Computer Name
  • An dialog box will request the computer name of the virtual server that the SQL Server Service Pack will be applied to
computer name 2
Computer Name (2)
  • Enter the name of the virtual server that the service pack will be installed on
computer name verifications
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
authentication method48
Authentication Method
  • Select the authentication method to use when you connect to the SQL Server
connectivity verification
Connectivity Verification
  • Connectivity is verified and the SQL Server state is verified as able to support an upgrade
remote information
Remote Information
  • Verify your Administrator account
remote information 2
Remote Information (2)
  • Enter a domain account that is a valid local administrator on all nodes in the cluster
progress dialog boxes
Progress Dialog Boxes
  • A series of progress dialog boxes will be presented over time
  • Some of these dialog boxes remain unchanged for several minutes
service pack is installed
Service Pack Is Installed
  • After the service pack is installed, you will be advised on whether a restart is required and on which nodes
service pack failures
Service Pack Failures
  • If the service pack could not perform the remote node installation, you would have seen this pop-up window
sql server 2000 setup55

SQL Server 2000 Setup

Maintenance/Advanced Mode Setup

sql server 2000 maintenance advanced mode setup
SQL Server 2000 Maintenance/Advanced Mode Setup
  • Used for:
    • Domain changes
    • Adding or removing nodes from the SQL virtual server definition
    • IP address changes
    • Service account changes
getting started
Getting Started
  • Insert the SQL Server 2000 CD
  • Starting setup in maintenance mode is like starting a new installation
computer name58
Computer Name
  • First, provide the computer name for instance of the virtual server you will be working with, the way you did when you started a typical installation
installation selection
Installation Selection
  • Select "Advanced options," not the default selection which is to “Upgrade, remove…”
advanced options
Advanced Options
  • "Maintain a Virtual Server for Failover Clustering" is the only enabled advanced option for virtual servers
sql virtual server ip address
SQL Virtual Server IP Address
  • IP address additions or modifications will be made here
cluster definition
Cluster Definition
  • Specify a virtual server definition of participating nodes
remote installation
Remote Installation
  • Verify or change the account of the valid administrator on all nodes in the cluster definition
maintenance completed
Maintenance Completed
  • Click Finish to complete virtual server maintenance
sql server 2000 setup65

SQL Server 2000 Setup

Uninstalling a Virtual Server

installation selection66
Installation Selection
  • Upgrade, remove, or add components to an existing instance of SQL Server
progress indicators67
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
successful uninstallation
Successful Uninstallation
  • Setup notifies you that you have successfully uninstalled the instance
setup completed
Setup Completed
  • Setup has completed, but node restarts may be required
sql server 2000 setup70

SQL Server 2000 Setup

Securing Your Installation

sql server security recommendations
SQL Server Security Recommendations
  • Aside from the recommendation to use Windows Authentication, there are several other considerations
    • SQL Server Books Online (BOL) covers this subject. See the BOL index entry:
      • Security, (see also security – SQL Server)
    • Microsoft Baseline Security Analyzer can help with verification
microsoft baseline security analyzer
Microsoft Baseline Security Analyzer
  • The tool can be downloaded from the Microsoft Baseline Security Analyzer Web site:

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/tools/Tools/MBSAhome.asp

microsoft baseline security analyzer 2
Microsoft Baseline Security Analyzer (2)
  • The Baseline Security Analyzer will check:
    • If Administrators group belongs to sysadmin role
    • If CmdExec role is restricted to sysadmin only
    • If SQL Server is running on a domain controller
    • If account password is exposed
    • SQL installation folders access permissions
    • If Guest account has database access
    • If Everyone group has access to SQL registry keys
    • If SQL service accounts are members of the local Administrators group
    • If SQL accounts have blank or simple passwords
    • For missing SQL hotfixes
    • The SQL Server Authentication mode type
    • The number of sysadmin role members
sql server 2000 cluster do s and don ts
SQL Server 2000 Cluster Do\'s and Don\'ts
  • Plan, plan, plan…
  • Use SQL Server Enterprise Manager to make all changes to SQL Server service accounts or passwords
  • Do not try to reuse SQL Server cluster resources for other additional resources
  • Monitor Q254321, "INF: Clustered SQL Server Do\'s, Don\'ts, and Basic Warnings," for the most up-to-date “do’s and don’ts” information related to SQL Server clustering
  • If a support call is made, return requested information or files as soon as possible
troubleshooting virtual sql server servers
Troubleshooting Virtual SQL Server Servers
  • When troubleshooting issues on virtual SQL Server servers, note that troubleshooting must be done in a certain order unless the problem is a known SQL issue
  • Problems or failures with the hardware, operating system, networking, security, or Microsoft Cluster Service can appear as SQL Server issues when in fact no SQL Server issues exist
troubleshooting virtual sql server servers 2
Troubleshooting Virtual SQL Server Servers (2)
  • Troubleshoot virtual SQL Server issues in the following order:
    • Hardware– Do the system event logs show any warnings or errors that cannot be explained? If look at the computer\'s system report, are any problem devices reported? If so, can they be explained?
    • Operating system– Do the event logs show any kind of operating system problems, service failures, or driver problems?
    • Networking– Do the event logs show loss of connectivity? NIC failures? DNS problems?
    • Security– Look for access denied errors and security log failures.
    • MSCS– Does the cluster report problems in any of the event logs?
    • SQL Server– Does SQL Server report any specific error messages in the error log or event logs?
reference links
Reference Links
  • SQL Server technical resources
    • http://www.microsoft.com/sql/techinfo/default.asp
  • SQL 2000 failover clustering
    • http://www.microsoft.com/sql/techinfo/administration/2000/failovercluster.asp
  • Q254321, "INF: Clustered SQL Server Do\'s, Don\'ts, and Basic Warnings"
    • http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q254321
setup type custom
Setup Type – Custom
  • Custom setup selected
service accounts
Service Accounts
  • Service accounts
select components
Select Components
  • Select the components your custom installation will use
authentication mode
Authentication Mode
  • Select authentication
  • For security purposes, Microsoft recommends that Windows Authentication be used
collation settings
Collation Settings
  • Collation settings
network libraries
Network Libraries
  • Network library selections
start copying files
Start Copying Files
  • Start copying files
setup type
Setup Type
  • Minimum installation
server cluster mscs basics
Server Cluster (MSCS) Basics
  • Support WebCast: Microsoft Windows 2000 Clustering BasicsTuesday, February 01, 2000

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/so_projects/socluster/soclusterblurb.asp

  • Support WebCast: Windows Clustering: An Overview of Microsoft Clustering Technologies

Friday, January 21, 2000

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/wc012100/wcblurb012100.asp

  • Step-by-Step Guide to Installing Cluster Service

http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp

server cluster mscs basics 2
Server Cluster (MSCS) Basics (2)
  • Clustering services technologies
    • http://www.microsoft.com/windows2000/technologies/clustering/default.asp
  • Q259267, "Microsoft Cluster Service Installation Resources"
  • MSPRESS MCSE Training Kit –Windows 2000 Advanced Server Clustering Services ISBN 0-7356-1293-5
ad