Install Microsoft SQL Server

The installation of Microsoft SQL Server, like that of various modern products is fairly easy, whether you are using a CD called SQL Server Developer Edition, a DVD or a downloaded edition. If you have it on CD or DVD, you can put it in the drive and follow the instructions on the screen as we will review them.

The following steps describe the installation on a Microsoft Windows 2000 Server by the Administrator account, a Windows XP Home Edition, a Windows XP Professional, or the downloaded edition on a Microsoft Windows 2000 Professional.

Log on to your Windows 2000 Server or open Windows 2000/XP Professional
Put the CD or DVD in the drive or download the trial edition of SQL Server
If you are using the CD or DVD, a border-less window should come up (if it doesn’t, open Windows explorer, access the drive that has the CD or DVD and double-click autorun)
If you had downloaded the file, you may have the Download Complete dialog box
In this case, click Open. A dialog box will indicate where the file would be installed
You can accept the default and click Finish. You may be asked whether you want to create the new folder that doesn’t exist and you should click Yes. After a while, you should receive a message indicating success:
Click OK
If you are using the CD installation, click SQL Server 2000 Components or press Alt C.
If you are using the downloadable edition, locate the folder where the files were installed. You should see an autorun icon. Double-click it.
Click SQL Server Components and click Install Database Server
On the first page of the Welcome wizard, click Next
On the second page, choose the type of installation you are performing by clicking the appropriate radio button. The Remote Computer choice would lead you to select a computer or provide its path so you can install SQL Server on a computer that is not close to you. Otherwise, accept or select the Local Computer radio button
After selecting the desired type of installation and if necessary providing the information needed, click Next
The next dialog box allows you to select an installation option such as performing an installation live or scheduling that can be done without your eyewitness supervision (second radio button). For this installation, you should accept the default first radio button and click Next
The next option allows you to type your name (the name you use here has nothing to do with authentication) and optionally your company. After doing this, click Next
Read the Software License Agreement COMPLETELY and, if you agree, click Next. If you don’t agree, click No and stop the whole thing. The next steps assume that you agreed with the small prints
Next, enter the 25-digit CD-Key and click Next
The next step provides other options for the installation type. The first radio button is mainly used if you are installing on a workstation that will be connecting to a server or to servers. The third option allows you to install only MDAC. You should accept or select the default second radio button
After making your selection, click Next.
If possible, accept the Default check box selected on the wizard page.
If you must enter an Instance Name, choose a convenient name and type.
Click Next
The next steps will need some decisions from you. For example, you must now set the amount of installation you want to perform and the folder in which you want to store SQL Server. In most cases, you can accept the default Typical
Click Next
The next step allows you to specify who is doing the installation. If you are an administrator, specify the account’s password. If you have an account that can perform an installation on the server, enter its username, its password, and the domain it belongs to.
Click Next
On the next step, you can accept to exclusively use Windows Authentication with the first radio button. Otherwise, you can and should use this opportunity to allow different persons to log in to this SQL Server. In this case, you can select the second radio button and create a password for the SQL Server Authentication, which would create and setup the sa account
You should never use or allow a blank password, even if you are working alone. For one thing, this would be a bad habit you should not let get to you. For another thing, database security should be one of your biggest concerns and an employer or a job interviewer would be happy to know that you take security issues to your heart and you care. If that’s the case, specify the type of authentication you will use. You should select
Click Next
Once Setup has enough information, on the last wizard page, simply click Next
Once the installation is over, click Finish

SQL Server Startup

To use SQL Server, it must start as a service. You have two options. You can start it every time you want to use. You can also make it start whenever the computer comes up from booting.
To start SQL Server, on the Taskbar, click Start -> Programs -> Microsoft SQL Server -> Service Manager
On the SQL Server Service Manager dialog box, click the Start/Continue button if necessary
On the lower-right corner of the desktop, on the clock section of the Taskbar, the button of SQL Server appears with a green play button .
Close the dialog box

Stopping SQL Server

To stop the SQL Server service, double-click the SQL Server icon on the Taskbar system tray
On the SQL Server Service Manager dialog box, click the Stop button
You will receive a confirmation message box. Click Yes.

Starting the SQL Server Service Automatically

Display the Control Panel window and double-click Administrative Tools
In the Administrative Tools window, double-click Services
In the Services window, scroll to the middle of the right frame and click MSSQLSERVER
On the toolbar, click the Start Service button
Close the Services window