RE: SQL Server reporting services , sharepoint integration
- From: v-fathan@xxxxxxxxxxxxxxxxxxxx (Mark Han[MSFT])
- Date: Tue, 03 Mar 2009 09:42:12 GMT
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 thereprot 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.
=========================================================
.
- Follow-Ups:
- References:
- Prev by Date: Re: Uninstalling SQL Server 2005
- Next by Date: Reporting services and a database server SQL Server 2005 standard
- Previous by thread: SQL Server reporting services , sharepoint integration
- Next by thread: RE: SQL Server reporting services , sharepoint integration
- Index(es):
Relevant Pages
|
