www.dynamicintelligence.nl
blog.arjanfraaij.com
SQL Server Denali CTP3 Installation &
Configuration
Single Server
Name Arjan Fraaij
Version 1.0
Index
Contents Preface ..................................................................................................................................................... 3
Domain accounts & groups ................................................................................................................. 4
Domain accounts ............................................................................................................................. 4
Domain Groups ................................................................................................................................ 4
Installation .NET FrameWork 3.5 SP1 feature (Application Server Role) ............................................ 5
Installing SQL Server “Denali” CTP3 .................................................................................................... 9
Issue_01 Can’t use Domain Local Security group on DRC Administrators ........................................ 23
Preface This document describes the basic installation of SQL Server Denali CTP3 in a single server installation
environment.
De infrastructure used for this environment is described as follow:
DC01
SQL03
PC02
Domain Controller DC01
- Windows 2008 R2 Enterprise
- Domain di.local
SQL Server SQL03
- Windows 2008 R2 Enterprise
- SQL Server Denali CTP3
- Instance SQL03\MSSQL01
Client PC01
- Windows 7 Enterprise
This document describes only the installation of the SQL Server CTP3 initial installation. For
configuring several services keep your eye on my blog.
Initial Installation SQL Server “Denali” CTP3
Domain accounts & groups Before installing SQL Server I created the domain user accounts & security groups that I like to use
during installation.
Domain accounts
Account name Rights
di\SQL03Admin - Member of the local administrator group on server SQL03
- Member of Domain Local security Group SQL03DBEAdministrators
- Member of Domain Local security Group SQL03DRCAdministrators
- Member of Domain Local security Group SQL03AnalysisAdministrators
di\svcSQL03_sqlagent - Service account for running the SQL Agent services
di\svcSQL03_sqlas - Service account for running the SQL Server Analysis Services
di\svcSQL03_sqldbe - Service account for running the SQL Server Database Engine Services
di\svcSQL03_sqldrc - Service account for running the SQL Server Distributed Replay Client/Controller Services
di\svcSQL03_sqlis - Service account for running the SQL Server Integration Services
di\svcSQL03_sqlrs - Service account for running the SQL Server Reporting Services
Domain Groups
Account name Rights
di\SQL03AnalysisAdministrators - Domain local security group used the grant members of this group administration rights to the SQL Server Analysis Services
di\SQL03DRCAdministrators Remark: See issue_01
- Domain local security group used the grant members of this group administration rights to the SQL Server Distributed Replay Client/Controller Services
di\SQL03DBEAdministrators - Domain local security group used the grant members of this group administration rights to the SQL Server Database Engine Services
Installation .NET FrameWork 3.5 SP1 feature (Application Server Role) SQL Server requires have the .NET FrameWork 3.5 SP1 to be installed. Before starting the SQL Server
installation first install the Application Server Role with .NET FrameWork 3.5.1
1. Login with a local administrator (DI\SQL03Admin on the SQL03 server
2. Start the Windows Server Manager
3. Select the Roles node and click Add Roles:
4. Select the Application Server Role:
5. When the Add features required for Application Server appears select Add Required Features:
6. Click Next on the Select Server Roles Window:
7. Click Next on the Application Server window
8. Select .NET Framework 3.5.1 and click Next on the Select Role Services Window
9. Click Install on the Confirm Installation Selections window:
10. Wait for the installation to finish and click Close:
Installing SQL Server “Denali” CTP3 This chapter describes the basic installation of SQL Server Denali CTP3 on a Single server
environment. All features will be installed because this will be my play ground environment.
1. Login with a local administrator (DI\SQL03Admin on the SQL03 server
2. Mount the SQL11FULL_ENU_CTP3.iso or insert the DVD in your server
3. When you did not disable Autorun in you environment the Setup screen will appear, else browse
to the DVD and select setup Run as Administrator:
4. Select Installation on the SQL Server Installation window:
5. Select New SQL Server stand-alone installation or add features to an existing installtion
6. The installation will check the Setup Support Rules, Click Show details to see the checks
executed. Then click OK when no errors did appear.
7. Select Evaluation and click Next on the Product Key window:
8. Select I accept the license terms on the License Terms window.
I also select Send feature usage….. because I’m testing a CTP edition and like to help Microsoft in
there improvement on SQL Server. I will not do this in a production environment. Click Next:
9. Click next on the Setup Support Rules window.
The Microsoft .NET Application Security warning is displayed because my VM does not have
direct Internet Access.
The Windows Firewall warning is about configuring Firewall rules to gain remote access to the
SQL Server applications. See later chapter on how to configure the firewall.
10. Select SQL Server Feature Installation and click Next on the Setup Role window.
SQL Server PowerPivot for SharePoint will be on an other blog soon…
11. Click Select All on and then click Next on the feature Selection window.
Because this is a test environment I do the Select All, in production I would leave out client tools
and might even spread serveral services over multiple Servers depending on the requirements.
12. Click Next on the Installation Rules window, when no errors did occure.
13. I choose the create a Named Instance MSSQL01 and change the Instance root directory to
E:\MSSQL. This test/play ground server only has 2 disk C & E-Drive installed. Click Next
14. Click Next when the Disk Space Requirements did pass
15. On the Service Accounts tab in Service Configuration add the previous created Domain accounts
to the belonging Service and click the Collation tab.
16. On the collation tab select you desired collation, I kept the default for this environment and click
Next
17. On the Database Engine Configuration Select your desired authentication mode. Then click Add
to add the created domain local security group SQL02DBEAdministrators, click the Data
Directories tab.
18. Select the Root directory for the SQL Server data and set all data paths then click the FILESTREAM
tab.
When this would be a real server installation I will change the default locations as desired for
performance. This is a single server installation with only one attached data disk drive E.
19. On the filestream tab I selected all options and changed the share name to what I like. Then click
next
FILESTREAM is a feature of SQL Server which allows large binary unstructured data like documents and images to be stored directly
into an NTFS file system. FILESTREAM is not a Datatype like Varbinary(max). FILESTREAM is an Attribute or property which can be
enabled on a Varbinary(max) datatype column, which instruct the database engine to store the data directly on the file system.
Unstructred data like documents or images remain as an integral part of the database and maintain a transactional consistency. The
highpoint of this feature is simultaneous performance of the file system as well as maintenance of transactional consistency between
the Structured and Unstructured data.
20. Select your desired Analysis Server mode and click Add to add the SQL03AnalysisAdministrators
domain local security group to the AS administrators role. Click the Data Driectories tab.
You cannot change the SSAS mode you install after installation, when you need to use both then
you need to add another instance of analysis services with the other mode selected.
21. Again in this environment I have a single disk available for my data paths, in production choose
you data location so you get the best performance from you SAN or local disks. Click Next
22. Configuring reporting services will be done after installation, so select Install Only and click Next.
23. On de Distributed Replay Controller click Add and add the SQL03Admin domain account DO NOT
select the SQL03DRCAdministrators group that is listed in the domain groups section. See
Issue_01 why not. Click Next.
24. Give the DRC controller name and set you working & Result directory and click Next
The Microsoft SQL Server Distributed Replay feature helps you assess the impact of future SQL Server upgrades. You can also use it to
help assess the impact of hardware and operating system upgrades, and SQL Server tuning.
25. I select the Send Windows and SQL Server error reports…. In this test/play ground environment
to support Microsoft in the development. I do not select this on production environments. Click
Next.
26. Click Next when all Installation Configuration Rules are passed.
27. Click Install on the Ready to Install window
28. Wait for the installation to finish
29. Click Close when the installation is completed.
This finished the basic installation of SQL Server Denali CTP3.
Keep an eye on this blog to find added configurations to this document.
Issues
Issue_01 Can’t use Domain Local Security group on DRC Administrators During my first installation I used the given domain local security group SQL03DRCAdministrators to
be added to de DRC administrators role. This caused an error in finishing the installation.
I added a connect feedback, because I like to add groups on security roles. When you have the same
please visit: https://connect.microsoft.com/SQLServer/feedback/details/700181/install-drc-does-
not-except-domain-groups-during-install