Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / July 2008

Tip: Looking for answers? Try searching our database.

Sceduled Reports User Context

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RJM2 - 11 Jul 2008 13:39 GMT
Hi Folks,

We have a report that uses the IBM DB2 Driver.  This report works fine
on our development server, both when run manually through the web
interface and when scheduled.

When we move this report ot our production instance, it can be run
manually through the web interface, but fails when scheduled with the
following error in the log:

"Cannot create a connection to data source 'DataSource1'. --->
System.Data.Odbc.OdbcException: ERROR [IM003] Specified driver could
not be loaded due to system error  5 (IBM DB2 ODBC DRIVER)."

It sounds to me like a permissions problem, so my question is what
user context does scheduled Reporting Services reports run under on
the server?

The servers are running MS SQL version 9.00.2047.00.

Any thoughts would be appreciated.
RJM
Steve MunLeeuw - 11 Jul 2008 17:04 GMT
I'd check these items:
Since it ran in development, most likely the first item.

     Stored credentials
    The report must use stored credentials or no credentials to retrieve
data at run time. You cannot subscribe to a report that is configured to use
the impersonated or delegated credentials of the current user to connect to
an external data source. The stored credentials can be a Windows account or
a database user account. For more information, see Specifying Credential and
Connection Information for Report Data Sources

     User dependent values in a report
    For standard subscriptions only, you can create subscriptions to
reports that incorporate user account information in a filter or as text
that appears on the report. In the report, the user account name is
specified through a User!UserID expression that resolves to the current
user. When you create a subscription, the user who creates the subscription
is the considered the current user.

     No model item security
    You cannot subscribe to a Report Builder report that uses a model as a
data source if the model contains model item security settings. Only reports
that use model item security are included in this restriction.

     Parameter values
    If the report uses parameters, a parameter value must be specified with
the report itself, or in the subscription you define. If default values have
been defined in the report, you can set the parameter value to use the
default. For more information, see Setting Parameters in a Subscription.

Thanks,
Steve MunLeeuw
RJM2 - 11 Jul 2008 17:34 GMT
On Jul 11, 12:04 pm, "Steve MunLeeuw" <steve.munle...@gmail.com>
wrote:
> I'd check these items:
> Since it ran in development, most likely the first item.
[quoted text clipped - 28 lines]
> Thanks,
> Steve MunLeeuw

Steve,

Thanks for the response.  I have checked all of those items, and again
it works as a scheduled report on our development server.

I think it has more to do with the user context of the scheduler
trying to access the database driver itself.

Thanks,
Rob
Steve MunLeeuw - 11 Jul 2008 18:01 GMT
Ah, I should have paid more attention to the error message.  Looks like the
subscription account requires folder permissions that the driver is in.

http://www.experts-exchange.com/Web_Development/Miscellaneous/Q_21979676.html

Hmmm,
We want specific user credentials for personalized content, but a different
execution account for granting folder permissons.  Not sure what the best
answer is for that.

Thanks,
Steve MunLeeuw
RJM2 - 11 Jul 2008 18:18 GMT
> Ah, I should have paid more attention to the error message.  Looks like the
> subscription account requires folder permissions that the driver is in.
[quoted text clipped - 8 lines]
> Thanks,
> Steve MunLeeuw

Steve,

I'm not a member of Experts Exchange and couldn't see the answers to
the question.  Any chance you feel like summarizing?

Thanks,
Rob
Steve MunLeeuw - 11 Jul 2008 18:42 GMT
I don't have access either, but if you scroll to the bottom past the blanked
out responses they are repeated without the distortion.

Answer:

Do those groups have access to the folder the db2 driver is in?
I'd check the event logs and see if there are any security errors.

From Poster:
Yes both groups have access to the folder. And there are no security errors
logged.

Please ignore my previous comment. It turns out that the account in the
groups is an ASPNET account from the domain instead of the local ASPNET
account. Now I added the local ASPNET account to the group and everything
worked.

Thank you,
Steve MunLeeuw
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.