MS SQL Installation Notes
(MS SQL Server 2008)

Installation Notes

• Info For Reference
  • SQL Server 2000 - SP4 required for Update - Rule Check Results
    • SQL Server 2000 - must be SP4 or greater!
      Rule "SQL Server 2000 upgrade" failed
      The selected SQL Server 2000 instance does not meet the requirements for upgrade.  To continue install Microsoft SQL Server 2000 Service Pack 4 (SP4) or above.
      
      From Query Analyzer run:  select @@version
      Example of SP3: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
      (Warning:  I've seen SP3 show display when SP4 was really installed!!!)
  • Planning (You'll see these links from the Install DVD!) - you can skip this section if you want.
    • Microsoft Support - http://support.microsoft.com/ - if you need help with issues during the install.
    • Online Installation Help for 2008 - http://msdn.microsoft.com/en-us/library/bb500469(SQL.100).aspx
    • Hardware & Software Requirements - 32 & 64bit editions - http://msdn.microsoft.com/en-us/library/ms143506(SQL.100).aspx
      • .NET Framework 3.5 SP11 - will be installed during the install if it doesn't exist.
      • Microsoft Windows Installer 4.5 or a later version
    • Security - http://msdn.microsoft.com/en-us/library/ms144228(SQL.100).aspx
    • Release Notes - http://download.microsoft.com/download/1/6/3/163A851B-D956-42E9-B426-F5C0EBE6B654/ReleaseNotes.htm
    • Upgrade to 2008 - http://msdn.microsoft.com/en-us/library/bb677622(SQL.100).aspx
    • Failover Clustering - http://msdn.microsoft.com/en-us/library/ms189134(SQL.100).aspx
• Windows Platform: SQL Server 2008 (Developer Edition)
  • Close down all applications on your computer. Make SURE you do this!!!
  • Install DVD - Insert the "MS SQL Server 2008 Developer" install disks.
    (Note: The version I have had x86, x64 and Itanium based software.)
  • Start the Install - (click "setup.exe" or let DVD auto start launch it)
    • Errors launching the Install
      • OS: Windows Server 2000 SP4
        Error
        The procedure entry point GetConsoleProcessList could not be located in the dynamic link library KERNEL32.dll
        Solution: ???
        • Solution - NOT SUPPORTED on Win 2000 OS.
          http://msdn.microsoft.com/en-us/library/ms143506.aspx
           
  • Microsoft .NET framework, Windows Installer & Hotfixes - SQL 2008 needs a certain version or higher of these to products (see above "Info For Reference").
    Click "OK" - so install can check and/or install.
    Follow any prompts ..... 
    Reboot will occur next if any software is installed.
    Ex: .NET framework
    Ex:  Hotfix for Windows XP (KB942288-v3
  • Install Upgrade Advisor - If you will be upgrading from a version of SQL Server I suggest you do this install now.
    • Click "Planning" then "Install Upgrade Advisor".
    • Follow the prompts to install.
    • WARNING:  The "Upgrade Advisor" will not analyze a DB once you have installed MS SQL 2008 so do all your work with the "Upgrade Advisor" before you install MS SQL 2008!!!
      • MS SQL 2008 Upgrade Advisor - looks like the separate download will not help either.  It needs Windows Installer 4.5 which is not supported by Win 2000.
        http://www.microsoft.com/downloads/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en  - MS SQL 2008 Upgrade Advisor only
      • Error: "This installation package cannot be installed by the Windows Installer server.  You must install a Windows service pack that contains a newer version of the Windows Installer service."
        Note: On the URL above look for the link to "Windows Installer 4.5".  Warning: Not supported by Win 2000.
  • System Services - must stop all of SQL Server services if you already have a version of SQL server
    • Win XP Pro example: Start, Programs, Administrative Tools, Services
    • Stop all of the services:
      • MSSQLSERVER
      • MSSQL$<etc....>
      • SQLSERVERAGENT
      • SQLAGENT$<etc...>
  • Make sure you do the following:
    • Click "Planning", then "System Configuration Checker"
    • Make sure all items pass before you do the install!
      Note:
      The rule "Restart computer"
    • Notes on Failures: Setup Support Rules
      Steps: Insert the Install CD -> Planning -> System Configuration Checker
      • Failure
        Rule: Consistency validation for SQL Server registry keys - failed
        Error: Rule "Consistency validation for SQL Server registry keys" failed.
        The SQL Server registry keys from a prior installation cannot be modified.  To continue, see SQL Server Setup documentation about how to fix registry keys.
        • Solution
          Stop all of the SQL Services (see step above titled "System Services")
      • Failure
        Rule: "Restart computer" - Failed
        Error:  A computer restart is required.  you must restart this computer before installing SQL Server.
        • Solution
          Start the Install of SQL 2008.  After the "Setup Support Rules" screen shows with the "Restart computer" - Failed error then do the following.
          Start, Run, regedit
          Locate: "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
          Right click on "PendingFileRenameOperations" choose Modify and delete the value.
          Click "Re-run" on the "Setup Support Rules" screen of the install.
          Hopefully it will show "Passed".
  • Install Log:  (Use only if you have install issues!)
    Example location:
    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100506_140601\Summary_thomasma9300_20100506_140601.txt
  • Click "Install" on the left panel
  • Choose the option that fits your situation.
  • Upgrade Option
    • Continue with the prompts on the screen clicking "Next"
    • Select Instance - choose "MSSQLSERVER" - from the drop down. Click "Next".
    • Select Features - all Checked - click "Next"
    • Instance Configuration - click "Next"
    • Disk Space Requirements - click "Next"
    • Server Configuration - click "Next"
    • Full-text Upgrade - select "Import", click "Next".  (Later you will want ot "rebuild your full-text catalogs eventually")
    • Error and Usage Reporting - don't select any option (unless you are having install issues etc...), click "Next"
    • Upgrade Rules - make sure all have green checks.  If not you need to figure out why and fix. Click "Next".
    • Upgrade - click "Upgrade".
    • Follow the yellow brick road to a successful completion (We Hope!)
  • Look for the completed screen!

SQL 2008 (Other Topics)

• 2008 Upgrade Advisor
  • Run the Upgrade Advisor - Start, Programs, Microsoft SQL Server 2008, SQL Server 2008 Upgrade Advisor
    Click "Launch Upgrade Advisor Analysis Wizard
  • MS SQL 2000 - check the following:
    SQL Server
    Data Transformation Services - can analyze local DTS packages on the server or DTS package files.
    
    Optional - only if you have them:
    Analysis Services (If you have them it will complain later.)
    Reporting Services (If you have them it will complain later.)
     
• Where is Query Analyzer & Enterprise Manager?
  
  Microsoft SQL Server Management Studio - where you run queries & Enterprise Manager functions.
  • When you first launch the program answer yes to the following question:
    "There are SQL Server 2000 Enterprise Manager registered servers on this system.  Do you want to add them into Microsoft SQL Server Management Studio?  Adding the server registration information has no effect on the servers themselves" Yes or No (Note: choose Yes)

Last Screen after an Update from SQL2000 to SQL2008

The following notes apply to this release of SQL Server only.

 Microsoft Update 

For information about how to use Microsoft Update to identify updates for SQL Server 2008, see the Microsoft Update Web site <http://go.microsoft.com/fwlink/?LinkId=108409> at http://go.microsoft.com/fwlink/?LinkId=108409.

 Reporting Services

 The Reporting Services installation options that you specified in Setup determine whether additional configuration is required before you can access the report server. If you installed the default configuration, the report server can be used immediately. If you installed the program files only, you must run the Reporting Services Configuration tool to deploy the report server.

 To install the Reporting Services Add-in for SharePoint Technologies, start the rsSharePoint.msi in the Setup folder on the SQL Server 2008 installation media after SQL Server Setup is complete.

 Documentation and Samples

 To install the .NET Framework SDK, see “Installing the .NET Framework SDK” in SQL Server 2008 Books Online <http://go.microsoft.com/fwlink/?LinkId=114089> at http://go.microsoft.com/fwlink/?LinkId=114089.

 By default, sample databases and sample code are not installed as part of SQL Server Setup. To install sample databases and sample code for non-Express editions of SQL Server 2008, see the CodePlex Web site <http://go.microsoft.com/fwlink/?LinkId=87843> at http://go.microsoft.com/fwlink/?LinkId=87843. To read about support for SQL Server sample databases and sample code for SQL Server Express, see Databases and Samples Overview <http://go.microsoft.com/fwlink/?LinkId=110391> on the CodePlex Web site at http://go.microsoft.com/fwlink/?LinkId=110391.

 For more information about late-breaking changes in this release of SQL Server, see the latest readme file <http://go.microsoft.com/fwlink/?LinkId=100093> at http://go.microsoft.com/fwlink/?LinkId=100093.

For information about SQL Server 2008 Surface Area Configuration, see the following SQL Server 2008 documentation topics:

In SQL Server 2008 Books Online: “Understanding Surface Area Configuration.”

In SQL Server 2008 Setup Help: “Minimize SQL Server 2008 Surface Area.”

In SQL Server 2008 Books Online on MSDN: Understanding Surface Area Configuration <http://go.microsoft.com/fwlink/?LinkId=106282>    at http://go.microsoft.com/fwlink/?LinkId=106282.

MS SQL 2000 to MS SQL 2008 Migration Notes

• Terms

  • Integrated Services - the replacement for DTS packages.

• MS SQL 2008 Feature Pack Download

  • http://www.microsoft.com/downloads/details.aspx?familyid=B33D2C78-1059-4CE2-B80D-2343C099BCB4&displaylang=en  - MS SQL 2008 Feature Pack Download

• DTS (Data Transformation Services) support in SQL Server 2008

  • SQL Server 2000 Data Transformation Services (DTS) is deprecated

  • SQL Server 2008 provides optional 32-bit management, run-time, and design-time support for packages that were created by using the DTS tools and object model.

  • There is no design-time or run-time support for DTS packages on Itanium-based operating systems. Therefore, you cannot create, view, modify, or run DTS packages on Itanium-based operating systems.

  • http://msdn.microsoft.com/en-us/library/bb500440.aspx - Support for Data Transformation Services (DTS) in SQL Server 2008

  • http://msdn.microsoft.com/en-us/library/ms143755.aspx - How to: Install Support for Data Transformation Services Packages
    (The steps below were taken from this URL.)

    • Stop all services that start with MSSQL or SQL.
      Win XP Pro example: Start, Programs, Administrative Tools, Services

    • Insert install DVD, click "Installation", then in right panel click
      "New SQL Server stand-alone installation or add features to an existing installation"

    • Click through the rules etc... until you get to the screen: "Installation Type"

    • Choose "Add features to an existing instance of SQL Server 2008", click "Next"

    • Select the following:
      Integration Services - This option installs the ActiveX Script task and the DTS Package Migration Wizard.
      Client Tools Backward Compatibility - This option installs the Execute DTS 2000 Package task.
      Management Tools - Basic & Management Tools - Complete - SQL Server Command line and others.
      Business Intelligence Development Studio - management & development tools

    • Now follow the prompts to install....

    • Your finished with this part.

    • DTS Run Time Support (SQL Server 2005 Backwards compatibility)

      • Run the file from the DVD that is appropriate for your computer:
        ex:
        D:\x86\Setup\x86\SQLServer2005_BC.msi - 32 bit (most computers)
        D:\x64\Setup\x64\SQLServer2005_BC.msi - 64 bit.
        D:\ia64\Setup\ia64\SQLServer2005_BC.msi - Itanium-based 64 bit OS.

        • This file will install the following:
          Data Transformation Services 2000 runtime
          SQL Distributed Management Objects (SQL-DMO)
          Replication component (Repidts)
          SQL Virtual Device Interface (SQL VDI)
          Decision Support Objects (DSO)

      • Follow the prompts until Completed.
        -- OR -- Download from Microsoft and install:
        http://go.microsoft.com/fwlink/?LinkId=156660 - Microsoft SQL Server 2008 Feature Pack page

    • Integrated Services Runtime & Command prompt utilities

      • Should have been installed above when you installed "Management Tools-Complete" and "Business Intelligence Development Studio".
        Selecting either of these options installs the 32-bit version of the Integration Services runtime, the dtexec utility (dtexec.exe), and other Integration Services tools.

    • Design Time Support for DTS

      • Download the "Microsoft SQL Server 2000 DTS Designer Components" from the URL below:
        http://go.microsoft.com/fwlink?linkid=143539  - Feature Pack for Microsoft SQL Server 2005 - December 2008

      • SQLServer2005_DTS.msi - install this program!

    • Copy Files - DTS designer support for "SQL Server Management Studio" & "Business Intelligence Development Studio"
      (Note:  The files that are being "copied from" do not exist in the "copy to" directories.)
      
      Warning:  Check your "Program Files" directory and modify the "cd" command (rem etc..) to match your OS.
      
      C:
      rem cd "\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\"
      cd "\Program Files\Microsoft SQL Server\80\Tools\Binn\"
      rem
      rem *** needed for SQL Server Management Studio (SSMS)***
      COPY "SEMSFC.DLL" "..\..\..\100\Tools\Binn\VSShell\Common7\IDE"
      COPY "SQLGUI.DLL" "..\..\..\100\Tools\Binn\VSShell\Common7\IDE"
      COPY "SQLSVC.DLL" "..\..\..\100\Tools\Binn\VSShell\Common7\IDE"
      COPY "Resources\1033\SEMSFC.RLL" "..\..\..\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033"
      COPY "Resources\1033\SQLGUI.RLL" "..\..\..\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033"
      COPY "Resources\1033\SQLSVC.RLL" "..\..\..\100\Tools\Binn\VSShell\Common7\IDE\Resources\1033"
      rem ** needed for Business Intelligence Development Studio (BIDS) ***
      COPY "SEMSFC.DLL" "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE"
      COPY "SQLGUI.DLL" "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE"
      COPY "SQLSVC.DLL" "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE"
      COPY "Resources\1033\SEMSFC.RLL" "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE\1033"
      COPY "Resources\1033\SQLGUI.RLL" "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE\1033"
      COPY "Resources\1033\SQLSVC.RLL" "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE\1033"
      rem ** Not sure because the directory doesn't exist **
      MD "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE\Resources"
      MD "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE\Resources\1033"
      COPY "Resources\1033\SEMSFC.RLL" "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE\Resources\1033"
      COPY "Resources\1033\SQLGUI.RLL" "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE\Resources\1033"
      COPY "Resources\1033\SQLSVC.RLL" "..\..\..\..\Microsoft Visual Studio 9.0\Common7\IDE\Resources\1033"
      pause
       

    • Here is notes from the Web Site:
      
      To ensure that the DTS designer can be used in SQL Server Management Studio
      1.Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE folder.
      2.Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources folder to the %ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Resources\%lang_id% folder. For example, for U.S. English, the lang_id subfolder will be "1033".
      
      To ensure that the DTS designer can be used in Business Intelligence Development Studio
      1.Copy the files, SEMSFC.DLL, SQLGUI.DLL, and SQLSVC.DLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn folder to the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE folder.
      2.Copy the files, SEMSFC.RLL, SQLGUI.RLL, and SQLSVC.RLL, from the %ProgramFiles%\Microsoft SQL Server\80\Tools\Binn\Resources folder to the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\Resources\%lang_id% folder. For example, for U.S. English, the lang_id subfolder will be "1033".  (NOTE: \Resources\ doesn't exist for me!!!)

• Errors

  • Error Title: Object Explorer
    [DBNETLIB]ConnectionOpen(Invalid Instance()).]Invalid connection. (Microsoft OLE DB Provider for SQL Server)

    • Solution: See if the DTS package requires a specific DB to be present.

  • Opening a DTS local package:
    Open DTS 2000 Package
    SQL Server 2000 DTS Designer components are required to edit DTS packages.  Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this freature. (Microsoft.SqlServer.DtsObjectExplorerUI).

  • Opening DTS Structured File
    Package Error:
    Error Source: Microsoft Data Transformation Services (DTS) Package
    Error Description: The DTS host failed to load or save the package properly.
    Object Explorer:
    SQL Server 2000 DTS Designer components are required to edit DTS packages.  Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this freature. (Microsoft.SqlServer.DtsObjectExplorerUI).

  • Right click on a DTS local package and choose "Migrate".
    Package Migration Wizard
    DTS Migration Wizard Error
    [DBNETLIB]ConnectionOpen (Invalid Instance()).] Invalid connection. (Microsoft OLE DB Provider for SQL Server)
     

(Under Construction)

Miscellaneous Notes  - mostly from (from MS SQL 2000)

• 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 dying 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".

OLD INFO - UNDER CONSTRUCTION

• 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