Wednesday, October 14, 2009

Installing SQL Server 2008 on Windows Server 2008 R2

Pre-requisites
- .NET Framework v3.5.1 Features (it will pop up a dialog about required role (Web Server) just accept it
- Components that need to add for Web Server Roles
- Common HTTP Features
- Static Content
- Default Document
- Directory Browsing
- HTTP Errors
- HTTP Redirection
- Application Development
- ASP.NET
- .NET Extensibility
- ASP
- ISAPI Extensions
- ISAPI Filters
- Health and Diagnostics
- HTTP Logging
- Request Monitor
- Security
- Basic Authentication (Optional)
- Windows Authentication
- Client Certificate Mapping Authentication (Optional)
- IIS Client Certificate Mapping Authentication (Optional)
- Request Filtering
- Performance
- Static Content Compression (Optional)
- Dynamic Content Compression (Optional)
- Management Tools
- IIS Management Console
- IIS 6 Management Compatibility (Optional)
- IIS 6 Metabase Compatibility (Optional)
- IIS 6 WMI Compatibility
- IIS 6 Scripting Tools
- IIS 6 Management Console

SQL Server SP 1 is required to run on Windows Server 2008 R2 also.

Windows Firewall with SQL
http://msdn.microsoft.com/en-us/library/cc646023.aspx
Just an idea for the port required
Integration – 135
SRS – 80
Analyses – 1434
SQL - 1433

Slipstream an installation of SQL Server 2008
http://support.microsoft.com/kb/955392

No comments:

Post a Comment