Reporting Services Add-in for SharePoint

Hi!
I has added this pack for MOSS2007 server but can't add Reporting Services
web-part in any site.
In the Site Collection Features don't available Report Server Integration
Feature in the list.
Anybody have information for resolving this issue?
Thanks!
Andrey.You need to install the Reporting Services Add-in for SharePoint. This can
be found here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-
b331-132274ae8c84&DisplayLang=en
Once you install that the Integration Features will show up in Central
Admin.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Reporting Services Add-in for SharePoint
> thread-index: AcgM9WLa5NLs773ISuSFOI0+e6883w==> X-WBNR-Posting-Host: 207.46.193.207
> From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=<AndreyVasylenko@.discussions.microsoft.com>
> Subject: Reporting Services Add-in for SharePoint
> Date: Fri, 12 Oct 2007 10:29:04 -0700
> Hi!
> I has added this pack for MOSS2007 server but can't add Reporting
Services
> web-part in any site.
> In the Site Collection Features don't available Report Server Integration
> Feature in the list.
> Anybody have information for resolving this issue?
> Thanks!
> Andrey.
>|||Hi , Chris!
That add-in has installed already. In Central Admin page I can modify
Integration faetures. But on the sites I can't create reports using Report
Model and Report Builder.
WBR, Andrey.
"Chris Alton [MSFT]" wrote:
> You need to install the Reporting Services Add-in for SharePoint. This can
> be found here:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-
> b331-132274ae8c84&DisplayLang=en
> Once you install that the Integration Features will show up in Central
> Admin.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Reporting Services Add-in for SharePoint
> > thread-index: AcgM9WLa5NLs773ISuSFOI0+e6883w==> > X-WBNR-Posting-Host: 207.46.193.207
> > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> <AndreyVasylenko@.discussions.microsoft.com>
> > Subject: Reporting Services Add-in for SharePoint
> > Date: Fri, 12 Oct 2007 10:29:04 -0700
> >
> > Hi!
> > I has added this pack for MOSS2007 server but can't add Reporting
> Services
> > web-part in any site.
> > In the Site Collection Features don't available Report Server Integration
> > Feature in the list.
> > Anybody have information for resolving this issue?
> >
> > Thanks!
> > Andrey.
> >
>|||Have you added the Reporting Services document types to the document
library? If so are you getting an error when you try and add a new web part
of that type?
If you have NOT added the document types to the library yet you'll need to
do that. Follow the instructions here to do that:
http://msdn2.microsoft.com/en-us/library/bb326289.aspx
If you are getting an error then you'll need to configure kerberos
authentication correctly as that is most likely the issue.
Information on Security for SharePoint / SRS can be found here:
http://msdn2.microsoft.com/en-us/library/bb283324.aspx
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Reporting Services Add-in for SharePoint
> thread-index: AcgPE/euns22EAknRFev2m4IIhd8hg==> X-WBNR-Posting-Host: 207.46.19.168
> From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=<AndreyVasylenko@.discussions.microsoft.com>
> References: <09F5E9F6-48FA-4609-875D-9910C0251A9D@.microsoft.com>
<Ua5D1lPDIHA.5712@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Reporting Services Add-in for SharePoint
> Date: Mon, 15 Oct 2007 03:13:01 -0700
> Hi , Chris!
> That add-in has installed already. In Central Admin page I can modify
> Integration faetures. But on the sites I can't create reports using
Report
> Model and Report Builder.
> WBR, Andrey.
> "Chris Alton [MSFT]" wrote:
> > You need to install the Reporting Services Add-in for SharePoint. This
can
> > be found here:
> >
> >
http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-
> > b331-132274ae8c84&DisplayLang=en
> >
> > Once you install that the Integration Features will show up in Central
> > Admin.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Reporting Services Add-in for SharePoint
> > > thread-index: AcgM9WLa5NLs773ISuSFOI0+e6883w==> > > X-WBNR-Posting-Host: 207.46.193.207
> > > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> > <AndreyVasylenko@.discussions.microsoft.com>
> > > Subject: Reporting Services Add-in for SharePoint
> > > Date: Fri, 12 Oct 2007 10:29:04 -0700
> > >
> > > Hi!
> > > I has added this pack for MOSS2007 server but can't add Reporting
> > Services
> > > web-part in any site.
> > > In the Site Collection Features don't available Report Server
Integration
> > > Feature in the list.
> > > Anybody have information for resolving this issue?
> > >
> > > Thanks!
> > > Andrey.
> > >
> >
> >
>|||Thanks, Chris!
I had reolved this issue and now find information about creating reports in
Builder.
Please, let me know If you have examples of this reports.
WBR, Andrey Vasylenko.
"Chris Alton [MSFT]" wrote:
> Have you added the Reporting Services document types to the document
> library? If so are you getting an error when you try and add a new web part
> of that type?
> If you have NOT added the document types to the library yet you'll need to
> do that. Follow the instructions here to do that:
> http://msdn2.microsoft.com/en-us/library/bb326289.aspx
> If you are getting an error then you'll need to configure kerberos
> authentication correctly as that is most likely the issue.
> Information on Security for SharePoint / SRS can be found here:
> http://msdn2.microsoft.com/en-us/library/bb283324.aspx
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Reporting Services Add-in for SharePoint
> > thread-index: AcgPE/euns22EAknRFev2m4IIhd8hg==> > X-WBNR-Posting-Host: 207.46.19.168
> > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> <AndreyVasylenko@.discussions.microsoft.com>
> > References: <09F5E9F6-48FA-4609-875D-9910C0251A9D@.microsoft.com>
> <Ua5D1lPDIHA.5712@.TK2MSFTNGHUB02.phx.gbl>
> > Subject: RE: Reporting Services Add-in for SharePoint
> > Date: Mon, 15 Oct 2007 03:13:01 -0700
> >
> > Hi , Chris!
> > That add-in has installed already. In Central Admin page I can modify
> > Integration faetures. But on the sites I can't create reports using
> Report
> > Model and Report Builder.
> >
> > WBR, Andrey.
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > You need to install the Reporting Services Add-in for SharePoint. This
> can
> > > be found here:
> > >
> > >
> http://www.microsoft.com/downloads/details.aspx?FamilyID=1e53f882-0c16-4847-
> > > b331-132274ae8c84&DisplayLang=en
> > >
> > > Once you install that the Integration Features will show up in Central
> > > Admin.
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
> > > > Thread-Topic: Reporting Services Add-in for SharePoint
> > > > thread-index: AcgM9WLa5NLs773ISuSFOI0+e6883w==> > > > X-WBNR-Posting-Host: 207.46.193.207
> > > > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> > > <AndreyVasylenko@.discussions.microsoft.com>
> > > > Subject: Reporting Services Add-in for SharePoint
> > > > Date: Fri, 12 Oct 2007 10:29:04 -0700
> > > >
> > > > Hi!
> > > > I has added this pack for MOSS2007 server but can't add Reporting
> > > Services
> > > > web-part in any site.
> > > > In the Site Collection Features don't available Report Server
> Integration
> > > > Feature in the list.
> > > > Anybody have information for resolving this issue?
> > > >
> > > > Thanks!
> > > > Andrey.
> > > >
> > >
> > >
> >
>|||Check this link here:
http://msdn2.microsoft.com/en-us/library/ms155933.aspx
It generalizes what Report Builder does and has links at the bottom on how
to generate report models and so forth.
At the bottom you'll see a "Note:" section.
The short of it is hit F1 once Report Builder loads up and there should be
some information on how to use it to build reports.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Reporting Services Add-in for SharePoint
> thread-index: AcgQqsVZxwi6kwH5RtOJSnWFZIMZbg==> X-WBNR-Posting-Host: 207.46.19.197
> From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=<AndreyVasylenko@.discussions.microsoft.com>
> Thanks, Chris!
> I had reolved this issue and now find information about creating reports
in
> Builder.
> Please, let me know If you have examples of this reports.
> WBR, Andrey Vasylenko.
> "Chris Alton [MSFT]" wrote:
> > Have you added the Reporting Services document types to the document
> > library? If so are you getting an error when you try and add a new web
part
> > of that type?
> >
> > If you have NOT added the document types to the library yet you'll need
to
> > do that. Follow the instructions here to do that:
> >
> > http://msdn2.microsoft.com/en-us/library/bb326289.aspx
> >
> > If you are getting an error then you'll need to configure kerberos
> > authentication correctly as that is most likely the issue.
> >
> > Information on Security for SharePoint / SRS can be found here:
> >
> > http://msdn2.microsoft.com/en-us/library/bb283324.aspx
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --|||Hi, Chris!
Thanks for information!
I has created report in SQL Server BID Studio then uploaded it in MOSS 2007
library under System account. Now I can view report trough Report Viewer
fine!
Unfortunately under any other account (even with admin permissions in
MOOS2007 and SQL 2005) in Report Viever I got error:
--
An error has occurred during report processing.
Cannot create a connection to data source 'DataSource1'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
--
At SQL server I got next error
--
Failure Audit:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 192.168.33.38]
--
Did you know resolving this issue?
Now 1-st server SQL 2005 SP2 with all DBs (including RS Add-in created) and
2-nd with MOSS2007 and Reporting Services Add-in.
Thanks!
WBR, Andrey Vasylenko.
"Chris Alton [MSFT]" wrote:
> Check this link here:
> http://msdn2.microsoft.com/en-us/library/ms155933.aspx
> It generalizes what Report Builder does and has links at the bottom on how
> to generate report models and so forth.
> At the bottom you'll see a "Note:" section.
> The short of it is hit F1 once Report Builder loads up and there should be
> some information on how to use it to build reports.
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Reporting Services Add-in for SharePoint
> > thread-index: AcgQqsVZxwi6kwH5RtOJSnWFZIMZbg==> > X-WBNR-Posting-Host: 207.46.19.197
> > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> <AndreyVasylenko@.discussions.microsoft.com>
> >
> > Thanks, Chris!
> > I had reolved this issue and now find information about creating reports
> in
> > Builder.
> > Please, let me know If you have examples of this reports.
> >
> > WBR, Andrey Vasylenko.
> >
> > "Chris Alton [MSFT]" wrote:
> >
> > > Have you added the Reporting Services document types to the document
> > > library? If so are you getting an error when you try and add a new web
> part
> > > of that type?
> > >
> > > If you have NOT added the document types to the library yet you'll need
> to
> > > do that. Follow the instructions here to do that:
> > >
> > > http://msdn2.microsoft.com/en-us/library/bb326289.aspx
> > >
> > > If you are getting an error then you'll need to configure kerberos
> > > authentication correctly as that is most likely the issue.
> > >
> > > Information on Security for SharePoint / SRS can be found here:
> > >
> > > http://msdn2.microsoft.com/en-us/library/bb283324.aspx
> > >
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > --
>|||That most likely means you have anonymous access turned on for one of your
IIS web sites somewhere. Reporting Services and SharePoint integration
requires Windows Integrated or Forms Authentication for the integration to
function properly.
Also, you have "Windows Integrated Security" turned on for your Report Data
Source which is getting the credentials from IIS (which is the anonymous
account) and that is why you are seeing the NT Authority user come up. If
you want you can change your data source to use "Credentials Stored
Securely in the Report Server" and specify some windows creds or SQL Auth
to pass to the data source instead of trying to pass the credentials.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Reporting Services Add-in for SharePoint
> thread-index: AcgReRr0cB6fW03jTR+VczmGe+LfEQ==> X-WBNR-Posting-Host: 207.46.19.197
> From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=<AndreyVasylenko@.discussions.microsoft.com>
> References: <09F5E9F6-48FA-4609-875D-9910C0251A9D@.microsoft.com>
<Ua5D1lPDIHA.5712@.TK2MSFTNGHUB02.phx.gbl>
<F745C498-D926-44F7-B253-5096012D5D8C@.microsoft.com>
<1UYT0hyDIHA.5712@.TK2MSFTNGHUB02.phx.gbl>
<A9D4F711-EB48-4022-922D-00255577E855@.microsoft.com>
<zHfxAKMEIHA.4200@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Reporting Services Add-in for SharePoint
> Date: Thu, 18 Oct 2007 04:22:02 -0700
> Hi, Chris!
> Thanks for information!
> I has created report in SQL Server BID Studio then uploaded it in MOSS
2007
> library under System account. Now I can view report trough Report Viewer
> fine!
> Unfortunately under any other account (even with admin permissions in
> MOOS2007 and SQL 2005) in Report Viever I got error:
> --
> An error has occurred during report processing.
> Cannot create a connection to data source 'DataSource1'.
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
> --
> At SQL server I got next error
> --
> Failure Audit:
> Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT:
192.168.33.38]
> --
> Did you know resolving this issue?
> Now 1-st server SQL 2005 SP2 with all DBs (including RS Add-in created)
and
> 2-nd with MOSS2007 and Reporting Services Add-in.
> Thanks!
> WBR, Andrey Vasylenko.
>
>
> "Chris Alton [MSFT]" wrote:
> > Check this link here:
> > http://msdn2.microsoft.com/en-us/library/ms155933.aspx
> >
> > It generalizes what Report Builder does and has links at the bottom on
how
> > to generate report models and so forth.
> >
> > At the bottom you'll see a "Note:" section.
> >
> > The short of it is hit F1 once Report Builder loads up and there should
be
> > some information on how to use it to build reports.
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Reporting Services Add-in for SharePoint
> > > thread-index: AcgQqsVZxwi6kwH5RtOJSnWFZIMZbg==> > > X-WBNR-Posting-Host: 207.46.19.197
> > > From: =?Utf-8?B?QW5kcmV5IFZhc3lsZW5rbw==?=> > <AndreyVasylenko@.discussions.microsoft.com>
> > >
> > > Thanks, Chris!
> > > I had reolved this issue and now find information about creating
reports
> > in
> > > Builder.
> > > Please, let me know If you have examples of this reports.
> > >
> > > WBR, Andrey Vasylenko.
> > >
> > > "Chris Alton [MSFT]" wrote:
> > >
> > > > Have you added the Reporting Services document types to the
document
> > > > library? If so are you getting an error when you try and add a new
web
> > part
> > > > of that type?
> > > >
> > > > If you have NOT added the document types to the library yet you'll
need
> > to
> > > > do that. Follow the instructions here to do that:
> > > >
> > > > http://msdn2.microsoft.com/en-us/library/bb326289.aspx
> > > >
> > > > If you are getting an error then you'll need to configure kerberos
> > > > authentication correctly as that is most likely the issue.
> > > >
> > > > Information on Security for SharePoint / SRS can be found here:
> > > >
> > > > http://msdn2.microsoft.com/en-us/library/bb283324.aspx
> > > >
> > > > --
> > > > Chris Alton, Microsoft Corp.
> > > > SQL Server Developer Support Engineer
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > > --
> >
> >
>