Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

SQL Server 2005 Issue


Dear All,

When i try to install SQL Server 2005 in one of my server Server (Server OS: Windows 2008) i cant choose Reporting Services, its totally disable, i cant choose to install, could any one help me how can i install SQL Server 2005 Full with Reporting Services

Thanks

Kumar
0
Ram Kumar Chellam
Asked:
Ram Kumar Chellam
2 Solutions
 
WalkaboutTiggerCommented:
IIS must be installed before Reporting Services can be installed.
0
 
Pratima PharandeCommented:
for Sql server 2005 reporting service

System Requirements
 
Windows Server 2003 / Windows 2000 Server/ Windows vista / Windows XP/ Windows Server 2008
IIS 5.0 or later is required for Microsoft SQL Server 2005 Reporting Services (SSRS) installations.
ASP.NET 2.0 is required for Reporting Services. When installing Reporting Services, SQL Server Setup will enable ASP.NET if it is not already enabled.
SQL server 2005 with SP1(In case you need to reinstall reporting services its advised to reinstall full SQL server rather then just reporting services).
SQL Server Setup requires Microsoft Windows Installer 3.1 or later and Microsoft Data Access Components (MDAC) 2.8 SP1 or later.

for more details
http://weblogs.asp.net/akjoshi/archive/2008/06/06/Installing-and-configuring-sql-server-2005-reporting-services.aspx
0
 
FemSteenkampCommented:
also note that the IIS services must be running and specific options checked

go look at

http://msdn.microsoft.com/en-us/library/bb839480(SQL.90).aspx?ppud=4

gives detail about which IIS options need to be up and running for reporting services
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Ram Kumar ChellamAuthor Commented:

I install IIS 7. .NET & ASP.NET, but still i cant choose Reporting Services

Any other Idea to help me

Thanks
0
 
FemSteenkampCommented:
you followed the instructions in the artice with which sub components needs to be selected.   some of tehm are not done so by default (i.e. just adding the role by clickin next and accepting the defaults
0
 
samijsrCommented:
Check If IIS is running and you are able to see default IIS page in web browser
0
 
Ram Kumar ChellamAuthor Commented:
Thanks
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now