MS SQL Installation Notes - MSSQL2000

Miscellaneous Notes

• Default Port: 1433
• Other install notes
  • SQL Server Key is stored in the registry at:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\registration\CD_KEY
• Unistall notes:
  • http://support.microsoft.com/kb/290991 - Manual uninstall if you have problems with the install dieing or the normal uninstall from Control Panel, Add/Remove Programs doesn't exist or work correctly.
  • My manual uninstall notes
    • Warning: Remember your DB data usually resides at: <installdrive>:\Program Files\Microsoft SQL Server\MSSQL\Data
    • Locate, and then delete the %drive%:\Program Files\Microsoft SQL Server\MSSQL\Binn folder.
      Make a backup of the Registry using regedit.exe
      Using regedit.exe delete the following keys:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
      For the Default SQL Server Instance delete the following keys:
      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT
      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServerADHelper
      For any additional instances delete the keys:
      HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT$InstanceName
      For any clusters, remove those keys.
      Reboot the server.
      I like to delete the following directory after moving the Data files:
      %drive%:\Program Files\Microsoft SQL Server
      The following services should no longer be installed: MSSQLSERVER, SQLSERVERAGENT
• MDAC Version
  • http://msdn.microsoft.com/downloads/ - search for "Component Checker".  Download, install and run the program.
    Install exe:  cc_pkg.exe
    Installs to: C:\CompChecker
    Run:  cc.exe
  • WARNING: Look for any warnings about MDAC versions and SQL Server at the top of the file.  At one time I saw:
    "Important note: Don't install MDAC 2.6 or later on SQL Server 7.0 or 6.5 clustered installations; doing so will break your cluster".

Installation Notes

• Windows Platform: SQL Server 2000 (Enterprise Edition)
  • Only installs on Win 2000 Server or Advanced Server.
• Windows Platform (Win XP & Win 2000): SQL Server 2000 (Developer Edition)
  • Click "SQL Server 2000 Components"
    • Click "Install Database Server"
    • Welcome to the Microsoft SQL Server Installation Wizard - Click "Next".
    • Select "Local Computer" - Click "Next"
    • Select "Create a new instance of SQL Server, or install Client Tools" - Click "Next"
    • Enter a User Name:
      Enter a Company Name:
      Click "Next"
    • End-User License Agreement - Click "Yes"
    • Select "Server and Client Tools" - Click "Next"
      Note: You have 3 Options
      Client Tools Only - use if only connecting to an existing server.
      Server and Client Tools - Install the server and client tools.
      Connectivity Only - only works with MS Data Access Components and network libraries
    • Check the box: Default
      If you uncheck the box then you can install another server instance with a unique instance name.
      (Note:  Instance Name - not sure what to do here.  If you have 2 installs then I think you need to choose a name.  In the system services, you will see the following if your instance is named "SQL2000INSTANCE" - SQLAgent$SQL2000INSTANCE)
      Example Instance Name:  SQL2000INSTANCE
    • Select "Typical". 
      Change the destination folder if desired.
          Default Program files:  C:\Program Files\Microsoft SQL Server
          Default Data Files: C:\Program Files\Microsoft SQL Server
      Then "Next"
      Note:  Takes about 250 Meg of disk space.
      • Custom Option - this will allow you to selection components that may not be installed with the "Typical" option.  I like to install all components.
    • Service Accounts
      Select "Use the same account for each service.  Auto start SQL Service Service"
      Service Settings:  Select "Use the Local System account"
      (Note" I'm not sure about the pros/cons for this selection.)
    • Authentication Mode
      Select "Mixed Mode (Windows Authentication and SQL Server Authentication Mode"
      • Mixed Mode - some applications need to authenticate to the SQL Server via the "sa" account using SQL Server authentication Mode.  (NOTE:  Some believe this is a security risk and you should only use Windows Authentication.)
      • SA Login Password.
        Enter Password for the "sa" account and click "Next"
        (Note: Write your password in a safe place.  Blank password is allowed (and the default) but not recommended.)
    • Optional - You may see this if you loaded additional components from Custom Options
      • Collation Settings
        • Use the defaults
          Not Checked - Collation designator:
          Checked - SQL Collations
          (Note: I don't check any of the items in the list.)
        • Click "Next"
      • Network Libraries
        • Use the defaults
          Named Pipes:\\.\pipe\sql\query
          TCP/IP Sockets: 1433
        • Start Copying Files - click "Next"
    • Click "Finish"
    • Reboot the Computer (to start the SQL services).
    • MS SQL Server Programs
      • Note:  Click "Start", "All Programs" and look for "Microsoft SQL Server"
      • Query Analyzer - Run SQL code via a GUI
      • Enterprise Manager - Manage the SQL server application.
  • Service Packs - Now apply any Service Packs that Microsoft may have out.
    • http://www.microsoft.com/downloads
      Search Help:
      Keywords: Microsoft SQL Server 2000 Service Pack
      Product Technology: SQL Server
      Database Components SP: Make sure you install the DB Component SP file.   Install the other files only if they apply to you.
      Notes:
      32bit vs 64bit - Database Components (32bit - laptop versions)
      desk - Desktop Engine
      MSDE - MS Desktop Engine Components
      AS - Analysis Services
    • SP4 Install notes:
      • There is a html file with install instructions.
      • Click on the .exe for the SP you want to install.  It will extract to a directory called "C:\SQL2KSP4".
        • SQL2000-KB884525-SP4-x86-ENU.exe - SP4 for SQL Server
        • SQL2000-AS... - I think is the Analytical Services
        • SQL2000.MSDE.... - I think is the MS Desktop Engine Component.
      • Go to the directory and read the readme file.
      • Click "setup.bat" to install.
        • Choose the "sa" option.
        • Backward compatibility checklist - Choose "Upgrade Microsoft search ..."
      • Note: I'm not sure if you can delete the directory after the install.
  • Analysis Services for SQL Server 2000 - another component you can install but is not needed for some applications.
    • Analysis Services - designed to facilitate online analytical processing (OLAP) and data mining applications.
    • After install you will see the following programs available: Start, Microsoft SQL Server, Analysis Services: Analysis Manager, Books Online, MDX Sample Application.
  • English Query - another component you can install but is not needed.
    • English Query - allows deverlopers to build applications that provide end-users with the ability to pose questions in English rather than forming questions with a SQL statement.
  • Additional Notes
    • DB's Created during Install - master, model, msdb, Northwind, pubs, tempdb
    • Services Installed:  MSSQLSERVER & MSSQLServerADHelper
       
• Windows Platform (Win 2000 Professional): SQL Server 7.0
  • Install SQL Server Components
    • Database Server - Standard Edition - This is for NT Server (maybe Win 2000 server)
    • Database Server - Desktop Edition - I've installed on Win 2000 Professional.
    • SQL Server OLAP Services
    • English Query
  • Database Server (Desktop Edition) Notes
    • Warning:  This is my notes for creating a development environment on a local machine for programming purposes - not production.
    • Choose the defaults except for the notes I've listed below.
    • Setup Type: Typical
    • Destination folders option: Program files and the Data files.
    • Services Accounts Screen - I've listed the options on this screen.
      • Choose one of the below.
        • Use the same account for each service. Auto start SQL Server Service <default>
        • Customize the settings for each service - use this if you want the SQL Server and SQL Server Agent to use different Username and Password.
      • Note: Services that will be installed:  SQL Server & SQL Server Agent
      • Service Settings
        • Choose one:
          • Use the Local System Account
          • User a Domain User Account <default>
        • This is the account and password.  For this example use your user name and password for login to windows.
          Username: <your user name>
          Password: <your
          Domain: <machine name>
        • Note: Common Development Environment uses:
          • Create a new user account via Windows.
          • User Name:  sa
            Pswd: <blank>
          • User type:  Not sure what type you should use.