RS2005 + Sharepoint 2007; installation doesn't works...

Hi,
I try to setup a server to test the integration of RS with sharepoint 2007.
The SP2 is installed on the server and the Sharepoint addin installed too.
I have created a RS instance and setup this instance to support sharepoint.
but in the application management pages of sharepoint I don't see the
reporting services section like describe in the installation document.
so the installation doesn't works and I don't see any error anywhere.
my server is an x64 version (windows, sql and sharepoint are in x64)
what can I do to diagnose what's appends?
thanks.
Jerome.Here you mean email subscription or file shared.
For file shared subcsription, you can give the authentication when you
create the subscription ,the option is available in the same page.
For email, go to Report Configuration from menu and give the server name
for authentication, you need to change the report server config file. "Search
for "SMTP" and you can give your authentication etc...
Amarnath, MCTS.
"Jeje" wrote:
> Hi,
> I try to setup a server to test the integration of RS with sharepoint 2007.
> The SP2 is installed on the server and the Sharepoint addin installed too.
> I have created a RS instance and setup this instance to support sharepoint.
> but in the application management pages of sharepoint I don't see the
> reporting services section like describe in the installation document.
> so the installation doesn't works and I don't see any error anywhere.
> my server is an x64 version (windows, sql and sharepoint are in x64)
> what can I do to diagnose what's appends?
> thanks.
> Jerome.
>
>|||Sorry wrongly posted.
Amarnath, MCTS
"Amarnath" wrote:
> Here you mean email subscription or file shared.
> For file shared subcsription, you can give the authentication when you
> create the subscription ,the option is available in the same page.
> For email, go to Report Configuration from menu and give the server name
> for authentication, you need to change the report server config file. "Search
> for "SMTP" and you can give your authentication etc...
> Amarnath, MCTS.
> "Jeje" wrote:
> > Hi,
> >
> > I try to setup a server to test the integration of RS with sharepoint 2007.
> >
> > The SP2 is installed on the server and the Sharepoint addin installed too.
> > I have created a RS instance and setup this instance to support sharepoint.
> >
> > but in the application management pages of sharepoint I don't see the
> > reporting services section like describe in the installation document.
> >
> > so the installation doesn't works and I don't see any error anywhere.
> >
> > my server is an x64 version (windows, sql and sharepoint are in x64)
> >
> > what can I do to diagnose what's appends?
> >
> > thanks.
> >
> > Jerome.
> >
> >
> >|||Jeje
I am having the same problem.
I hope someone posts a solution.
Regards,
Ben
"Jeje" <willgart@.hotmail.com> wrote in message
news:%23JHwTBQbHHA.3616@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I try to setup a server to test the integration of RS with sharepoint
> 2007.
> The SP2 is installed on the server and the Sharepoint addin installed too.
> I have created a RS instance and setup this instance to support
> sharepoint.
> but in the application management pages of sharepoint I don't see the
> reporting services section like describe in the installation document.
> so the installation doesn't works and I don't see any error anywhere.
> my server is an x64 version (windows, sql and sharepoint are in x64)
> what can I do to diagnose what's appends?
> thanks.
> Jerome.
>sql

RS Integration with SharePoint 3.0 - Query with userid parameter

When integrating SQL Reporting Services 2005 with Sharepoint Services 3.0, and you have a SRS report that runs over a view with the UserID as a parameter (to filter the records the user has access to), will the SharePoint ReportViewer passover the UserID to RS and RS to SQL?

Sharepoint security with Reporting Services stops at Item level or does it impersontate down to SQL? Should authenticating be Integrated or SQL ? Should the userid in SQL be exact match with Sharepoint? Or are they mapped somewhere?

Thank You!!

Hi,

actually these are two different questions:

it depends how you implemented the authentication. If reports are called by Sharepoint, it is possible to use the information of the Windows Identity to authenticate against the SQL Server. As you are using a UserId approach and not the actual identity at the SQL Server level you could also use SQL Server authentication to run the query of the report. So the following options could be available:

[Report (UserId) -- IIS (Windows Integrated Authentication)] -- SQL Server (SQL Server Authentication with static credentials)

[Report (UserId) -- IIS (Windows Integrated Authentication)] -- SQL Server (Windows Authentication)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

RS and ASP.NET app integration

Hello,
How to share single Login, Application/Session state across different
ASP.NET web application and RS's ReportManger application?
Is it possible?
TIA,
KamelYou can't do application/session state between RS and your app. Makes no
sense, what are you sharing?
As far as login. Same box or different box? Integrated security or have you
implemented your own?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"kamel" <kwiciak@.gmail.com> wrote in message
news:1159887717.120970.217640@.e3g2000cwe.googlegroups.com...
> Hello,
> How to share single Login, Application/Session state across different
> ASP.NET web application and RS's ReportManger application?
> Is it possible?
> TIA,
> Kamel
>|||One login and user data for two application is the first option to
consider for me.