Reporting Services Addin - Set Server Defaults Error

Hey All,

I installed Reporting Services Add-in with no problems on a Virtual server that already hosts MOSS 2007 and configured everything that was stated in documentation. The Report server Url works fine..like http://myserver1:802/ReportServer and I can see the contents when I type this url.

However, when I go to Central Administration and click on "Set Server Defaults"...I am getting a "401.1 Unauthorized..." error.I setup the Manage Integration to TrustedAccount and the Grant DatabaseAccess to the account that is the Server.Farm and local administrator.

In the Reporting Services Configuration, I used SSRSWebAccount for WebService and SSRSWindowsAccount for WindowsService and the RSAppPool which is the ApplicationPool for ReportingServices Web Site uses the SSRSWindowsAccount only.

Anybody..please help.

Thanks,

Vedala

I resolved my problem by installing SQL Server 2005 SP2. All along I assumed my virtual machine had SQL Server 2005 SP2, but after looking closely, I found that my version was 9.0.3033 and not 9.0.3042 which is official SP2 release version. I grabbed that and reinstalled it on my image and everything started working.

I however did couple of other steps too...which I did not go back and undo and test..so at this point I am not really sure if only the above was the problem or something else.,,, I will update this post with the blog entry about my issue later.

Thanks,

Vedala

Reporting Services Addin - Set Server Defaults Error

Hey All,

I installed Reporting Services Add-in with no problems on a Virtual server that already hosts MOSS 2007 and configured everything that was stated in documentation. The Report server Url works fine..like http://myserver1:802/ReportServer and I can see the contents when I type this url.

However, when I go to Central Administration and click on "Set Server Defaults"...I am getting a "401.1 Unauthorized..." error.I setup the Manage Integration to TrustedAccount and the Grant DatabaseAccess to the account that is the Server.Farm and local administrator.

In the Reporting Services Configuration, I used SSRSWebAccount for WebService and SSRSWindowsAccount for WindowsService and the RSAppPool which is the ApplicationPool for ReportingServices Web Site uses the SSRSWindowsAccount only.

Anybody..please help.

Thanks,

Vedala

I resolved my problem by installing SQL Server 2005 SP2. All along I assumed my virtual machine had SQL Server 2005 SP2, but after looking closely, I found that my version was 9.0.3033 and not 9.0.3042 which is official SP2 release version. I grabbed that and reinstalled it on my image and everything started working.

I however did couple of other steps too...which I did not go back and undo and test..so at this point I am not really sure if only the above was the problem or something else.,,, I will update this post with the blog entry about my issue later.

Thanks,

Vedala

sql

Reporting Services Add In

I am attempting to set up SharePoint and Reporting Services to run in
Integrated mode. I have successfully in stalled MOSS 2007 and Reporting
Services. I've installed SP2 for SQL Server and configured Reporting Services
to run in Integrated mode.
For some reason I cannot get the Reportnig Services add on for Sharepoint to
install. It gets to the very end of the installation and then performs a
rollback. I'm logged on as an Administrator. My user is also a farm
administrator. All the prereq's are installed.
The ONLY error I find in Even Viewer is the generic 11708 "failed to
install" error.
Has anyone else encountered this? If so, how did you resolve the issue?
Thanks!Check the log file at:
C:\Documents and Settings\[username]]\Local Settings\Temp\RS_SP_0.log
"A. Robinson" <ARobinson@.discussions.microsoft.com> wrote in message
news:2F9CDC1A-35C4-47D6-A81B-40594AA9A9F6@.microsoft.com...
>I am attempting to set up SharePoint and Reporting Services to run in
> Integrated mode. I have successfully in stalled MOSS 2007 and Reporting
> Services. I've installed SP2 for SQL Server and configured Reporting
> Services
> to run in Integrated mode.
> For some reason I cannot get the Reportnig Services add on for Sharepoint
> to
> install. It gets to the very end of the installation and then performs a
> rollback. I'm logged on as an Administrator. My user is also a farm
> administrator. All the prereq's are installed.
> The ONLY error I find in Even Viewer is the generic 11708 "failed to
> install" error.
> Has anyone else encountered this? If so, how did you resolve the issue?
> Thanks!
>