Last post Aug 23, 2011 04:22 AM by satishkumar.k
Aug 22, 2011 07:14 PM|krish3kiran|LINK
Just wanted to know whether IIS is a pre requisite for installing SSRS? I am installing SQlserver 2008 R2.
Also please tell me what is the order of installing the softwares? Visual studio 2008 and then sqlserver 2008 R2 or vice versa?
Thanks in advance
Aug 23, 2011 04:22 AM|satishkumar.k|LINK
Pelase check the below per requisite for SSRS ( Sql server 2008 R2).
SQL Server Setup installs the following software components required by the product:
.NET Framework 3.5 SP11
SQL Server Native Client
SQL Server Setup support files
SQL Server Setup requires Microsoft Windows Installer 4.5 or a later version
After installing required components, SQL Server Setup will verify that the computer where SQL Server 2008 R2 will be installed also meets all the other requirements for a successful installation. For more information, see
Check Parameters for the System Configuration Checker.
Network software requirements for the 64-bit versions of SQL Server 2008 R2 are the same as the requirements for the 32-bit versions.
Supported operating systems have built-in network software. Stand-alone named and default instances support the following network protocols:
Note Shared memory and VIA are not supported on failover clusters.
SQL Server 2008 R2 is supported in virtual machine environments running on the Hyper-V role in Windows Server 2008 SP2 Standard, Enterprise and Datacenter editions. The virtual machine must run an operating system supported for the specific SQL Server 2008
R2 edition listed later in this topic.
In addition to resources required by the parent partition, each virtual machine (child partition) must be provided with sufficient processor resources, memory, and disk resources for its SQL Server 2008 R2 instance. Requirements are listed later in this
Within the Hyper-V role on Windows Server 2008 SP2, a maximum of four virtual processors can be allocated to virtual machines running Windows Server 2008 SP2 32-bit or 64-bit editions. A maximum of 2 virtual processors can be allocated to virtual computers
that are running Windows Server 2003 32-bit editions. For virtual computers that host other operating systems, a maximum of one virtual processor can be allocated to virtual computers.
It is recommended that SQL Server 2008 R2 be shut down before shutting down the virtual machine.
For more information about the Hyper-V role in Windows Server 2008 SP2, see the Windows Server 2008 Web site.
Guest failover clustering is supported in SQL Server 2008 R2. For more information about the supported versions of SQL Server and operating systems for guest failover clustering, and the support for virtualization, see
Support policy for Microsoft SQL Server products running in a hardware virtual environment.
Microsoft Internet Explorer 6 SP1 or a later version is required for all installations of SQL Server 2008 R2. Internet Explorer 6 SP1 or a later version is required for Microsoft Management Console (MMC), SQL Server Management Studio, Business Intelligence
Development Studio, the Report Designer component of Reporting Services, and HTML Help.
Disk space requirements will vary with the SQL Server 2008 R2 components you install. For more information, see
Hard disk space requirements later in this topic.
A CD or DVD drive, as appropriate, is required for installation from disc.
SQL Server 2008 R2 graphical tools require Super VGA or higher resolution: at least 800x600 pixel resolution.
Pointing device: A Microsoft mouse or compatible pointing device is required.
1The following .NET Framework versions are required:
SQL Server 2008 R2 on Windows Server 2003 (64-bit) IA64 — .NET Framework 2.0 SP2
SQL Server Express — .NET Framework 2.0 SP2
All other editions of SQL Server 2008 R2 — .NET Framework 3.5 SP1
install software in the following order
1)visual studio 2008
2) SQl server 2008 r2