Installing a SQL Server 2005 Instance

Learn how to install SQL Server 2005 instance with screenshots. (for newbies)
Video



1. Start the Microsoft SQL Server Installation Wizard by running the Setup application
using the menu that appears when you insert the CD. On the End User
License Agreement page, select the I Accept The Licensing Terms And Conditions
check box and click Next.
2. On the Installing Prerequisites page, click Next when the installation of the
required components completes.
3. On the Welcome To The Microsoft SQL Server Installation Wizard page, click
Next.
4. Verify the completion of the System Configuration Checker.




5. Click Next.
6. Fill in the appropriate user and organization name in the text boxes




7. Click Next.
8. Select the appropriate components to install by checking the box next to the
component. For this practice, you should install all the available components



9. Click Advanced. Expand the Documentation, Samples, And Sample Databases tree.
10. From the drop-down list associated with Sample Databases select Entire Feature Will Be Installed On Local Hard Drive.



11. Click Next.
12. Determine which instance names are already in use on the server by clicking
Installed Instances, which displays the window



13. Click OK.
14. Install a default instance


15. Click Next.
16. Review the components that will be installed and click Next.
17. Configure the service account information and the component startup information
by selecting Use The Built-In System Account and choosing Local System
from the drop-down list



18. Select the SQL Server Agent check box.
19. Click Next.
20. Configure the authentication mode by selecting Mixed Mode (Windows
Authentication And SQL Server Authentication)


21. Enter a strong password in the password text boxes. This password is used by
the sa login ID.
22. Click Next.
23. Review the default collation settings



24. Click Next.
25. Configure error and usage reporting by selecting both the Automatically Send
Error Reports and Automatically Send Feature Usage Data check boxes


26. Click Next.
27. Verify which components will be installed



28. Click Install.
29. Verify that setup is complete



30. Click Next and then review the completion report.
31. Click Finish.