RE: SQL Server reporting services , sharepoint integration

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I am pretty sure I meet the prerequisites. I have a MOSS standard sharepoint
farm using NLB already set up. The sql 2005 SP3 cluster is also the
sharepoint DB instance and I am using that same instance so create the
reporting database. In the howto you shared where does the .net framework
go, SQl or sharepoint (which already has it). Also in the howto is the
wonderfully informative step 2 "Configure the report server if it is not
configured already, and verify you have a valid installation" This of course
is what the article is supposed to be explaining. I do not get an error per
se. The sharepoint page simply refuses to acknowledge the fact that I am
running the database in SP integrated mode. unfortunatly I am adding this on
to the existing cluster so I can't follow the howto exactly. but it seems to
me that I am stuck at step 2.

"Mark Han[MSFT]" wrote:

Hi Jim,

Thank you for using Microsoft MSDN Managed Newsgroup. My name is Mark Han.
I am glad to work with you on this issue.

From your description, I understand that you would like to configure the
reprot service run under SharePoint Integrated Mode
If I have misunderstood, please let me know.

in order to resolve the issue, i would like to explain the following
1) A report server is configured for SharePoint integrated mode if it has
the following characteristics:
a) The report server is running SQL Server 2005 SP 2, the target instance
of the SharePoint technology is version 3.0, and both servers meet the
requirements for running in this mode. For more information, see
Requirements for Running Reporting Services in SharePoint Integrated Mode.

b) The report server database is created with an option that flags it for
integrated operations. When you connect a report server instance to a
report server database that runs in SharePoint integrated mode, the report
server property SharePointIntegrated is set to True automatically. In this
mode, the report server switches to the custom security extension and SOAP
endpoint that are used when a report server is set for SharePointIntegrated
mode.

c) When the report server database is created with SharePointIntegrated
mode set, the site hierarchy in Windows SharePoint Services becomes the
content hierarchy for the report server. The report server accepts only
fully qualified SharePoint URLs as paths. No relative paths are allowed.
File extensions for each item are required. For more information about the
hierarchy and URL requirements, see Deploying Reports, Models, and Shared
Data Sources to a SharePoint Site.

d) Both the report server and the SharePoint Web application are configured
for connections to and from each other, and the report server is granted
permissions to the SharePoint databases.

2 please check if the Requirements for Running Reporting Services in
SharePoint Integrated Mode is met:
there is an article to share with you:
http://msdn.microsoft.com/en-us/library/bb283190(SQL.90).aspx

3 Besides, please double confirm if the step for Configure SharePoint
Integration is correct. there is an article to share with you
How to: Configure SharePoint Integration on a Standalone
Server:http://msdn.microsoft.com/en-us/library/bb677368(SQL.90).aspx

Hope the above helpful.

after checking the above, if the issue still happens, please post the
detail error message.

I look forward to hearing from you.

Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx

============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================


.

Relevant Pages