Microsoft SQL Server 2000 Virtual Server Setup Dave Whitney SQL Cluster Support Specialist DSDB Developer Support Microsoft Corporation - PowerPoint PPT Presentation

Slide1 l.jpg
Download
1 / 88

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

Related searches for Microsoft SQL Server 2000 Virtual Server Setup Dave Whitney SQL Cluster Support Specialist DSDB Developer Support Microsoft Corporation

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

Download Presentation

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

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 l.jpg

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


Pre setup checklist l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

SQL Server Setup

  • Insert the SQL Server CD-ROM

  • Select “SQL Server 2000 Components”

  • Select “Install Database Server”


Sql server setup 2 l.jpg

SQL Server Setup (2)

  • The setup process initializes the InstallShield Wizard


Sql server setup 3 l.jpg

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 l.jpg

SQL Server Setup (4)

  • In this case, the name chosen is “VSS1”


Sql server setup 5 l.jpg

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 l.jpg

Software License Agreement

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


Cd key l.jpg

CD Key

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


Sql server ip address l.jpg

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 l.jpg

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 l.jpg

SQL Server IP Address (3)

  • Click Add to add additional IP addresses or Next to continue


Sql server cluster disk selection l.jpg

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 l.jpg

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 l.jpg

SQL Server Cluster Disk Selection (3)

  • Select a cluster disk that is not a Quorum disk and continue


Sql server cluster definition l.jpg

SQL Server Cluster Definition

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


Sql server remote information l.jpg

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 l.jpg

Default Instance of SQL Server

  • SQL Server permits one default instance per cluster

  • This is the default setting


Named instance of sql server l.jpg

Named Instance of SQL Server

  • This installation will be of a named instance


Named instance of sql server 2 l.jpg

Named Instance of SQL Server (2)

  • This installation will use the name “INST1”


Virtual server and instance names l.jpg

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 l.jpg

SQL Server Setup Type

  • Select the type of installation you want

    • Typical

    • Minimum

    • Custom


Sql server service account l.jpg

SQL Server Service Account

  • Enter the SQL Server service account information


Authentication method l.jpg

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 l.jpg

Start of File Copy

  • This is only an informational screen


Licensing model selection l.jpg

Licensing Model Selection

  • Select the licensing model based on your product purchase


Additional licensing information l.jpg

Additional Licensing Information

  • Additional information can be found at:

    • Q175276, "Licensing Policy Implementation with MSCS"

  • Microsoft Licensing

    • http://www.microsoft.com/licensing/


Progress indicators l.jpg

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 l.jpg

Completed

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


Cluster administrator view l.jpg

Cluster Administrator View

  • This is how the installation will appear in the Cluster Administrator


Sql server 2000 setup l.jpg

SQL Server 2000 Setup

Service Pack Installation


Sql server service packs l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

Obtaining a SQL Server Service Packs (3)

  • After the download is complete, the service pack will be extracted and applied


Service pack preparation l.jpg

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 l.jpg

Extracting the Service Pack

  • Microsoft recommends you accept the default location for the expanded files as shown


Starting service pack setup l.jpg

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 l.jpg

Starting Service Pack Setup (2)

  • Setup will then prepare the InstallSheild Wizard as noted in the screen pop-up window


Setup warning l.jpg

Setup Warning

  • You will receive a warning about restarting

  • If you already restarted, click Next


Setup warning 2 l.jpg

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 l.jpg

Service Pack Welcome

  • The informational welcome message will appear


Computer name l.jpg

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 l.jpg

Computer Name (2)

  • Enter the name of the virtual server that the service pack will be installed on


Computer name verifications l.jpg

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 l.jpg

Authentication Method

  • Select the authentication method to use when you connect to the SQL Server


Connectivity verification l.jpg

Connectivity Verification

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


Remote information l.jpg

Remote Information

  • Verify your Administrator account


Remote information 2 l.jpg

Remote Information (2)

  • Enter a domain account that is a valid local administrator on all nodes in the cluster


Progress dialog boxes l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

SQL Server 2000 Setup

Maintenance/Advanced Mode Setup


Sql server 2000 maintenance advanced mode setup l.jpg

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 l.jpg

Getting Started

  • Insert the SQL Server 2000 CD

  • Starting setup in maintenance mode is like starting a new installation


Computer name58 l.jpg

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 l.jpg

Installation Selection

  • Select "Advanced options," not the default selection which is to “Upgrade, remove…”


Advanced options l.jpg

Advanced Options

  • "Maintain a Virtual Server for Failover Clustering" is the only enabled advanced option for virtual servers


Sql virtual server ip address l.jpg

SQL Virtual Server IP Address

  • IP address additions or modifications will be made here


Cluster definition l.jpg

Cluster Definition

  • Specify a virtual server definition of participating nodes


Remote installation l.jpg

Remote Installation

  • Verify or change the account of the valid administrator on all nodes in the cluster definition


Maintenance completed l.jpg

Maintenance Completed

  • Click Finish to complete virtual server maintenance


Sql server 2000 setup65 l.jpg

SQL Server 2000 Setup

Uninstalling a Virtual Server


Installation selection66 l.jpg

Installation Selection

  • Upgrade, remove, or add components to an existing instance of SQL Server


Progress indicators67 l.jpg

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 l.jpg

Successful Uninstallation

  • Setup notifies you that you have successfully uninstalled the instance


Setup completed l.jpg

Setup Completed

  • Setup has completed, but node restarts may be required


Sql server 2000 setup70 l.jpg

SQL Server 2000 Setup

Securing Your Installation


Sql server security recommendations l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

Setup Type – Custom

  • Custom setup selected


Service accounts l.jpg

Service Accounts

  • Service accounts


Select components l.jpg

Select Components

  • Select the components your custom installation will use


Authentication mode l.jpg

Authentication Mode

  • Select authentication

  • For security purposes, Microsoft recommends that Windows Authentication be used


Collation settings l.jpg

Collation Settings

  • Collation settings


Network libraries l.jpg

Network Libraries

  • Network library selections


Start copying files l.jpg

Start Copying Files

  • Start copying files


Setup type l.jpg

Setup Type

  • Minimum installation


Server cluster mscs basics l.jpg

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 l.jpg

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


  • Login