MS SQL Installation Notes
(MS SQL Server 2000)
- Default Port: 1433
- Other install notes
- SQL Server Key is stored in the registry at:
- 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
- Locate, and then delete the %drive%:\Program Files\Microsoft SQL
Make a backup of the Registry using regedit.exe
Using regedit.exe delete the following keys:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server
For the Default SQL Server Instance delete the following keys:
For any additional instances delete the keys:
For any clusters, remove those keys.
Reboot the server.
I like to delete the following directory after moving the Data
%drive%:\Program Files\Microsoft SQL Server
The following services should no longer be installed: MSSQLSERVER,
- 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
- 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".
- 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
- Click "SQL Server 2000 Components"
- Click "Install Database Server"
- Welcome to the Microsoft SQL Server Installation Wizard - Click
- 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:
- 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
- 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
Default Data Files: C:\Program Files\Microsoft SQL Server
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
- Service Accounts
Select "Use the same account for each service. Auto start SQL
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
- 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
- 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
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.
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.
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
- 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
- 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,
- 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
- 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
- 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>
Domain: <machine name>
- Note: Common Development Environment uses:
- Create a new user account via Windows.
- User Name: sa
- User type: Not sure what type you should use.