Login failed -- sql server reporting services

sql server reporting services : Login failed

CarlosR
10/6/2005 12:57:33 PM

As 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.

Mike Voissem
10/6/2005 2:00:47 PM

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

Bruce L-C [MVP]
10/6/2005 2:57:58 PM

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

[quoted text, click to view]

Mike Voissem
10/7/2005 1:54:34 PM

Thanx Bruce,
That did the trick.
Mike
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn