Holiday Specials! Save up to 60% on 13 dedicated server configurations.
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