SQL Server
http://amitelman.wordpress.com/2013/01/10/install-sql-server-2005-32-bit-on-windows-server-2008-r2-64-bit/
On default installation Windows Server 2008 R2 (x64) machine you may receive System Configuration Check warnings:
- IIS Feature Requirement (Warning)
- ASP.Net Version Registration Requirement (Warning)
- ASP.Net Version Registration Requirement (Warning)
You need install missing components.
Open Server Manager – Start. All Programs. Administrative tools. Server Manager.
On the left tab Click on Roles, then on Add Roles. Click Next. On Server Role screen check Web Server (IIS). Click Next two time until you get into Role Services screen.
In Addition to checked add :
HTTP Redirection
ASP.NET
Windows Authentication
IIS 6 Metabase Compatibility
IIS 6 WMI Compatibility
Click on Next
Click on Install
HTTP Redirection
ASP.NET
Windows Authentication
IIS 6 Metabase Compatibility
IIS 6 WMI Compatibility
Click on Next
Click on Install
Run SQL server setup again. If you install 32-Bit SQL on 64-Bit Windows you may get one more Warning message:
- ASP.Net Version Registration Requirement (Warning)
ASP.Net Version Registration Requirement 64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).
ASP.Net Version Registration Requirement 64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).
To fix this we need Enable 32-Bit Applications Pool.
Open Server Manager. Expand Roles, Web Server (IIS), Internet Information Services (IIS) Manager.
On the right side you will see Connections tab. Click on your server. Two more tabs will appear – Application Pools and Actions. Expand your server by clicking on +. Click on Application Pool. Click on DefaultAppPool.
On Action tab click Set ApplicationPool Deafaults… Change Enable 23-Bit Applications value to True. OK
Run Setup again. System Configuration Check runs without warnings:
Installation successful.
select @@version
