Error: 18456, Severity: 14, State: 16.

I'm getting login errors when trying to run reports both locally on the
report server and remotely on a client machine.
This is the error I get:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'RequestDataSource'.
(rsErrorOpeningConnection)
Cannot open database "<database name>" requested by the login. The login
failed. Login failed for user "<domain\username>".
Here's what I see in my SQL log:
2007-02-26 14:44:49.88 Logon Error: 18456, Severity: 14, State: 16.
2007-02-26 14:44:49.88 Logon Login failed for user <domain\username>.
[CLIENT: <local machine>]
The user is a domain admin and has full rights to all the databases on the
database server.
Any insight would be apprecaited. Thanks!On Feb 26, 1:57 pm, Henry <H...@.discussions.microsoft.com> wrote:
> I'm getting login errors when trying to run reports both locally on the
> report server and remotely on a client machine.
> This is the error I get:
> An error has occurred during report processing. (rsProcessingAborted)
> Cannot create a connection to data source 'RequestDataSource'.
> (rsErrorOpeningConnection)
> Cannot open database "<database name>" requested by the login. The login
> failed. Login failed for user "<domain\username>".
> Here's what I see in my SQL log:
> 2007-02-26 14:44:49.88 Logon Error: 18456, Severity: 14, State: 16.
> 2007-02-26 14:44:49.88 Logon Login failed for user <domain\username>.
> [CLIENT: <local machine>]
> The user is a domain admin and has full rights to all the databases on the
> database server.
> Any insight would be apprecaited. Thanks!
Sometimes this occurs when the datasource has not yet been set up -or-
has not been set up correctly.
Regards,
Enrique Martinez
Sr. SQL Server Developer