Login failed

I'm having trouble getting my report to run on the reporting services
server. I can run it fine from my machine, but when I deploy it, I get a
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
I've set the datasource to use a shared datasource, with a specific username
and password(which is the username and password for the reporting services
server, going after an external sql server with permissions to the reporting
services user.
Any ideas?
Thanx,
MikeAs long as I know, if you have your reporting services into one server
and your database into another, you CANNOT use trusted connection, you
must use a SQL Server login.
I'm telling this because I have the same problem and I didnt find
anything to solve so far.|||Go to report manager and the properties for your shared datasource. You
might have to set the credentials.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mike Voissem" <voissemm@.stjosephs-marhshfield.org> wrote in message
news:u8cQEhqyFHA.2312@.TK2MSFTNGP14.phx.gbl...
> I'm having trouble getting my report to run on the reporting services
> server. I can run it fine from my machine, but when I deploy it, I get a
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> I've set the datasource to use a shared datasource, with a specific
> username
> and password(which is the username and password for the reporting services
> server, going after an external sql server with permissions to the
> reporting
> services user.
> Any ideas?
> Thanx,
> Mike
>|||Thanx Bruce,
That did the trick.
Mike
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:#gJkBBryFHA.2960@.tk2msftngp13.phx.gbl...
> Go to report manager and the properties for your shared datasource. You
> might have to set the credentials.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Mike Voissem" <voissemm@.stjosephs-marhshfield.org> wrote in message
> news:u8cQEhqyFHA.2312@.TK2MSFTNGP14.phx.gbl...
> > I'm having trouble getting my report to run on the reporting services
> > server. I can run it fine from my machine, but when I deploy it, I get
a
> > Login failed for user '(null)'. Reason: Not associated with a trusted
SQL
> > Server connection.
> > I've set the datasource to use a shared datasource, with a specific
> > username
> > and password(which is the username and password for the reporting
services
> > server, going after an external sql server with permissions to the
> > reporting
> > services user.
> > Any ideas?
> > Thanx,
> > Mike
> >
> >
>