Prev: Reporting Services 2005
Next: SSRS 2008 and Custom URL
From: ChelleATL via SQLMonster.com on 8 Dec 2009 01:06
I am trying to deploy a report to the Reporting Services Server but keep
running up against this error:

An error occurred during client rendering.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'dataSource1'.
(rsErrorOpeningConnection)
Could not obtain information about Windows NT group/user 'DOMAIN\useradmin',
error code 0x5.

Here's my situation: Everything is being ran using DOMAIN\useradmin and the
report is using a remote database.

Reporting Services and SQL Server are both ran under DOMAIN\useradmin. DOMAIN\
useradmin is a windows AD login and is part of the server machine
Administrators group.

My test report is using a data source model that in turn is using a data
source that is connection to a database on a different SQL Server. The data
source is using “Credentials stored securely in the report server” with the
options “Use as Windows credentials when connecting to the data source” and
“Impersonate the authenticated user after a connection has been made to the
data source.”

I am using the credentials of DOMAIN\useradmin that is the db owner of the
remote database.

DOMAIN\useradmin is assigned the roles, System Administrator, System User and
Browser, Content Manager, My Reports, Publisher, Report Builder.

So if everything is being run under an über AD account, why I am getting this
Could not obtain information about Windows NT group/user 'DOMAIN\useradmin'
error?

Under normal circumstances , an AD login with Publisher permissions will
developing reports using a datasource model created by DOMAIN\useradmin but
using one of the remote database's users which is mapped from yet another AD
login.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200912/1

 | 
Pages: 1
Prev: Reporting Services 2005
Next: SSRS 2008 and Custom URL