May 16, 2011 at 6:54 am
I am trying to install Reporting Services onto a 32bit instance of SQL Service 2005 hosted on a PC running Windows 7 Enterprise 64 bit OS.
When I run the SetUp for SQL Server 2005 the Reporting Services option in the list of features to install is greyed out.
From what I have read, I suspect that the problem may be down to how IIS is set up on the PC.
I have followed all the steps set out in the prerequisite section of the msdn article on setting up Reporting Services (http://msdn.microsoft.com/en-us/library/bb630430(v=SQL.90).aspx)
World Wide Web Publishing Services is running as an automatic service.
I have applied SP4 to SQL Server 2005.
Does anyone have any thoughts?
May 16, 2011 at 7:30 am
Have you applied SP4 to Reporting Services?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
May 16, 2011 at 7:34 am
Hi,
I don't currently have Reporting Services installed on my PC (I am trying to add it to an existing SQL Server 2005 instance).
May 16, 2011 at 7:37 am
My apologies, please take a look at the following article
http://www.mssqltips.com/tip.asp?tip=1444
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
May 16, 2011 at 7:51 am
Thanks for that, but I'm afraid that it didn't resolve the problem.
May 16, 2011 at 8:01 am
One last chance and then I will leave you alone, have you truned on IIS 6?
http://www.igregor.net/post/2008/01/Installing-SQL-Server-2005-Reporting-Service-on-IIS-7.aspx
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
May 16, 2011 at 8:16 am
Yes, I had tried that. From other forums I have seen, that has sorted most people's problems with this. Not for me though!
I appreciate you taking time out on this.
May 16, 2011 at 11:11 am
david.Parsons 36778 (5/16/2011)
Yes, I had tried that. From other forums I have seen, that has sorted most people's problems with this. Not for me though!I appreciate you taking time out on this.
Check this thread if you are still having problem you may have to use the x86 version of SSRS.
http://www.sqlservercentral.com/Forums/Topic1029692-150-1.aspx
Kind regards,
Gift Peddie
May 17, 2011 at 8:12 am
Thanks for that. No joy I'm afraid. I've also tried uninstalling SQL Server 2005 and reinstalling from scratch but to no avail.
May 17, 2011 at 8:53 am
david.Parsons 36778 (5/17/2011)
Thanks for that. No joy I'm afraid. I've also tried uninstalling SQL Server 2005 and reinstalling from scratch but to no avail.
You are doing something wrong because that configuration is supposed to enable it so remove IIS 7.5 and add it again this time enable only what is in that link while you are at it make sure the application for SSRS is set to x86 and classic. The last time I installed it was also complicated but the remove and add only what is needed fixed it.
Kind regards,
Gift Peddie
May 17, 2011 at 9:50 am
I have tried removing IIS and adding only the config items suggested in the link included in the above post, but that didn't work. I've also attempted other IIS configurations including having everything selected as well as just about every combination of options selected/unselected.
As far as I can see IIS is running correctly. I can get into IIS Manager and //localhost/ comes back with the IIS page when I type that URL into a browser.
'Enable 32-Bit Applications' in 'application Pool Defaults' is set to true.
I am running 32 bit SQL Server 2005 on 64 bit Windows 7. It wouldn't surprise me if the problem related to compatibility between 32 bit SQL Server and the 64 bit O/S.
Please could you elaborate on what you meant by 'make sure the application for SSRS is set to x86 and classic' ? I didn't understand that.
Thanks
May 17, 2011 at 10:06 am
david.Parsons 36778 (5/17/2011)
I have tried removing IIS and adding only the config items suggested in the link included in the above post, but that didn't work. I've also attempted other IIS configurations including having everything selected as well as just about every combination of options selected/unselected.As far as I can see IIS is running correctly. I can get into IIS Manager and //localhost/ comes back with the IIS page when I type that URL into a browser.
'Enable 32-Bit Applications' in 'application Pool Defaults' is set to true.
I am running 32 bit SQL Server 2005 on 64 bit Windows 7. It wouldn't surprise me if the problem related to compatibility between 32 bit SQL Server and the 64 bit O/S.
Please could you elaborate on what you meant by 'make sure the application for SSRS is set to x86 and classic' ? I didn't understand that.
Thanks
Click on application pool and go to basic setting you may be in integrated mode change to classic and pointing to .NET 4.0 instead of 2.0 because even .NET 3.5 in Asp.net compiles to .NET 2.0. So check that and make changes as needed.
Kind regards,
Gift Peddie
May 17, 2011 at 10:16 am
In Application Pool / Set Application Defaults in IIS Manager I have set .Net Framework Version to 4 (was 2) and Managed Pipeline mode to Classic (was Integrated).
I restarted IIS, but still no effect I'm afraid.
I can't see any other settings that look like they may be relevant.
Thanks
May 17, 2011 at 10:23 am
david.Parsons 36778 (5/17/2011)
In Application Pool / Set Application Defaults in IIS Manager I have set .Net Framework Version to 4 (was 2) and Managed Pipeline mode to Classic (was Integrated).I restarted IIS, but still no effect I'm afraid.
I can't see any other settings that look like they may be relevant.
Thanks
Go to authentication make sure it Windows authentication is not disabled because it is disabled by default because Windows authentication is required for SSRS.
Kind regards,
Gift Peddie
May 18, 2011 at 2:47 am
Windows Authentication and Request Filtering are both selected in the Security options. All other Security features are off.
What I am wondering is:
1) Does Reporting Services have any other dependencies other than IIS (I have looked at Micosoft's webpage on Reporting Services and there is nothing to imply that there are additional dependencies).
2) Is there any logging that takes place during the install where setup decides what features of SQL Server will be available for installation. I intend to investigate this now.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply