Monday, December 13, 2010

How to Install SQL SERVER 2011

This is step by step Walkthrough installation guide with images for SQL SERVER 2011
The installation of SQL SERVER 2011 is very much similar to SQL SERVER 2008, If you have already installed SQL SERVER 2008, You might not face any problem.

Microsoft has launched SQL SERVER 2011 "Denali"; I have downloaded MICROSOFT SQL SERVER "Denali" from

I hope SQL Server database professionals like administrators and t-sql developers find my SQL SERVER 2011 setup notes useful.
The Operating System requirements for Microsoft SQL Server 2011 "Denali" are
Windows Vista with SP2,
Windows Server 2008 with SP2,
Windows 2008 R2, and
Windows 7 operating systems.
What is interesting related with the supported operating systems list is Windows XP is not supported any more.
Although I have successfully installed MS SQL Server 2008 R2 Developer Edition on my Windows XP PC, SQL Server 2011 Denali CTP1 cannot be installed.
Here is a short list which you can review:
Windows PowerShell 2.0
Microsoft .NET Framework 3.5 SP1
Microsoft .NET Framework 4.0
Please note that these requirements for SQL Server Denali CTP may change with the new releases of Microsoft SQL Server 2011 and SQL Server Setup Application wizard.
Hardware and software requirements can also be seen from

This is the step by step installation guide of the SQL SERVER 2011 “Denali” on windows 7
I have installed x86 version of the product, you can proceed according to your system.

Extract the file at your desired location.

On start of setup, the first screen will be

These screens are very much similar to the SQL Server 2008.
After a while, next screen will appear

To view the hardware and software requirements for SQL Server 2011, visit the following Microsoft web site

On selection of New SQL Server stand-alone installation, the following screen will appear. On this screen Setup Support Rules will be executed to identify problems that might occur during installation SQL Server Setup support files. Before continuing to installation process, the failures listed must be corrected

No Reboot package error is found.
Reboot Package: : This rule determines whether the computer has the required update package that ensures that the computer will not have to be rebooted because of the Microsoft .NET Framework 4 installation.

If you are installing Microsoft SQL Server 2011 (aka Denali) on Windows 7 or on Windows 2008 R2 OS computer or server, please download the .NET 4.0 update from KB Article 958488
If you are installing Microsoft SQL Server 2011 on Windows Vista SP2 or on Widows Server 2008 SP2 operating system, then please download Microsoft .NET Framework 4.0 update from KB Article 956250
After the installation of .Net Framework 4.0, system will start, and after resuming the setup again, the screen will be displayed

After clicking OK button, the next screen will be of Product key, I prefer to use Microsoft SQL Server 2011 Enterprise Edition so I select Enterprise Evaluation from dropdown list.
Select the Enterprise Evaluation.

You must accept the license terms in order to continue the installation of Microsoft SQL Server 2011 (SQL Server Denali CTP).Accept the license terms in order to continue to Microsoft SQL Server 2011 installation (SQL Server Denali CTP).and then click next.

Click Install button to install SQL Server 2011 Setup Support files. SQL SERVER will install the setup support files that necessary during the installation.
Click Next button after selecting Microsoft SQL Server 2011 Denali CTP 1 features.
I just select the following Microsoft SQL Server 2011 features.
Click Next button for selecting among Microsoft SQL Server 2011 Denali CTP 1 features.

Select the SQL SERVER 2011 “Denali” features according to your requirements. I have selected all the features except SQL Server Replication, Full-Text Search, Analysis Services and Reporting Services for faster installation of SQL Server Setup

After SQL Server 2011 features selection for setup process, the installation rules are applied and give reasons for a possible failure.

On this screen (Instance Configuration), you can change the instance name of the system. This screen will also show the instances that already installed on the machine.
I have kept the default instance because I don’t have SQL Server installed on my machine.When you click on the Next button, the following screen will be displayed.

Information about the disk space required and available is displayed on this screen. Click the Next button to proceed.

This is screen is used for configuration of SQL Server. This screen will be used to specify the accounts under which the SQL SERVER services will run.
I have used the Windows NT service account, if you want to the same, then click on the button “Use the Same account for all SQL Services”. After clicking following screen will be displayed.

You can see the selection of NT AUTHORITY/SYSTEM. When you click OK, you will be back on SERVER CONFIGURATION screen.

On server configuration, you can also specify the startup You wants to start the service automatically , when the windows starts or you wants to start the service later from control panel > administrative tools > services.
You can also go to your services panel by just entering services.msc on your windows Start >Run

You can also specify the collation (Collation refers to a set of rules that determine how data is sorted and compared) for this instance of SQL Server.
I have kept the default settings for collation.
Click the Next, after doing necessary configurations.

This screen is used to give specify the Database Engine Configuration. From this screen we specify the authentication mode, Directories for SQL SERVER and Configuration for FILESTREAM. We will use the windows authentication. Click on “Add Current User”, the windows user will be added. Click on Data Directories tab.

You can change the path of SQL SERVER data directories. I have kept all the default options for this page.
Click on FILESTREAM tab.

You can configure the FILESTREAM from this screen. Just enable all the options specified. I didn’t configure the FILESTREAM so I didn’t make any changes on this page.
Click the next button to proceed.

This screen is used to send the errors that might occur during the installation of SQL SERVER.
Click the Next button.

On this screen SQL SERVER checks few rules, there is nothing to do on this screen.
Click Next

This is the last screen to start the installation. On this screen, SQL SERVER shows the features/components that are going to be installed.
Click the install button to start the installation.

This screen will be displayed at the END of installation process. It means that your installation of SQL SERVER is completed.

Select SQL Server Management Studio, this will be come under
Start >> Microsoft SQL Server Denali CTP1>>SQL Server Management Studio


Share This