Report Viewable by everyone on network

I have a report that I want everyone who has credentials on the network to be able to view.

We use Active Directory, (I am not an AD administrator), so I *assume* there is an active directory security group that everyone belongs to. If so, then making this report avaiable to everyone should be as simple as granting the *everyone* security group "browse" rights on the folder containg the report.
Is there another way to set such a low level of security in Reporting Services?

Thanks in advance

Doug

www.cooltimbers.com

"Art for your soul!"

You should be able to use the "Everyone" SG. I don't know of any other easy way to do this.sql

Report subscription only works 80% of the time.

Hi,

I have setup report subcription with stored credential using a valid domain account and "Use as Window Credentials..." checked. Everything tested fine and works properly when the report is viewed in a web application. The problem is this report renders fine in the browser 80% of the time and occasionally it gives me Logon failure error:

An error has occurred during report processing (rsProcessingAborted)

Cannot impersonate user for data source 'Pinnacle'. (rsErrorImpersonatingUser)

Logon failed. (rsLoginFailed)

Logon failed: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

Since the report is working 80% of the time and the user domain account hasn't changed. I am confused why I am getting bad user account error. Please help!

Thanks.

-SouBee

This sounds like a network connectivity issue - if the security authority is not available when we try to login the data source credential user, you'll see behavior like this. At the time the subscription fails, are you able to connect to the data source as the same credentialed user?

-Lukasz

Report subscription only works 80% of the time.

Hi,

I have setup report subcription with stored credential using a valid domain account and "Use as Window Credentials..." checked. Everything tested fine and works properly when the report is viewed in a web application. The problem is this report renders fine in the browser 80% of the time and occasionally it gives me Logon failure error:

An error has occurred during report processing (rsProcessingAborted)

Cannot impersonate user for data source 'Pinnacle'. (rsErrorImpersonatingUser)

Logon failed. (rsLoginFailed)

Logon failed: unknown user name or bad password. (Exception from HRESULT: 0x8007052E)

Since the report is working 80% of the time and the user domain account hasn't changed. I am confused why I am getting bad user account error. Please help!

Thanks.

-SouBee

This sounds like a network connectivity issue - if the security authority is not available when we try to login the data source credential user, you'll see behavior like this. At the time the subscription fails, are you able to connect to the data source as the same credentialed user?

-Lukasz

Report Server Stored Credentials

I am getting the standard "Subscriptions cannot be created because the credentials used to run the report are not stored -".I tried to store them in the Stored Data Source in the Visual Studio Project and then deployed. I cannot find in any documentation a reference where to go to STORE CREDENTIALS for a Report Server subscription. I would really appreciate any help on this. I did look at the existing threads, but they don't specifically address where to create the credentials. Thanks for any help you can provide.

Hello Gary,

Using Report Manager, drill down to your report. Click the properties tab, then select 'data sources' on the left side of the page. Make sure the 'A custom data source' is the radio button selected, then click the radio button for 'Credentials stored securely in the report server'. Type in your credentials to run the report and if it's a domain account, then check the box for 'Use as Windows credentials when connecting to the data source'. Click Apply at the bottom and you should be able to create a subscription.

Hope this helps.

Jarret

|||Where is this in the documentation? I searched Books on Line and MSDN and got NADA. What a brilliant person you are. Maybe smarter than the richest man in the world (BG), how bout that. Thanks and thanks again.|||

Many thanks for your kind words Gary.

In BOL, just search for 'stored credentials', it also has a way to set the stored credentials via a RS connection in Management Studio.

Jarret

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 - windows credentials userspecific?

is there any way to store the windows credentials user specific (for each user his one credentials) ?

- for an SSAS Report where the cube uses dimension security and the user get only some elementes of a specific dimension.
- we want to have a subscription in pdf format for a weekly e-mail to the user....

currently i have one report with an report specific connection.
And all the users have created a linked report to this report in their homefolder.
Is there any way to store the report specific connection on the linked report in the users homefolder ? - at the moment there is no datasource should - it seams this is only available in the mail report (link reference)

does anyone know an othere comfortable solution?

HANNES

Regarding reports from SSAS data sources:

In RS 2005, you can use expression-based connection strings. Through the expression you can access for instance the current user id exposed through the ReportObjectModel (which btw will be the surrogate user in case of an unattended subscription execution):
Connection string: ="data source=..." & "EffectiveUserName=" & User!UserId

More information about expression-based connection strings: http://msdn2.microsoft.com/en-us/library/ms156450.aspx (go to the "Data Source Expressions" section).

-- Robert