How to Set Up a Microsoft SQL Server

by C.D. Crowder

Microsoft SQL Server allows you to create powerful database applications. SQL databases can serve as your front and back end for websites and programs. Setting up a Microsoft SQL Server involves installing several different components, including the database engine, reporting services, connectivity tools and sample databases. You can install SQL Server from a command prompt, but the easiest and most recommended method is by using the Microsoft SQL Server disk or disks. The SQL Server disk will also install the required Windows Updates you need to use the program.

1

Insert the Microsoft SQL Server disk in your CD/DVD drive. If the setup wizard doesn't begin automatically, explore the files on the disk and double-click the "setup.exe" file in the root folder.

2

Install any prerequisites. The SQL Server installation may try to begin at the same time. Exit the SQL Server installation and install prerequisites first. Agree to the license agreement for any prerequisites such as the .NET Framework. Follow the installation wizard to complete prerequisite installations. Click "Finish" when complete. Restart your computer if prompted. If all prerequisites are already installed, this step will be skipped.

3

Click "New Installation or Add Features to an Existing Installation" to begin the SQL Server installation. Press "OK" to set up log files. Choose whether your version of SQL Server is a free version or has a product key. If a product key is needed, enter your product key and press "Next."

4

Agree to the terms of service. Choose which components you wish to install. Place a check mark in the box of each component you want installed. Choose where you want to install SQL Server. Most users choose the default folder.

5

Choose whether you want to install a default or named instance. A named instance is typically used only if you will be installing multiple SQL Server instances. If any instance of SQL Server already exists, you must choose a named instance.

6

Select a log-on for the SQL services. One log-on can control all services, or each service can have a unique log-on. Continue following the SQL Server wizard to configure your selected services. Each component you chose to install will have a configuration wizard page.

7

Choose whether to enable error reporting. This sends nonidentifying information to Microsoft when SQL Server errors occur. This is turned on by default. Press "Install" after reviewing your configuration settings. Press "Close" once the installation is complete.

Tip

  • check If you want a completely clean installation, uninstall all instances of SQL Server before installing a new version.

Warning

  • close Remember your SQL Server password for each service. Applications and websites will require the password in order to access the database.

Items you will need

About the Author

C.D. Crowder has been a freelance writer on a variety of topics including but not limited to technology, education, music, relationships and pets since 2008. Crowder holds an A.A.S degree in networking and one in software development and continues to develop programs and websites in addition to writing.