Microsoft SQL Server 2000 Virtual Server Setup
Download
1 / 88

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


  • 436 Views
  • Updated 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

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

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 Dave Whitney SQL Cluster Support Specialist DSDB Developer Support Micros' - 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 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