Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

MOSSchampions — Tue, 20 Feb 2007 00:12:48 GMT

SQL Server 2005 Service Pack 2 (SP2), which will be released any minute now :-), enables deep integration

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

dlgross — Tue, 20 Feb 2007 05:24:01 GMT

How does Sql Reporting Services SP2 work with SPS 2003?

Cosas Interesantes 20/02/2007

Be Geek My Friend — Tue, 20 Feb 2007 09:51:01 GMT

Hoy en cosas Interesantes: CTP de Febrero de Longhorn, Virtual PC 2007, SQL RS SP2 y Sharepoint, Management

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Sergey — Tue, 20 Feb 2007 15:44:46 GMT

Is it possible to integrate SQL Server Reporting Services with WSS3 not MOSS ?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Cornelius J. van Dyk — Tue, 20 Feb 2007 18:22:40 GMT

This new level of integration is awesome. Hopefully it will help drive greater addoption of Reporting Services in our firm as well. :)

Later

Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

Meron Fridman's Blog — Tue, 20 Feb 2007 22:23:40 GMT

The Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Kyler — Wed, 21 Feb 2007 03:13:36 GMT

I am trying to use SQL Server 2005 sp2 Reporting Services in Integrated mode with WSS 3.0. When I am in Reporting Services Configuration Manager on the Sharepoint Integration tab, I get the following error message...

The report server cannot access settings in the Sharepoint configuration database. Most likely, the Windows Sharepoint Services object model is not installed...

Reporting Services is running on a separate machine from WSS 3.0. Do they need to be on the same machine??? Do I need to install WSS on the Reporting Server just to get the object model?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Paul Yau — Wed, 21 Feb 2007 05:29:25 GMT

I guess I experienced the same issue. My SQL Server 2005 + SP2 + Reporting Services + RS Add-in for MOSS installed on one server and MOSS 2007 installed on another server; I follow [SQL Server 2005 Books Online - How to: Install the Windows SharePoint Services Object Model on a Report Server Computer], error occur when the SQL Server trying to connect to the MOSS farm. Any ideas?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Hugo Figueira — Wed, 21 Feb 2007 15:21:36 GMT

Hi!

Have you executed the the bellow steps?

SQL 2005 Reporting Services can be separate from the Office SharePoint Server 2007, but if it is, you must also do a basic install of Office SharePoint Server 2007 on the Reporting Services server to ensure that the Windows SharePoint Services (WSS) 3.0 object model is installed.

Regards,

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Natron — Thu, 22 Feb 2007 01:58:04 GMT

Has anybody able to get a report in a document library to display in a Report Viewer Web Part using Web Part connections? We tried but the URL is incorrect- the site collection part is doubled up, and we get the error "the item http://...../sites/testsite/sites/testsite/document%20Library/chart.rdl" cannot be found. Thanks!

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

bwelcker — Thu, 22 Feb 2007 09:07:05 GMT

Natron, unfortunately, it looks like this is a bug that creeped into the final build. We are working on a fix for this.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Larry Chambers — Fri, 23 Feb 2007 21:52:11 GMT

I tried to install the Sharepoint Reporting Services addin from SP2 and ended up disabling my Sharepoint configuraiton....After I installed I get

"Server Error in '/' Application.

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed. "

I tried the steps on Brian Wecklers Weblog for resolving this issue and ensured that I installed under the account that SharePoint Services was setup with....but no luck....any suggestions from folks?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Daryl — Fri, 23 Feb 2007 22:03:16 GMT

The integration is fairly nice, as far as it goes.

What we really need is the ability to use SharePoint lists as a data source for RS reports. Right now I'm building datasets and SQL ##temp tables by hand, then calling Reporting Services over SOAP to build the report I want. This is no way to run a railroad.

More generally, we need managed ADO drivers for SharePoint lists. And we need SharePoint lists to become robust. Lists which slow down if you put more than 2,000 items in them are a problem. SharePoint needs to grow up.

In a nutshell: Reporting Services Addin for SharePoint 2007

harbar.net — Sat, 24 Feb 2007 17:58:51 GMT

In a nutshell: Reporting Services Addin for SharePoint 2007

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Thomas — Tue, 27 Feb 2007 16:54:00 GMT

Hi,

I just tried to install the Add-In but I don't get new entries in central administration. I found the log file in %temp% and it says 'User does not have permission to add feature to site collection' but later on says 'Cab file installed successfully'.

Running on German W2K3 Server, german MOSS.

Thanks, Thomas

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Adam — Wed, 28 Feb 2007 02:58:04 GMT

-----

I tried to install the Sharepoint Reporting Services addin from SP2 and ended up disabling my Sharepoint configuraiton....After I installed I get

"Server Error in '/' Application.

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed. "

-----

Same issue here. I will let you know if I figure out how to resolve it.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

o3APA3A — Thu, 01 Mar 2007 02:07:24 GMT

Web sites cannot be enabled for Anonymous access? Why? Is there a workaround for the Forms authentication?

Integración de Reporting Services con SharePoint (I)

Blog del CIIN — Fri, 02 Mar 2007 10:26:17 GMT

En este post vamos a explicar los pasos a seguir para la instalación y el uso de Microsoft SQL Server

Yes! I’m still here! I’m just building Reports in SharePoint with SQL Server 2005 SP2!

Tom Rizzo's SharePoint Blog — Sun, 04 Mar 2007 18:57:27 GMT

As you may be wondering based on my lack of postings whether I'm still around. Well, yes I am! We've

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

abates — Mon, 05 Mar 2007 21:55:27 GMT

Is there any other troubleshooting info available or known issues with the installation of the Add-IN? Would be nice to explore the wonderful features but can't seem to get it installed.

We've got a clean install of MOSS and SSRS side-by-side with a remote database configured for Integrated mode. The Add-in install is where it goes south:

Cab files installed successfully.

Stopping W3SVC service.

Install error: Time out has expired and the operation has not been completed.

Uninstalling Report Server feature.

What I've tried so far..

Created a seperate app pool am running and installing under a Domain account that is also a Farm Admin and also a site administrator in all the sites. I've even disabled virus scanning. I've checked that there are no leftovers in the web.configs or in any .resx files left in App_GlobalResources.

Thanks in advance,

SQL2005 Express With Advaced Services Issues

MB — Tue, 06 Mar 2007 03:38:45 GMT

Why doesn't "SQL2005 Express With Advaced Services" Reporting Service support integration with WSS 3.0 ?

I think we should get such support, in order to setup test and evaluation environments, so later on we move to "THE REAL" MOSS ... ;-<

Is this being considered ?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

rgrossat — Tue, 13 Mar 2007 19:50:27 GMT

-----

I tried to install the Sharepoint Reporting Services addin from SP2 and ended up disabling my Sharepoint configuraiton....After I installed I get

"Server Error in '/' Application.

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed. "

-----

Same issue here. I will let you know if I figure out how to resolve it.

------

Same as you. I´m in contact with support. Update as soon as I have some news.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Bruce Herz — Wed, 14 Mar 2007 00:14:57 GMT

I have a number of Clients using Small Business Server 2003 R2 Premium which runs SQL Workgroup Edition.

Is it true that Report Server SP2 Does Not support SharePoint integrated mode for SBS 2003 R2 Workgroup Edition ?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Don — Wed, 14 Mar 2007 18:28:07 GMT

Any update on this? I'm also getting this error.

Windows Server 2003 with Sharepoint 2007

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

rgrossat — Wed, 14 Mar 2007 19:57:36 GMT

I tried to install the Sharepoint Reporting Services addin from SP2 and ended up disabling my Sharepoint configuraiton....After I installed I get

"Server Error in '/' Application.

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed. "

-----

Same issue here. I will let you know if I figure out how to resolve it.

------

Same as you. I´m in contact with support. Update as soon as I have some news.

-----

Here he solution:

If you installed a previous Customer Technical Preview (CTP) release of the Reporting Services Add-in, you might encounter server or configuration errors when installing a newer version. The ReportServer.resx file is not removed when you uninstall a CTP, causing the error "The namespace 'Resources' already contains a definition for 'ReportServer'" to occur when you install a newer version. To work around this error, delete ReportServer<cultureID>.resx from the \inetpub\wwwroot\wss\virtualdirectories\<portnumber>\App_globalresources folder, and then re-run Setup for the Reporting Services Add-in.

URGENT : ERROR Reporting Services integration with MOSS 2007

Patrick — Wed, 14 Mar 2007 21:04:58 GMT

Hi,

I just tried to install the Add-In but the installation failed I found the log file in %temp% and it says

"Cab files uninstalled successfully.

Starting W3SVC service.

SSRSCustomActionError: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\stsadm.exe return error code: -1 "

Many thanks for your help, Patrick

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

LLiu — Sat, 17 Mar 2007 22:56:41 GMT

The "2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005" whitepaper (1.5 MB in size and in Word 2007 .DOCX format) is now downloadable from http://download.microsoft.com/download/c/5/9/c5955aa6-97e4-4b30-9b15-3d37e2be82e7/SQL%20Server%202005%20and%20Office2007%20Business%20Intelligence%20Whitepaper%20Jan312007.docx.

Reporting Services AddIn

SharePoint, SharePoint and stuff — Thu, 22 Mar 2007 15:45:28 GMT

Liam hat in 4 sehr ausführlichen Artikeln die Intergration und Konfiguration von SQL Reporting Services

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Nikola Paunovski — Thu, 22 Mar 2007 20:04:26 GMT

I'm very disappointed by Microsoft with the fact that they overlooked users who are on the SBS 2003 platform and have no means of upgrading to the standard Edition of the MS SQL 2005 server,

In order for such environment to have use of this integratiuon feature they need to

1. Purchase additional hardware

2. Purchase Server platform with additional client licenses

3. Purchase MS SQL 2005 Standard edition and additional server licenses.

At the end SBS 2003 Premium edition users need to invest over $30000 in order to have this feature functional in their environment.

At the end of the day we ask ourselves

Is this worthed?

Nik

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

cvallandingham — Wed, 04 Apr 2007 00:00:16 GMT

-----

I tried to install the Sharepoint Reporting Services addin from SP2 and ended up disabling my Sharepoint configuraiton....After I installed I get

"Server Error in '/' Application.

Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed. "

-----

Same issue here. I will let you know if I figure out how to resolve it.

------

Same as you. I´m in contact with support. Update as soon as I have some news.

I found that removing the report viewer using add/remove programs did not remove a verb from my various sharepoint web.config files.

Integration between Windows Sharepoint Services 3.0 and MS SQL 2005 Reporting Services SP2

Pankaj Sabnis' blog for SharePoint Technologies — Sun, 15 Apr 2007 07:32:37 GMT

WSS 3.0 and MS SQL 2005 Reporting Services Integration Introduction: MS SQL Server Reporting Services

Sharepoint & SQL Reporting Service on X64

JimF — Sat, 21 Apr 2007 05:01:02 GMT

Is it possible to run Sharepoint Services and SQL Reporting Service on Windows 2003 X64. Sharepoint seems to require IIS to be in 32 bit emulation mode and SQL RS requires 64 bit IIS.

Thanks

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

cvallandingham — Fri, 27 Apr 2007 17:09:17 GMT

I am troubleshooting an issue with integrated Reporting Services that seems to be related to the AAM. Here’s my layout (simplified)

DNS >> NLB >> Web1 or Web2

In the AAM when the Public URL for Zone is the DNS name Reporting Services calls fail with connection closed errors (see below). If I use one of the Web front end servers for the Public URL everything works as expected.

I am unsure how the Public URL is affecting the calls to Reporting Services. Any help or insight would be much appreciated.

An unexpected error occurred while connecting to the report server.

Verify that the report server is available and configured for SharePoint integrated mode.

--> The underlying connection was closed: An unexpected error occurred on a receive.

--> Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

--> An existing connection was forcibly closed by the remote host

The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

An existing connection was forcibly closed by the remote host

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Darren — Thu, 03 May 2007 00:54:55 GMT

Any chance of having the whitepaper '2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005' in another format other than Word 2007?

Thanks

RS SP2 + MOSS2007 on same server (Not working)

Kevin cole — Fri, 11 May 2007 01:56:46 GMT

I've made a completely fresh machine from scratch in a virtual environment, installed SQL2005 SP2, Win2K3 Svr Sp2, Moss 2007 Enterprise (Using a domain impersonation account).

I've setup and configured reports server now in sharepoint integration mode.

I've installed the Additional package for webparts & whatnots for the sharepoint server.

Configured and connected the sharepoint site to the report server in the central admin.

I use the business intelligence studio to generate a Report model project & make a data source, data source view, and report model. I configure the properties:

Cleared the Target Data Source Folder & Target Model Folder.

Set the Target Server URL to the sub-site I've created (under the current account I'm logged into on the machine) to:

http://vm-spkevinc/ReportsTest/

I try to deploy it to the server and it sits there forever deploying, and finally returns with "Unauthorized Exception" in the w3ws.exe process and "A connection could not be made to the report server http://vm-spkevinc/ReportsTest/"

What's going on?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Andy — Fri, 11 May 2007 13:51:09 GMT

I have setup WSS 3.0 with Reporting Services in integrated mode (on the same server) and it all works well. The problem I am having is launching Report Builder from a browser that isn’t running on the server (it works on the server). The error I get is “Cannot retrieve application. Authentication error.” And in the details looks like an authorization error - “The remote server returned an error: (401) Unauthorized.”. I am using window authentication (NTLM) and the user I use is local to the server. I have tried allowing anonymous access for the site but this hasn’t worked.

I can start report builder if I link directly to the report builder virtual directory which has anonymous access enable (http://<host>/reportserver/reportbuilder/reportbuilder.application) but this doesn’t really help.

Any help would be great.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Sachin — Mon, 14 May 2007 08:40:51 GMT

In some installation of Share point 2007, I am not able to get complete option list of Reports. Like I am not able to get Manage Parameters etc in option list.

so how to resolve this problem?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Derek — Mon, 14 May 2007 17:16:48 GMT

Has anyone managed to get this working on a domain controller? I'm trying it on a vpc which is a DC, and the "grant database access" step always fails with "A new member could not be added to a local group because the member has the wrong account type"

Thanks

Derek

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Guy — Wed, 16 May 2007 11:49:11 GMT

I have a MOSS 2007 site set up on "localhost" and RS 05 is running in native mode, publishing to localhost:8080/reportserver. I want to be able to view the reports in sharepoint webparts on the site. I have seen several posts saying this is possible but none step through how to do it. (i do not want to use integration mode)

I am using the ReportViewer webpart and typing in the address of the reports to point at -

http://localhost:8080/Reports/Pages/Folder.aspx?ItemPath=%2fexample&ViewMode=List

but this gives the error:

The path of the item '/localhost:8080/Reports/Pages/Report.aspx?ItemPath=%2fexample%2fReport1' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)

No matter how i change the path name i cant find the format to put it in that will make it work. Any ideas? if i remove all the characters like ':,%,&' etc then the error changes to "item not found", as this is now obviously the wrong address.

Any help would be much apreciated!

Guy

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Clayton — Wed, 16 May 2007 22:49:20 GMT

Does installing the SharePoint object model on the SSRS servers in a scale-out scenario constitute another SharePoint server licence? We already have a SharePoint EE farm, and an SSRS NLB cluster we want to convert to integrated mode, but have not been able to get an answer on the licencing issue.

Thanks,

Clayton

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

May — Thu, 14 Jun 2007 11:39:43 GMT

I also experience the same error message...

"The report server cannot access settings in the Sharepoint configuration database. Most likely, the Windows Sharepoint Services object model is not installed..."

Later, I installed Microsoft Framework 3.0, SharePoint Service and RS Add in for MOSS, the error message is gone and the integration ok. Before that, you need to configure the database setup in RS Configuration and set the Server mode to SharePoint Integration mode.

Hope this help.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Jatin Purba — Thu, 14 Jun 2007 22:16:52 GMT

Hi,

I have installed SQL server 2005 ,sp2 for sql server MOSS 2007 and Add-in on the same PC . but when i go to the central administrator it does not show the reporting services options there...any ideas ??

Thanks in advance...

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Brett — Fri, 22 Jun 2007 02:47:52 GMT

When trying to deploy a report from visual studio to a document librar folder I recieved the error "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators." I verified that both .rdl, .rds and .rsds are not blocked. Are there any other file types that are deployed to the library?

thanks,

Brett

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Brett — Sat, 23 Jun 2007 01:45:33 GMT

I've solved the problem above but I now have an issue when I try to deploy a report it fails becuase it is looking for the reportservice2005.asmx on the sharepoint server instead of the report server. Any ideas on what settings might be wrong? In visual studio I have the target path information pointing to the site and document library in sharepoint and not the report server location.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Gunady — Mon, 25 Jun 2007 14:08:04 GMT

I have successfully configured the Reporting Services with Sharepoint

Integration Mode and everything seems working fine until I try to

extend existing web application. I have created alternate mapping

using port 80 to existing site (use port 88). When I access reports

through port 80, I receive error: "The specified path refers to a

SharePoint zone that is not supported". Reports in Port 88 still work

fine. How do I configure Reporting Services with Sharepoint

Integration mode to run in alternate mapping port?

2007 MOSS Resource Links (Microsoft Office SharePoint Server)

The Boiler Room - Mark Kruger, Microsoft SharePoint MVP — Tue, 26 Jun 2007 18:12:51 GMT

2007 MOSS Resource Links (Microsoft Office SharePoint Server) Here is an assortment of various 2007 Microsoft

Oracle stored procedures in SQL server reporting??

Srimadhav — Fri, 29 Jun 2007 17:16:34 GMT

Hi,

I want to use orcale stored procedures in sql server 2005 reporting services. Can any one suggest whether it is possible or not.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Srinivas — Tue, 03 Jul 2007 22:40:58 GMT

Hi Everybody,

I was undergoing different sites to get a good article on Integrating SQL Reporting services with wss(3.0). Many blogs provides links to this article, here every one are talking abt MOSS with Reporting services.

Did any one completely worked on purely wss3.0 and Integrating SQL Reporting services with wss3.0. Please understand wss not MOSS.

I have done all the steps mentioned above to integrate wss-sql reporting services, but as the screen shots provided above , i dont see

Reporting Services available in Application Management of Central Administration.

Please Advice

Many Thanks,

Srinivas

SQL Maintenance Plans and MOSS give 100% CPU error

Mirrored Blogs — Sat, 28 Jul 2007 01:01:53 GMT

Andrew Bridgeman recently emailed me about an issue he had encountered with his internal MOSS 2007 deployment

Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Contagious Curiosity — Thu, 02 Aug 2007 00:58:46 GMT

Well-written blog post. SSRS 2005 SP2 integration with WSS 3.0 and MOSS 2007

Microsoft SQL Server Reporting Services - Installation and Configuration Guide for SharePoint Integration Mode

Microsoft SharePoint Products and Technologies Team Blog — Fri, 03 Aug 2007 00:10:47 GMT

In looking at the comment stream for the “Microsoft SQL Server 2005 SP2 Reporting Services integration

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Pat — Mon, 13 Aug 2007 19:03:06 GMT

Hi all,

I am hitting road block when i try to deploy reports to SharePoint Integrated reporting service.

I have set the

Data source to http:/sharepointserver/site/sharepointsubsite/documents/my folder

TargetReportSserver:

http:/sharepointserver/site/sharepointsubsite/documents/my folder

TargetURL :

http:/sharepointserver/site/sharepointsubsite

what am I misssing on this. I get follwoing error:

Connection could not be made to the report server

http:/sharepointserver/site/sharepointsubsite

WHY!!! :(

Please HELPPPPPP

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

ainur — Thu, 16 Aug 2007 10:02:04 GMT

how do i get Microsoft SQL Server 2005 Reporting Services? where? and how? thank you..

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Jamie — Thu, 16 Aug 2007 22:20:12 GMT

For those folks having trouble deploying reports from Visual Studio (receiving errors like "A connection could not be made to the report server" or "The file you are attempting to save or retrieve has been blocked from this Web site by the server administrators."), make sure you have the SP2 Client Components for SQL Server 2005 installed.

I spent a long time trying to figure out the problem only to find that I needed to upgrade the client components. Hopefully this will save others some time.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Jamie — Thu, 16 Aug 2007 22:23:22 GMT

Reporting Services is part of SQL Server. If you start up the installation of SQL Server, you will a feature called Reporting Services.

Reporting Services References for Continued Learning

MidMarket Events — Fri, 17 Aug 2007 21:34:48 GMT

Great follow up question from our SQL/BI session this past week. Q. I would like to learn as much as

Problem trying to "Grant database Acess"

divyarekha — Thu, 30 Aug 2007 13:13:08 GMT

Hi,

I have installed the Add-In. But while tring to 'Grant Database access', after I enter the credentials, I get the error "Report Server WMI Provider error: Not found".

Can anyone help me with this?

Thnx in advance.

-Mathi

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Lily — Mon, 03 Sep 2007 06:59:51 GMT

Is it possible to use reporting services to create a shopping cart for a Sharepoint Page created with MOOS 2007?

problems instaling add in

Nikola — Mon, 10 Sep 2007 18:11:30 GMT

I am having trouble with instaling the Reporting Services add in for sharepoint. I am trying to solve this issue 3 days alredy, i did everhing like in recomandations (SSRS and WSS 3.0 installed on same computer), SQL SP2 installed, etc... after i install add in i cannot see the reporting services section in administration menagement. I have looked in installation log of the add in which can be found in C:\Documents and Settings\<username>\Local Settings\Temp. After installing i have this information in RS_## log file:

copyappbincontents command completed successfully.

Adding Report Server feature to farm.

Installed Report Server feature.

Activating Report Server feature to root level site collections.

Activating feature in web app 'SharePoint - 80'

Activating feature to root site collection: http://spttk

Feature already activated in site collection http://spttk

Activateing Report Server feature in all admin site collections.

Activating feature in web app ''

Activating feature to root site collection: <sharepoint server name>

******* User does not have permission to add feature to site collection: <sharepoint server name>

Updating DocIcon.xml file

DocIcon.xml file updated.

Beginning install of cab files.

Calling HCInstal for lcid '1033'

and at the end it says that cab files are installed successfully. I would be greatfull if you can help me asap.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Bryon — Sat, 15 Sep 2007 19:10:25 GMT

Can anyone here help?

Here is the scenario in

more details:

MOSS 2007

SQLServer 2005

SSRS

SSIS

SSAS

BizTalk 2006

The use case is as follows:

-Each week a user is responsible for maintaining ~800 records. Maintenance of

these records will be governed through enterprise workflow tool built into

MOSS/BizTalk. In order to perform one of the workflow steps the user must run

a report to identify which 800 records needs to be actioned this week. The

report (FILTER) and the result of the report must be MOSS WebParts, ideally

out-of-the-box.

Use case individual steps:

1. User sets parameters and runs report to identify relevant records

2. User manipulates a subset of records (in an adjunct webpart?) and

creates/updates/deletes data for these records

3. User saves changes

There are three ways of performing #1 using MOSS/SQLServer

A. Install SSRS and SSRS MOSS Add-in. Out-of-the-box webparts become

available and everything is good. **This option is not available as SSRS must

be in “Integrated”mode, but we are in a “Native” mode installation here and

cannot convert to Integrated mode.

B. Deploy SSRS parameterized reports to a common directory and make these

reports available via standard webpart. **Not very user-friendly, not sure if

I can get at the record-based information for updating (Use Case #2)

C. Develop custom solution via SharePoint Designer 2007. ** Not a good

option – breaks our design constraint of “minimal coding”

My questions:

i) Am I missing any obvious ways to tackle these use cases?

ii) For use case #2 – have any of you done this before? Bear in mind that

this is not simply updating a table – we will be updating workflow

parameterized information and multiple tables.

Installing SSRS After SP2 has been installed

Bryan — Mon, 01 Oct 2007 17:44:13 GMT

Is it possible to install SSRS after SP2 has been installed and get the MOSS integration mode to work? All the instructions say to install SP2 first, but I am past that point already on my server, and after I do the installation of SSRS the MOSS integration mode doesn't work? Is there an install of SSRS available that already has the SP2 code itegrated?

Thanks

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

David Richter — Fri, 05 Oct 2007 18:10:01 GMT

The SQL mgt Studio that the user connects to would easily produce reports, web applications, and use the browser to examine worksheets throu

I SQL Server 2005 Reporting Services SP2 su SharePoint 2007

Igor Macori — Tue, 09 Oct 2007 15:18:37 GMT

Spesso mi viene chiesto come integrare i SQL Server 2005 Reporting Services SP2 su SharePoint 2007 (WSS

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

wali — Thu, 25 Oct 2007 21:13:55 GMT

We are deploying MOSS 2007 in x64 and have back-end SQL Server 2005 in x32 seperate box and SQL Server Reporting Server x32 also on seperate box. Is there any issue with this configuration where MOSS x64 integrates with x32 Reporting Server?

SQL Server Reporting Services与MOSS集成资料汇总

Allen Zhang — Fri, 09 Nov 2007 09:48:47 GMT

SQLServer2005ReportingServices与MOSS2007集成，使用SSRS制作报表，在MOSS中显示。

AccessingSharePointListIt...

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

fengerzh — Thu, 22 Nov 2007 09:02:53 GMT

Hi, Nikola,

You may try this solution: http://spsolution.blogspot.com/2007/11/installing-microsoft-sql-server-2005.html

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Jake — Wed, 28 Nov 2007 20:53:49 GMT

Installed MOSS 2007 3 times, but no luck to have Report Center, Report Library or Data Connection Library in the library list...

Report Center is said to be an out-of-box feature of MOSS 2007. Where is it? I want to know how to open up the BOX...

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

El Bruno — Wed, 28 Nov 2007 22:29:08 GMT

Hi to all ...

is there any way to use a mixed parameter definition when a report is called; i.e.: I want to apply a filter in a report in Moss, based on a user property.

Any ideas ??

Thanks in advance

Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Jaswant — Mon, 17 Dec 2007 14:17:01 GMT

How to overcome this problem..

Internet-facing SharePoint sites required deploying the report server outside the firewall.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Phil — Mon, 07 Jan 2008 06:36:52 GMT

Hi there,

I am implementing SSRS in Sharepoint integration mode and we are having problems with basic authentication.

When the MOSS web application and the Report Server application is in Windows Integrated authentication Everything works fine.

But when we switch the MOSS web application into basic authentication and RS stays the same with windows integrated authentication the reports in sharepoint throw 401 unauthorized errors.

Anyone have any fix on this????

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Hikmer — Fri, 18 Jan 2008 18:23:04 GMT

I tired and tried and tried to use this feature and found the best solution is just install SSRS on your front end MOSS server. Make everythign so much easier...couldn't tell you the amount of frustration I had trying to set it up on my SQL server.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Eric — Wed, 13 Feb 2008 11:30:32 GMT

In reference to those folks finding in the installation log of the RS addin for Sharepoint.

Hit this one two. It's saying that you are not among the site collection administrators for the central admin site. Log into to the central admin site under application mgmt. You should see under site collections a link to view the Collection administrators. There is at least one account that has been granted this right. You can either login and perfom the installation using that account, or add the account you want to do the install with it.

Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

S.N.Surendrababu — Fri, 15 Feb 2008 12:20:42 GMT

I have a clarification. I would like to know whether the reporting services must be running in my machine to generate SSRS reports. Because I'm able to view the report in the preview mode without Reporting Services installed in my machine.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

cgarude — Wed, 05 Mar 2008 00:34:24 GMT

Forget the integration, it's too error prone, I don't need more issues in my environment. I'd rather just show a link to my reporting services home page...

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Dave — Tue, 11 Mar 2008 03:55:32 GMT

getting the following error:

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized.

Report server can browse sharepoint fine, but sharepoint can see report server? any ideas?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

ASearls — Wed, 19 Mar 2008 18:51:16 GMT

You can make a report on SharePoint lists without integrated mode.

http://www.codeproject.com/KB/reporting-services/ReportFromSharePoint.aspx

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

JN — Mon, 24 Mar 2008 21:48:28 GMT

We have a 2 server configuration with Report Server on the SQL Server and Reporting Services Plug-in on the Application server. All configuration of these servers uses the same Administrative Domain account.

We were able to browse to the report server using Localhost and display our directory structure.

We received a 401 Unauthorized access from our application server.

In attempting to troubleshoot the problem, we allowed Anonymous access to the report server

(even though we don't want this ultimately) and have demonstrated that the Application server

can indeed see and connect with the report server.

The only issue in configuring the Report Server is in

Central Administration/Application Management/Reporting Services

At the Set Server Defaults item we get the following error:

An unexpected error occurred while connecting to the report server.

Verify that the report server is available and configured for SharePoint integrated mode. -->

Server was unable to process request. --->

The request failed with HTTP status 401: Unauthorized.

Any assistance would be appreciated.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Ymerej — Wed, 02 Apr 2008 17:05:39 GMT

We have installed the hotfix kb 939942 (http://support.microsoft.com/kb/939942/) in order to fix the famous bug 50001392 (Object Moved) which appears when we try to access to a report (from SharePoint that implements form-based-authentification).

But the error always persists !!!

Any idea someone ?

Thanks in advance

SharePoint 2007 - Integrazione con SQL Server 2005 SP2 Reporting Services

Di niente, di meno, sul mondo dell'informatica.... — Thu, 03 Apr 2008 17:46:06 GMT

SharePoint 2007 - Integrazione con SQL Server 2005 SP2 Reporting Services

Why can't find Report Center Site Template

Adon — Thu, 10 Apr 2008 13:59:14 GMT

Hi, I am trying to design a report.So,i am looking for a reportcenter site.But,when i go to enterprise tab,i didn't find that template.

I Install the everything correctly, include SP2,

VSS3.0, add-in etc.

Why?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Mike — Mon, 21 Apr 2008 17:21:16 GMT

We are in integrated mode. In an e-mail subscription to a report, under Delivery Options, when we check "Include a link to the report", the link in that appears in the resulting e-mail points to the wrong place and is invalid. How do we fix this?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Tom Bizannes — Tue, 13 May 2008 10:45:37 GMT

Has anyone had any luck with integrating sharepoint and rss on a windows 2008 server?

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Sangeeta — Thu, 22 May 2008 13:06:28 GMT

Hi,

We are constantly getting the following error when trying to install SharePointRS Add-In:

User: <User Name>

Installing Report Server feature.

Calling copyappbincontents command.

Unexpected end of file while parsing PI has occurred. Line 296, position 17.

Install error: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\bin\stsadm.exe return error code: -1

Uninstalling Report Server feature.

Report Server feature was uninstalled.

Stopping W3SVC service.

Removing Report Server web application files...

Any help is very much appreciated.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Tim — Thu, 22 May 2008 15:07:33 GMT

Just hit the dreaded "User Cannot be Found" on installing. This is due to deleted users within the SharePoint content database UserInfo table that are no longer members of the domain. This is a known SharePoint bug although I'm unaware of a fix but why should this stop Reporting Services?

This is such a good product when it works but it has to be the hardest product to get working that I have encountered in the last 20 years.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

gavin — Mon, 26 May 2008 12:18:22 GMT

I Can used Windows authentication borwse report

bug don't used from authentication?

2.Whether can display list data of sharepoint site use report

thx

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Mauricio Leyzaola — Fri, 30 May 2008 09:19:24 GMT

Thanks for the information. I will try to setup with my brand new MOSS in a testing enviroment.

It is nice to see that finally Microsoft is moving into the BI arena and especially good for us that sell their products since sometimes customers require a cheaper choice instead of the common Cognos, Microstrategy, Hipyreon, etc.

Cheers!

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Gdot — Tue, 03 Jun 2008 19:31:45 GMT

Good write up, I am going to try to implement this on an internet facing sharepoint install see If i can figure out the firewall thing.

http://www.wiinjamod.com

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Andrew — Wed, 04 Jun 2008 02:04:52 GMT

Hi,

I've just tried running SharepointRS_X64.msi on a 64bit Version of MOSS2007 64bit under Windows Server 2008 and it rollsback without any errors in the installer.

The error log shows this:

Windows Installer installed the product. Product Name: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies. Product Version: 9.00.3042.00. Product Language: 1033. Installation success or error status: 1603.

Any ideas?

Thanks.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Juergen — Thu, 05 Jun 2008 18:32:15 GMT

Dont forget to mention that you cant batch-deploy your reports with rs.exe anymore but seem to be forced to do it one by one from the Visual Studio. Error-prone of course.

Overall the whole SharePoint is even a more disappointing product than Vista.

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Luis Paulino — Fri, 06 Jun 2008 21:23:39 GMT

Help,

We are implementing integrated with the Sharepoint Services report.

When the reports had direct access to the services report the operation was correct.

After the integration with Sharepoint unable to give more permissions for users to report on the services report (not more moving in new and existing permissions).

Accessing the permissions of users in reports of Report Services integrated with Sharepoint?

Att;

Luis Paulino

Analyst of IT

lpaulino@gmail.com

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Parikh — Fri, 13 Jun 2008 22:34:46 GMT

I installed add-in in my sharepoint server but i can not see reporting services on my Application Management tab.

PLEASE HELP ME OUT FORM THIS ISSUE......

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Anup — Mon, 16 Jun 2008 14:04:20 GMT

Please let me know, will there be any issues if I installed SP 2 for sql 2005 on a existing MOSS 2007 environment. Will it harm the existing configuration

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

PC — Wed, 25 Jun 2008 00:38:57 GMT

We have our report service integrated with a SharePoint site using form based authentication (FBA) for our extranet application. We have no problem using Visual Studio to deploy the "AdventureWorks Sample Reports.sln", which is a "Report Server Project". Fill in the info for TargetDataSrouceFolder, TargetReportFolder, and TargetServerURL, click Deploy, then provides with the form authentication credentials in the prompted login screen, and deployed successfully.

However, we are not be able to do the same for the "AdventureWorks Model.sln", which is a "Report Model Project". No error message, just it does not take the login credential for the deploying.

Any idea? Please help.

Thanks,

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Johan — Mon, 28 Jul 2008 19:44:19 GMT

It is impossible to put a Microsoft.Reporting.WebForms.ReportViewer

into a webpart. Microsoft OWN TECHNOLOGIES don't even work with themselves!

Sharepoint Lists + SSRS + Report Parameters

Ritesh — Tue, 30 Sep 2008 07:41:14 GMT

Hi all,

I am working on a project where there is a requirement to integrate SSRS with Sharepoint 2007. Sharepoint lists are to be used as data source. I am getting the data from the list. Now what I have to do is to apply parameters on the list so that I can filter the data by selecting a value from the dropdown within SSRS only. I need to know the syntax/procedure of how to do this and I am not using any Web Part.

Any help will be appreciated.

Thanks

Ritesh

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

Nathan — Tue, 30 Sep 2008 22:45:02 GMT

Installed and configured reporting services with SP intergration.

When Granting Database Accedd I get the following error

The specified SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object.

Please assist

SQL 2005 Reporting Services add-in for MOSS 2007, PerformancePoint Server 2007 and MOSS 2007

Oscar Medina's Blog — Sun, 16 Nov 2008 06:47:25 GMT

SQL 2005 Reporting Services add-in for MOSS 2007, PerformancePoint Server 2007 and MOSS 2007

In a nutshell: Reporting Services Addin for SharePoint 2007

harbar.net — Tue, 30 Dec 2008 21:18:36 GMT

In a nutshell: Reporting Services Addin for SharePoint 2007

re: Microsoft SQL Server 2005 SP2 Reporting Services integration with WSS 3.0 and MOSS 2007

rajeevramadugu — Wed, 04 Feb 2009 21:09:40 GMT

Hello,

Is there any order of installation. I mean first we have install MOSS,SQL server 2005, then SSRS add-in fro MOSS?

Please help me regarding this.

Thanks

re: SSRS Add-in Installation problems

KVollero — Wed, 25 Mar 2009 17:27:01 GMT

I've been running into major problems with this latest attempt to install the RS Add-in (which I have done successfully on several other farms). This error, which rolls back the installation, reads:

"Unable to process .Cab file or Help Collection directory. Cannot perform action."

Setup: MOSS2007 farm with a WFE, a SQL database backend, and a third server hosting SSRS.

Anyone ever seen this error? There doesn't seem to be much on the 'net referring to it.

Thanks!

Keith