Microsoft SharePoint Team Blog

PingBack from http://www.universityupdate.com/Technology/Microsoft_SQL_Server/4277495.aspx

Thank you for this excellent guide. A must ! :)

If I am following the guide correctly nothing is installed on the database server. You do however create another server for reporting services (web server in affect) and install SQL reporting services only on it.

I have followed the instructions in my test lab and have only two server DC and SQL on server one, RS, WFE and AS on second. It works and we are promoting to our client in production by next week.

Once again, Kudos on the document.

I have followed the steps in the document but have ran into a snag that I have been unable to resolve.

The first time I ever view a report either directly or in the webpart, it works, but after that I always get the following error in the log file:

"w3wp!session!8!08/07/2007-13:43:45:: i INFO: LoadSnapshot: Item with session: 03nkqujqvtb1m5uqwafte145, reportPath: http://mea-ad-v2/Shared Documents/Report/Sample3.rdl, userName: SHAREPOINT\system not found in the database

w3wp!library!8!08/07/2007-13:43:45:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution '03nkqujqvtb1m5uqwafte145' cannot be found, ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution '03nkqujqvtb1m5uqwafte145' cannot be found

w3wp!webserver!8!08/07/2007-13:43:45:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution '03nkqujqvtb1m5uqwafte145' cannot be found"

Any ideas to what I've done wrong?

Thanks,

John

John,

This may not be your issue, but I had a similar situation when I installed Sharepoint while logged in as a "temp" user. I then deleted that user because I started using domain accounts. The "author" of the site was still listed as the original and it was marked deleted.

I started to receive very strange "user not found" errors. Using information from http://blogs.msdn.com/sharepoint/archive/2006/05/02/content-deployment.aspx I made the unsupported modifications to the database and it all works.

It sounds like you may have a similar issue.

Eric VanRoy

Sicherheit Forefront Security for SharePoint SP1 Available Now Codeplex Tool: Anonyme Kommentare für

for those of us who can't afford Office 2007 - could you convert the file to a PDF or pre-2007 Word doc file format?

thanks!

Hi,

server1 - sharepoint 2007

server2 - sql server 2005

server3 - reporting server 2005

My reporting server is in integration mode. I've uploaded a .rdl(report file) in my personal site with the upload button.When I click on the .rdl file I get an error which goes something like this: Sharepoint error occurred while connecting to the reportserver, login failed for user.

What account is trying to connect, is there any log files I can check to see this?

Is there a guide to setup all accounts used?

I use domain accounts.

Many thanks

Hi,

I have setup SSRS in integration mode.

I'm running RS on a machine separate from my SharePoint site. I've setup WSS3.0 administration to run in Windows Authentication.

I encountered two problems:

1) On the WSS server machine, when i click on the report stored in a document library in WSS, the report is able to run and display properly. Hoewever, when i try it on a separate machine I 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."

The RS Web service is running on a domain user account which is also the WSS farm service account.

I've tried setting up IIS on both WSS and RS machines to use NTLM without avail.

2) While deploying the reports using Report Designer from the RS machine to the Sharepoint site (on separate machine) i got the following error:

===================================

A connection could not be made to the report server http://kkbepmapp01/. (Microsoft Report Designer)

===================================

Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. (System.Web.Services)

This is despite the fact that I was able to do the deployment from the WSS server machine.

Any help will be very much appreciated.

KH

I want Screen shots for configuring the sqlreporting services.Please provide me the same.

I tried to create a meeting workspace from within Outlook and got a message saying "The operation could not be completed because of an error found on the server. Reason"

Does anyone know what the problem might be ?

Thanks,

It has been asked before, but I would like it to be more explicit.  So you MUST install WSS/Sharepoint on the Reporting/Database server to make this work?  I have wasted hours on this...what a very difficult process.  Just found this white paper, but have run out of energy on this project.

when deploying a report tot the report server, I get this Error:

Cannot open database "WSS_Content" requested by the login. The login failed.

Login failed for user 'ETGCAPITAL\SSRSWebAccount'.

do I need to add SSRSwebaccount as user to ContentDatabase?  if so, what permissions?

We have similar issue:

We are running SSRS2005 in Sharepoint Integrated Mode.

RS is on a separate server from the rest of our WFE in sharepoint2007.

It seems all configuration items are good in RS configuration (I originally implemented in Native mode to be sure, then

Configured new databases for integrated mode). Additionally I ran WSS 3.0 and configured the RS server to be part of farm.

From sharepoint CA, I have configured the 3 settings that show up under Application Management > Reporting Services

--under "Manage Integration Settings" we are using "Windows Authentication" mode

--All seems fine in the configuration since we are able to access and manipulate the "Set Server Defaults" page and can set SSRS server settings

But when we go to deploy a report we get the error below…I believe it must be an issue with the double hop from sharepoint to the RS server.

Things to note:

*we are using a single domain account for both the web service and windows service on RS

         -necessary to use domain account in our setup according to microsoft

         -using 1 service account for both services also OK according to microsft

*we ran adsUTIL.vbs to enable NTLM authentication in IIS on the report server

*sqlserver2005 sp2 implemented on all servers w/ sql components including the client deploying the report

*URLs for DC library, Report Library, and Report Center all verified thru browser and use fully qual'd URLs.

*Content types have been added to SP library

I've follwed this document to the letter and even uninstalled everything and started again a couple of times to ensure I've not missed anything.  I've also read around on a number of other articles, kb articles, etc from inside and outside Microsoft, but can't get the final step ("Set server defaults" under the "Reporting Services" heading in MOSS Central Admin) to run.  I get the error, "The permissions granted to user [domain\alias] are insufficient for performing this operation".  I've tried it with the Farm Admin account and a number of others, and have tried with the account as a computer Local Admin and a SQL sys admin as well as a MOSS farm admin, and ensured that computer Local Admins have full control on the ReportingService2006.asmx.  All to no avail!!

Assistance desperately required!

I have downloaded the Addin but cannot see the Reportin Services section in the Sharepoint Central Administration Site. Do I have to change the mode of the reporting Services before the installation or....

I am having the same issue as Peter. I have tried setspn for both IIS_WPG and WSS_WPG to no avail. I can access the Report Service via web browser, but from the Central Admin site - clicking on "set server defaults" causes an error to be thrown as noted by Peter.

Please Help.

http://blogs.msdn.com/bimusings/archive/2005/08/23/455263.aspx

It'd be nice to know the pre-requisites for what the SQL server hosting the DB should require.

***  The fix was the named pipes had to be turned on.

For the search engines:

Setting connection info for reporting server

System.Runtime.InteropServices.COMException (0x800706B3)

at

System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32

errorCode, IntPtr errorInfo)

at System.Management.ManagementObject.Get()

at

ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetDatabaseConnection(String

server, String database, ConfigurationCredentialsType credsType, String

userName, String password)

Found out why the SQL Reporting Integration add-in for SharePoint will not show the required links in Central Administration for my environment.

I have installed the TEST farm als "Stand-alone". That setup version does not support connections to other WFE servers. And SQL Reporting Integration needs to connect to a second WFE.

Might this be the reason for other users aswell?