How to install SQL Server 2012 Express Edition.
On the SQL Server Installation Center, make a click on the "Installation" hyperlink in the left
side of the screen.
Above you will find the first set of Setup Support Rules. The Next button is available only if all check results are successful, or if failed checks do not block installation. SQL Server may take you automatically to next page if no rules fail.
Access to the Internet is required, since SQL Server setup will try to get
updates for SQL Server during installation. If the computer does not have access
to the Internet and Windows Update service, uncheck the checkbox or, you may get the above error
The above screens belong to the second set of Setup Support Rules.
About the Windows Firewall warning, you can go ahead with the installation of
SQL Server, but when it finishes configure your Windows Firewall to allow SQL
Server access or disable it. Click
know how to configure Windows Firewall for SQL Server access.
After configuring Windows Firewall, the Windows Firewall warning will disappear
if you click on the "Re-run" button.
The above is the License Terms page. Read the license agreement and if you agree with it, check the "I accept the license terms" check box, and then click the Next button.
On the Instance Configuration page, choose a name for the instance or select a default instance. A default instance has the computer name as the name of the instance. On the above image, RTC is the name of the instance.
This Disk Space Requirements page is just for the purpose of reviewing disk usage. Click on the
"Next" button to continue setup.
SQL Server offers a virtual account as default SQL Server service account. A virtual is a "managed local account that provide the following features to simplify service administration. The virtual account is auto-managed, and the virtual account can access the network in a domain environment. If the default value is used for the service accounts during SQL Server setup on Windows Server 2008 R2 or Windows 7, a virtual account using the instance name as the service name is used, in the format NT SERVICE\<SERVICENAME>". For more information, click here.
Alternatively, you can create a local user or use a domain user account to start SQLServer
Whether you create a local user or a domain user account, the password you use
to create the account must be a strong password.
On the Database Engine Configuration page, choose the authentication mode to use for your SQL Server installation. Use a strong password for the sa account if you choose mixed authentication.
Click on the "Add Current User" button to add you Windows Account as SQL
Server Administrator or click on the "Add" button to add more local Windows
accounts or Domain accounts. This is recommended if you choose Windows
On the Error Reporting page, optionally clear the check box to
disable error reporting.
This installation completed successfully. Click OK and then click in the Close button.
Now let's enable protocols. Enable all three protocols. Click here to know how or see the following images:
Open SQL Server Configuration Manager, click on SQL Server Network Configuration on the left panel, then right click on each protocol and click on Enable.
Please enable SQL Server Browser service if you installed a named instance of
Now you can get connected to the instance using computername\nameoftheinstance or (local)\nameoftheinstance as the "Server Name" if you open SQL Server Management Studio to get connected to the instance. The default instance name is computername\SQLEXPRESS or (local)\SQLEXPRESS when SQL Server Express is installed, and not instance name was specified on the Instance Configuration page.
You are now ready to use SQL Server 2012. Enjoy it!
.Send mail to
questions or comments about this web site.