Posts from the ‘SQL Server Denali’ Category

Installing SQL Server Denali CTP1 – Part 1

Here we will guide you through the step-by-step installation of SQL Server Denali CTP1 64bit version on SQL Server 2008 R2.

All these steps are for a brand new SQL Server stand-alone installation on a box and we will be installing default database instance. Components that will be installed are SQL Server database Engine, SSIS, SSAS, SSRS and all the shared components.

If you have ever done SQL Server 2008 R2 installation, then installing Denali CTP1 will be very simple. I cannot see much difference between the two, when it comes to installation.

Step 1: -

Once you have opened the SQL Server setup, go to Installation tab and click on “New SQL Server stand-alone installation or add features to an existing installation”

Step 2: -

This step will look for any problems that may cause the installation to fail. If it finds any rule as FAILED, then we need to fix that before proceeding to next step.

Step 3: -

If setup finds everything as expected, then you will see the screen similar to the one shown below.

OR

It is possible that some rules will fail like the one shown below. Here setup was looking for “no-reboot package”

Step 4: -

Here installer will ask for product key. Since we are installing the CPT evaluation version, so we have just selected Enterprise Evaluation Edition.

Step 5: -

Accept the licensing terms and go to next step.

Step 6: -

Here installer will install the support files.

 Next Steps..

Installing SQL Server Denali CTP1 – Part 2

Previous Steps..

Step 7: -

Once setup support files are installed, SQL Server setup will now look for support rules. We need to fix the ones, which failed before moving forward. We may ignore warning status for Windows Firewall. These settings we can do even after installing SQL Server. (Will be discussing more on Windows Firewall configuration on Windows 2008 R2 in future articles)

OR

You may get warning for other rules also like Windows PowerShell in below slide. Use below link to install Windows PowerShell. Use below link for Installing PowerShell

http://support.microsoft.com/kb/968930

Step 8: -

Here select “SQL Server feature installation” as we have to install SQL Server database Engine, SSIS, SSAS, SSRS and all the shared components.

Step 9: -

Click on “Select All” in-order to select all the database and shared components.

Here, we have to also provide path where we want the SQL Server shared features to install.

Step 10: -

Setup will check for installation rules and will show if any operation failed. If all operations completed without failures, move to next step.

Step 11: -

We have to select, what type of instance we want to install (default or named instance), provide path where binaries are to be copied.

Installer will also show, if any SQL Server instance already exists on this server.

Step 12: -

Installer will check for the available disk space and the required space for the installation to complete successfully. If everything is green, proceed to next step.

Step 13: -

Provide the account names against which the respective services should run. As a best practice we select all the services to run automatically, until or unless there is any specific reason as not to do so.

Step 14: -

Change collation setting if required. Installer will generally take the OS settings.

Step 15: -

Select the mixed mode authentication and provide ‘sa’ password. We can also add additional users as administrators at this point.

Next Steps..

Installing SQL Server Denali CTP1 – Part 3

Previous Steps..

Step 16: -

We have to provide the path for Data root directory, User database directory, User database log directory, Temp DB directory, Temp DB log directory and backup directory.

Step 17: -

Enable FileStream if required

Step 18: -

Provide details of users who should have admin privileges to SSAS

Step 19: -

Provide Data directory, Log directory, Temp directory and Backup directory for SSAS.

Step 20: -

Select appropriate option as how Reporting Services are to be configured by installer. Here we will install the native mode with default configuration.

Step 21: -

Click Next and move to next step.

Step 22: -

Installer will check for the installation configuration rule and will report if any rule failed. Move to next step if there are no failures.

Step 23: -

Installer will show a summary of all the configuration and settings that we have selected for the installation. Review the summary and click on Install if everything looks fine.

Step 24: -

It will take around 1hour if all components are installed as in this case; it also depends on hardware and components that are to be installed.

Once installation is completed successfully, we will see the below screen.

As a best practice, always check installation log under setup_bootstrap folder in C:\program files\Microsoft SQL Server\110\

Next steps are to do the database configuration like memory settings, creating maintenance plan jobs, etc. Also, make sure firewall settings are to be completed now (if not completed during the installation).