reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.

reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction informtion is available.
-

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.sql

Report Viewer through SOAP webservices

Hi everyone,
I want to use report viewer throught SOAP webservices. How to do this?
I dont want to use the URL access. I want to use reportviewer control and
the report to be access through the webservice.
Advance thanks for help.
regards,
J.SingaraveluSetup Instructions for ReportViewer
Before you can run and examine the code for the ReportViewer sample ASP.NET
server control, several components and tools must be installed.
After you follow the instructions for installation and configuration of the
items listed in the prerequisites section, you can view the sample by using
Visual Studio .NET.
Important Sample applications should not be connected to or used with
your production SQL Server database or your report server without the
permission of the system administrator.
Prerequisites
In addition to being familiar with Visual Studio .NET and either C# or
Visual Basic, to use ReportViewer you must install or verify the
installation of the following items on your development system:
a.. Microsoft Visual Studio .NET 2003.
b.. Microsoft .NET Framework version v1.1.4322.
c.. The Reporting Services samples. You can choose to install the samples
during Reporting Services setup. To install the samples, select
Documentation and Samples on the component feature tree during setup. For
more information, see Selecting Components of Reporting Services to Install.
d.. A report server that you have permission to access on your network, if
you plan to use the sample server control to view reports on a Web Forms
page.
Note ReportViewer may be converted to compile and run in previous
versions of Visual Studio .NET. However, it is designed specifically to be
compatible with the version mentioned in this section.
Install Location
After the prerequisite components and tools are installed, you can begin
using ReportViewer. By default, the ReportViewer server control is installed
to C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Applications\ReportViewer. To begin using the sample, open
the ReportViewer sample application solution file, ReportViewer.sln, using
Visual Studio .NET. For more information, see Using the ReportViewer Server
Control.
extracted from reporting services books online
"singaravelu" <singaravelu@.discussions.microsoft.com> wrote in message
news:CB4ACB94-FA43-4016-81D1-2C7349B22FA9@.microsoft.com...
> Hi everyone,
> I want to use report viewer throught SOAP webservices. How to do
> this?
> I dont want to use the URL access. I want to use reportviewer control and
> the report to be access through the webservice.
>
> Advance thanks for help.
> regards,
> J.Singaravelu
>
begin 666 important.gif
M1TE&.#EA# `+`(#_`,P``,# P"'Y! $```$`+ `````,``L`0 (7C(\9`&H,
3X8F43>E>2]CRZFF1$V9E4 ``.P``
`
end
begin 666 note.gif
M1TE&.#EA# `+`(#_`(2&`,# P"'Y! $```$`+ `````,``L`0 (:C(\(H'S[
68%R0&ED;M7,'[%S2YW#1)VJ;4P``.P``
`
end

Report Viewer Error after Deployment

I have created a report on my local machine and deployed it on a server. As I am the administrator of the server, I can access the reports with servername\Reports. The report has got three data sets. Out of these three one is a Stored procedure and other two data sets have sql queries. The user selects the 'Business year' and 'sales type' from list box. This report works perfect from my local machine as well as from teh server when I am running it

I have some other users who wish to access these reports. I did the following steps:

Created a new role and assigned it at the Data Source Folder and Reports Folder

I also made the user a Database user on the server.

After doing these steps, the user can access the Reports site by servername\Reports.

The user then can go into the Reports folder. But when the user tries to run the report, he gets an error with:

An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for data set 'BusinessYear'. (rsErrorExecutingCommand)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Can anyone help me with this? Is htere something to do with setting up of the datasource?

I have tried to search, but could not find relevant info.

Any help/Pointers will be really appreciated.

regards

Joshker

Hi Joshker,

Can you provide us with the RS Log Files so we can look into the error in more detail......

Potenitally you could have a "datatype" issue wrong with the Business Year....

Report Viewer access permissions problem

Hi,
I have a Report Viewer intergrated in my application and deployed on server. When I try to access that from internet it says Network/Service account has not enough permission to run that task. Any idea how to give rights to SQL Server 2005 Service account to run reports from internet.

Thanks

add the NT AUTHORITY\NETWORK SERVICE as USER to your db|||

Hi,

Thanks for the reply

I already added NT AUTHORITY\NETWORK SERVICE as user for DB but when loading report from web page that its says that NT AUTHORITY\NETWORK SERVICE dont have enough permission to run that task for report viewer. Please any idea

Thanks

sql

Report Usage Tracking

In SRS 2000/2005, is there a way to get usage tracking for report access? Is
there a way to track how often a particular report is accessed and with what
parameters?
This would be extremely useful.The Execution Logs can give you that kind of info.
http://msdn2.microsoft.com/en-us/library/aa964131.aspx
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"BillG_SD" <BillGSD@.discussions.microsoft.com> wrote in message
news:754DD946-A84C-4633-A1F4-1494491C85A6@.microsoft.com...
> In SRS 2000/2005, is there a way to get usage tracking for report access?
> Is
> there a way to track how often a particular report is accessed and with
> what
> parameters?
> This would be extremely useful.
>

Report Service 2005 with VS.NET 2003 ASP.NET application

I am very new to reporting services.

Can anyone kindly summarise the ways you can access report services report in a VS.NET 2003 web project? I can only find crystal report components

Thanks in advance

Hi,

the easiest way is to create a proxy class for RS. You don′t have to do this on your own, simply create a web reference to Reporting Services. In the background the WSDL from the ReportServer is consumed and a proxy class generated. Now, you can use every SOAP API that Report Server offers for rendering the reports, more on that can be found in the tutorials of the BOL.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks very much for your reply.

What I need to do is build up a website which can show Reporting Service Reports, ideally I can add the Report Viewer and Report Explorer onto the web page. I have to use web services to realise this (in VS.NET 2003), don't I?

Thanks in advance if anyone can reply.

Report Server Windows Service

Hi everyone,

I am not able to access my report server. Here is the message i get when i try to configure it.

System.InvalidOperationException: Cannot start service ReportServer on computer 'Machine-9JP5R91'. > System.ComponentModel.Win32Exception: The service did not start due to a logon failure
End of inner exception stack trace
at System.ServiceProcess.ServiceController.Start(String[] args)
at System.ServiceProcess.ServiceController.Start()
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

It says log on failure but i dont know how to change the settings...

Please let me know....

Thanks!!

SqlNew

The Report Server Service requires an account to run. You can set this account through the MMC Service control panel applet or by using the RS Configuration tool. The account password may have expired and all you will need to do is set a new password.

One issue to understand is that if you change the user account that starts the service, the encrypted content of your report server will not work. You will need to restore a backup of the encrypted content if you have it or delete the content. If you delete the content, all stored user and password information will be removed. You should back up your database if you need to change the account.

Report Server Windows Service

Why does this windows sevice fails in attempt to turn on?
but when i access the rs manager all is fine. when i query the reportservice.asmx?wsdl all is fine.
i access via a seperate app all is fine.
i'm puzzled.Look at the ReportingServicesServer[datetime].log in Reporting
Services\LogFiles directory.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"mg" <mg@.discussions.microsoft.com> wrote in message
news:C9E5654B-75BB-4B99-9132-E05B64D4A7CF@.microsoft.com...
> Why does this windows sevice fails in attempt to turn on?
> but when i access the rs manager all is fine. when i query the
reportservice.asmx?wsdl all is fine.
> i access via a seperate app all is fine.
> i'm puzzled.
>

Report server spawning multiple w3wp.exe threads

We have Win2003 SP1, SQL 2000 SP4, RS 2000 SP2 installed on our dev
machine and it works ok - having problems using anonamous access under
IIS but that is another issue.....
On our production server ( win2003 SP1, SQL 2000 SP4 ) we installed RS
2000 and SP2, accepting all the default installation options accept
SSL, and we have the following problems....
When we try to access http:\\servername\reports it takes a good few
minutes to load the web page, after asking for a domain user account,
and then the whole server runs like a dog.
Just getting to the first web page creates 12-15 copies of w3wp.exe,
each of which swallow between 20 and 130 MB of memory, and ramps up the
CPU usage.
I you try to upload a report, or access an existing report it spawns
off another 8-10 copies of w3wp.exe and eats more memory, and seriously
slows the server down.
The only way to release the resources it has useems to be to restart
IIS.
I "think" that this may be due to some hardening or lock down of
production server, but I am struggling on what to do next.
The RS logs do not seem to show any problems, but the Win App log shows
"ID 124 ReportServer Service has been activated" 5-6 times for every
action you take against reporting services.
I have been through the "checking reporting services is installed"
guides and it all seems ok, so there is something key I am missing here
!!!
Anyone else had similar problems and found the solution, or could at
least point me in the right direction to progress this issue !An update...
Thanks our freinds at the hosting company, it turns out this was all
due to .Net framework and IIS
We have apps running under 1.1 and 2.0 frameworks, and RS was set to
use default app pool on the IIS config.
Created a new app pool, and let both RS directories use that instead -
bingo !
Lots of w3wp.exe still created, but not hosing the box, and the number
goes up and down as usage changes.
Advice has been to create a new app pool just for reporting services,
as it is a hungry beast !

Report Server Roles - Gaining access to

Does anyone out there know how to programatically determine the Role(s) of
the Logged In User running a report?
Thanks,
Bill MellOn Sep 19, 12:44 pm, "Bill Mell" <Bi...@.netforcement.com> wrote:
> Does anyone out there know how to programatically determine the Role(s) of
> the Logged In User running a report?
> Thanks,
> Bill Mell
You can pass back a hidden parameter from the report set to this
expression:
=User!UserID.ToString
Then in the stored procedure/query that is sourcing the report, run
the following query to obtain the associated roles.
SELECT R.ROLENAME
FROM REPORTSERVER.DBO.USERS AS U
INNER JOIN REPORTSERVER.DBO.POLICYUSERROLE AS P ON U.USERID = P.USERID
INNER JOIN REPORTSERVER.DBO.ROLES AS R ON P.ROLEID = R.ROLEID
WHERE U.USERNAME = @.UserName;
In this query, the @.UserName gets its value from the hidden parameter.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I am actually trying to get the information before the report actually runs.
I have a custom web page to gather parameters for the report.
It seems, that at the time the web page is called, the User!UserID is not
loaded (or if it is, it is empty)
It is in the web page that I need this info.
Do you know of a way to get that info in this scenario?
Thanks,
Bill Mell
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1190254670.163591.20770@.y42g2000hsy.googlegroups.com...
> On Sep 19, 12:44 pm, "Bill Mell" <Bi...@.netforcement.com> wrote:
> > Does anyone out there know how to programatically determine the Role(s)
of
> > the Logged In User running a report?
> >
> > Thanks,
> > Bill Mell
>
> You can pass back a hidden parameter from the report set to this
> expression:
> =User!UserID.ToString
> Then in the stored procedure/query that is sourcing the report, run
> the following query to obtain the associated roles.
> SELECT R.ROLENAME
> FROM REPORTSERVER.DBO.USERS AS U
> INNER JOIN REPORTSERVER.DBO.POLICYUSERROLE AS P ON U.USERID = P.USERID
> INNER JOIN REPORTSERVER.DBO.ROLES AS R ON P.ROLEID = R.ROLEID
> WHERE U.USERNAME = @.UserName;
> In this query, the @.UserName gets its value from the hidden parameter.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||We have created many User Aware Reports which pass the user id back to
the query which selects the data required.
It would seem the report should have this built in so no sensitive
data is called where as if you rely on the web page to pass this
parameter, there might be a security loop-hole.
You can pass other parameters from the web page which basically pass
these on to the parameters in the report.
If you run the report by itself and select the parameters you will see
them in the url.
The login/userid should be called there but rather as part of the
report itself as enrique has noted.
Regards,
Tom Bizannes
Microsoft Sql Server Specialist
http://www.macroview.com.au
Sydney, Australia

report server problem

I have installed SQL 2005 reporting services and I configured it using
Reporting Services Configuration. Now I tried to access to report manager
using http://servername/Reports with login I used to start reporting
services. It doesn't work and keep prompting me for login and password. But
no use and I am sure this login is correct and password correct and it
started the reportings services successfully. Can anyone please help how to
solve this problem. Thanks.On Oct 24, 9:06 pm, "Andrew Backer" <a...@.b.com> wrote:
> I have installed SQL 2005 reporting services and I configured it using
> Reporting Services Configuration. Now I tried to access to report manager
> usinghttp://servername/Reportswith login I used to start reporting
> services. It doesn't work and keep prompting me for login and password. But
> no use and I am sure this login is correct and password correct and it
> started the reportings services successfully. Can anyone please help how to
> solve this problem. Thanks.
If you are using a browser other than Internet Explorer, this is the
default behavior. Otherwise, you will want to make sure that you do
not have the either the Reports or ReportServer virtual directory set
to anonymous access (via: right-click My Computer >> select Manage >>
select Services and Applications >> Internet Information Services >>
Web Sites >> Default Web Site >> right-click Reports/ReportServer >>
select Properties >> select the Directory Security tab >> select the
Edit... button). also, make sure that the login you are using has
Browser rights/privileges in the Report Manager. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
In fact, I am using IE. When I use IE in the server, it asked
me to login and always fails me. When I use IE in the client PC, it don't
ask me for login and just gives me "HTTP status 400: Bad reqeust" directly.
Can you please tell me what user login being used in client PC and what in
server? Please help. Thanks.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1193279009.940293.80780@.v23g2000prn.googlegroups.com...
> On Oct 24, 9:06 pm, "Andrew Backer" <a...@.b.com> wrote:
>> I have installed SQL 2005 reporting services and I configured it using
>> Reporting Services Configuration. Now I tried to access to report manager
>> usinghttp://servername/Reportswith login I used to start reporting
>> services. It doesn't work and keep prompting me for login and password.
>> But
>> no use and I am sure this login is correct and password correct and it
>> started the reportings services successfully. Can anyone please help how
>> to
>> solve this problem. Thanks.
>
> If you are using a browser other than Internet Explorer, this is the
> default behavior. Otherwise, you will want to make sure that you do
> not have the either the Reports or ReportServer virtual directory set
> to anonymous access (via: right-click My Computer >> select Manage >>
> select Services and Applications >> Internet Information Services >>
> Web Sites >> Default Web Site >> right-click Reports/ReportServer >>
> select Properties >> select the Directory Security tab >> select the
> Edit... button). also, make sure that the login you are using has
> Browser rights/privileges in the Report Manager. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Oct 24, 9:52 pm, "Andrew Backer" <a...@.b.com> wrote:
> Enrique,
> In fact, I am using IE. When I use IE in the server, it asked
> me to login and always fails me. When I use IE in the client PC, it don't
> ask me for login and just gives me "HTTP status 400: Bad reqeust" directly.
> Can you please tell me what user login being used in client PC and what in
> server? Please help. Thanks.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1193279009.940293.80780@.v23g2000prn.googlegroups.com...
> > On Oct 24, 9:06 pm, "Andrew Backer" <a...@.b.com> wrote:
> >> I have installed SQL 2005 reporting services and I configured it using
> >> Reporting Services Configuration. Now I tried to access to report manager
> >> usinghttp://servername/Reportswithlogin I used to start reporting
> >> services. It doesn't work and keep prompting me for login and password.
> >> But
> >> no use and I am sure this login is correct and password correct and it
> >> started the reportings services successfully. Can anyone please help how
> >> to
> >> solve this problem. Thanks.
> > If you are using a browser other than Internet Explorer, this is the
> > default behavior. Otherwise, you will want to make sure that you do
> > not have the either the Reports or ReportServer virtual directory set
> > to anonymous access (via: right-click My Computer >> select Manage >>
> > select Services and Applications >> Internet Information Services >>
> > Web Sites >> Default Web Site >> right-click Reports/ReportServer >>
> > select Properties >> select the Directory Security tab >> select the
> > Edit... button). also, make sure that the login you are using has
> > Browser rights/privileges in the Report Manager. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Generally speaking, it normally uses the service acct that the
Reporting Services is running under (right-click My Computer >> Manage
>> Services and Applications >> Services >> SQL Server Reporting
Services (MSSQLSERVER) >> right-click the service >> select Properties
>> Logon tab >> look below: Logon as: This account). Also, if you have
the virtual directories security set to Anonymous (via using my
previous posting's directions), you will want to check Properties. It
will say: Anonymous access >> User Account IUSR_... Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

report server cannot decrypt the symmetric problem keeps coming ba

Hi,
I keeps getting the error "The report server cannot decrypt the symmetric
key used to access sensitive or encrypted data in a report server database.
You must either restore a backup key or delete all encrypted content and then
restart the service." every two or three days.
I don't think that anyone changed the login account at all.
Can some one help me?
--
hello, please helpYou can check your log files in the report server installation directory
for possible reasons why. Also make sure no one is changing the
ReportServer service account. You might want to use a local account you
control for this service.
--
| Thread-Topic: report server cannot decrypt the symmetric problem keeps
coming ba
| thread-index: AcWiSxZC2SWaGh1CS8ay9dfZKXQrdA==| X-WBNR-Posting-Host: 194.66.200.1
| From: "=?Utf-8?B?amVycnkueHVkZGQ=?="
<jerryxuddd@.discussions.microsoft.com>
| Subject: report server cannot decrypt the symmetric problem keeps coming
ba
| Date: Tue, 16 Aug 2005 03:13:02 -0700
| Lines: 13
| Message-ID: <CE511873-E8ED-40A8-B61F-D37C8C6D5697@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:50445
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
|
| I keeps getting the error "The report server cannot decrypt the
symmetric
| key used to access sensitive or encrypted data in a report server
database.
| You must either restore a backup key or delete all encrypted content and
then
| restart the service." every two or three days.
|
| I don't think that anyone changed the login account at all.
|
| Can some one help me?
|
| --
| hello, please help
||||I found this site about an issue of running VS 2005 Beta 1 or SQL Server 2005
Beta 2.
http://blogs.msdn.com/sqlexpress/archive/2004/07/07/175820.aspx
Instructions are simple enough, but when I tried reactivate the service I
kept getting another error:
Either the WMI provider or the path to the local config file must be specified
Looking for some help from MS on this one. When I Googled this error, no
answers on it, just some others with similar questions.
"jerry.xuddd" wrote:
> Hi,
> I keeps getting the error "The report server cannot decrypt the symmetric
> key used to access sensitive or encrypted data in a report server database.
> You must either restore a backup key or delete all encrypted content and then
> restart the service." every two or three days.
> I don't think that anyone changed the login account at all.
> Can some one help me?
> --
> hello, please help

Report server asking for credentials again and again (3 times)

I am trying to access reports using custom web application. This application will run under user who have permission to view the reports. When multiple users are accessing reports, if we try to open any report from web application, after some time (around 7-8 mins.) report server is popping up credentials window and if we provide credentials, it is again giving credentials pop up after 5 mins. and after retrying 3 times like this, reports throws error saying 'You are not authorized to view page'. Is there any time out period specified for reports?

As per my investigation, report server default timeout is '30' minutes. I have not changed any values in Report server config files(rsreportserver.config). Nowhere I found that after 5 mins. the credentials pop up should opened?

Any help in this regard, greatly appreciated.

This doesn't sound like a timeout related issue but a security problem. The credentials window will pop up when the server tells the browser that it doesn't have authorization, and the browser gives you three changes to enter the proper credentials. I'm not sure why this would work when the application starts and then start failing after a period of time. If you go directly to the report on the reportserver, do you have the same problem?

|||

For queries which takes less time, reports are running fine. But for long running queries, after 5 mins. around, it is prompting for credentials. This prompting will continue for 2-3 times and atlast page throws message 'You are not authorized to view this page'.

I checked in IIS application pool properties, under which reporting services runs. I found 'TimeSetting Period' under Health tab as 5 mins. Is this the one caused to prompt for credentials for every 5 mins?

Configuration: Sql 2005 Reporting Services, IIS 6.0, Windows 2003

|||

We could able to find the reason why this is happening. We have 2 web servers for Reporting and these 2 boxes runs under Load balancer with BIG-IP. There is timeout value set at TCP Profiler in VIP. Now this has been changed and every thing is running fine.

Report Server access via WebClient / HttpWebRequest

Hi,
This is a follow-up question I have to a previous post about accessing the
Reporting Services server without exposing a URL to the user that can be
tampered with.
I am using WebClient / HttpWebRequest to screen scrape a server-side
initiated request to the Reporting Service and writing the output into an
ASPX page. This works to a certain extent.
Unfortunately, when the ASPX page initiates the call, all relative URLs are
not correctly processed. For example, the usual address of the report server
might be http://brensydsql/ReportServer however, using a WebClient /
HttpWebRequest will use the hostname of the machine it's on, so relative URLs
will be relative to the local hostname instead of the report server's
hostname.
ie /images/blah.jpg would resolve as http://hostname/images/blah.jpg instead
of http://brensydsql/images/blah.jpg
Adding a <base href='http://brensydsql'> doesn't work either because Sql
Reporting services resources are only accessible during the request
processing and cannot be directly linked after the request has finished. The
Reporting Server needs to be fooled into thinking the root server is
brensydsql when the request is first initiated.
For some reason, after the report has been processed, the fully qualified
url to the image / whatever resource is no longer valid - seems like it is
only valid for the duration of the request?
I've tried to set the BaseAddress property of the WebClient object but this
has no effect.I have been looking at the same problem. I can't believe Microsoft
decided to pass the parameters unencrypted. Surely they must have
realised developers would need to have hidden and secured params.
Anyway, I digress.
Try using regular expressions to alter all of the links in the report.
The basics of this is here:
http://www.junto.co.uk/Diary/2005/10/6363e490-89a1-4f22-b811-d8d82c98acc9.aspx
Hope this helped.
Philip York wrote:
> Hi,
> This is a follow-up question I have to a previous post about accessing the
> Reporting Services server without exposing a URL to the user that can be
> tampered with.
> I am using WebClient / HttpWebRequest to screen scrape a server-side
> initiated request to the Reporting Service and writing the output into an
> ASPX page. This works to a certain extent.
> Unfortunately, when the ASPX page initiates the call, all relative URLs are
> not correctly processed. For example, the usual address of the report server
> might be http://brensydsql/ReportServer however, using a WebClient /
> HttpWebRequest will use the hostname of the machine it's on, so relative URLs
> will be relative to the local hostname instead of the report server's
> hostname.
> ie /images/blah.jpg would resolve as http://hostname/images/blah.jpg instead
> of http://brensydsql/images/blah.jpg
> Adding a <base href='http://brensydsql'> doesn't work either because Sql
> Reporting services resources are only accessible during the request
> processing and cannot be directly linked after the request has finished. The
> Reporting Server needs to be fooled into thinking the root server is
> brensydsql when the request is first initiated.
> For some reason, after the report has been processed, the fully qualified
> url to the image / whatever resource is no longer valid - seems like it is
> only valid for the duration of the request?
> I've tried to set the BaseAddress property of the WebClient object but this
> has no effect.

Report Server - Access Error

Any help appreciated...
Installed Reporting Services on Win2003 machine with a SQL2000 db.
Reporting Services was installed with an IIS without default website, running
IIS5.0 Isolation mode.
When navigating to http://<hostheader>/reports I get the folllowing error...
The report server is not responding. Verify that the report server is
running and can be accessed from this computer.
When navigating to http://<hostheader>/ReportServer, the following error
occurs...
The report server is not responding. Verify that the report server is
running and can be accessed from this computer.
I have ensure the account running reports is included in the group running
the webservices. Also made the change to utilise <ReportServerURL> to the
http://<hostheader>/ReportServer.
Any assistance appreciated...
JamesHi, James
You either need to have the default website in IIS in order to use
Reporting Services, or you must specify a different website in which
the Reports and ReportService virtual directories will be created.
To use a different website than the Default IIS site, you will need to
change the configuration files for the report server app, service, and
report manager app. Please see the following article for more
information on how to setup RS for a non-Default website:
RS 2005 BOL => http://msdn2.microsoft.com/en-us/library/ms155921.aspx
couldn't find the equivalent BOL article for RS2000 in the MSDN, so
here is a link to an article on the web that will suffice:
http://www.awprofessional.com/articles/article.asp?p=357694&seqNum=3&rl=1
Have fun!
Regards,
Thiago Silva
JamesC wrote:
> Any help appreciated...
> Installed Reporting Services on Win2003 machine with a SQL2000 db.
> Reporting Services was installed with an IIS without default website, running
> IIS5.0 Isolation mode.
> When navigating to http://<hostheader>/reports I get the folllowing error...
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer.
>
> When navigating to http://<hostheader>/ReportServer, the following error
> occurs...
>
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer.
>
> I have ensure the account running reports is included in the group running
> the webservices. Also made the change to utilise <ReportServerURL> to the
> http://<hostheader>/ReportServer.
> Any assistance appreciated...
> James|||All resolved, needed to ensure that the web server was not running in IIS5.0
isolation mode.
Thanks.
"tafs7" wrote:
> Hi, James
> You either need to have the default website in IIS in order to use
> Reporting Services, or you must specify a different website in which
> the Reports and ReportService virtual directories will be created.
> To use a different website than the Default IIS site, you will need to
> change the configuration files for the report server app, service, and
> report manager app. Please see the following article for more
> information on how to setup RS for a non-Default website:
> RS 2005 BOL => http://msdn2.microsoft.com/en-us/library/ms155921.aspx
> couldn't find the equivalent BOL article for RS2000 in the MSDN, so
> here is a link to an article on the web that will suffice:
> http://www.awprofessional.com/articles/article.asp?p=357694&seqNum=3&rl=1
> Have fun!
> Regards,
> Thiago Silva
> JamesC wrote:
> > Any help appreciated...
> >
> > Installed Reporting Services on Win2003 machine with a SQL2000 db.
> > Reporting Services was installed with an IIS without default website, running
> > IIS5.0 Isolation mode.
> >
> > When navigating to http://<hostheader>/reports I get the folllowing error...
> >
> > The report server is not responding. Verify that the report server is
> > running and can be accessed from this computer.
> >
> >
> > When navigating to http://<hostheader>/ReportServer, the following error
> > occurs...
> >
> >
> > The report server is not responding. Verify that the report server is
> > running and can be accessed from this computer.
> >
> >
> > I have ensure the account running reports is included in the group running
> > the webservices. Also made the change to utilise <ReportServerURL> to the
> > http://<hostheader>/ReportServer.
> >
> > Any assistance appreciated...
> >
> > James
>

REPORT SERVER

Hi - I am trying to access the report server installed by SQL2005 for the first time and keep receiving this error message: using url -http://localhost/reports

Failed to map the path '/Reports/App_GlobalResources/

Have you gone through the configuration yet?

Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > Reporting Services Configuration

I hope this helps

Report runs in the frontend but not in designer!!??

The report gives me a blank screen when I refresh the data under the design mode, but when I run it with my access tool, the data comes out fine.
The report is running on a complex query in an access database.Open the report and do verify database

Report Refresh through code in reporting services

I use some editor to edit the data in the backend. I view the report in sharepoint portal using url access of the report in reporting services with the toolbar disabled by rc:toolbar=false. Now, as and when I edit the data of the report using an editor, I want the report to be updated with the new data. This I want to do it by placing a button or some link in the Sharepoint, clicking which should update the report with the new data. Is there any parameter like rc:refresh which will refresh the report?
--
Message posted via http://www.sqlmonster.comYes, rs:ClearSession=true will refresh the report.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Varma via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9fcebb16b4f6418fb26b01a1a4841f5d@.SQLMonster.com...
>I use some editor to edit the data in the backend. I view the report in
>sharepoint portal using url access of the report in reporting services with
>the toolbar disabled by rc:toolbar=false. Now, as and when I edit the data
>of the report using an editor, I want the report to be updated with the new
>data. This I want to do it by placing a button or some link in the
>Sharepoint, clicking which should update the report with the new data. Is
>there any parameter like rc:refresh which will refresh the report?
> --
> Message posted via http://www.sqlmonster.com