sql server reporting services: SSRS 2005 - Logon Failure: Unknown user name or password -- sql server reporting services

SSRS 2005 - Logon Failure: Unknown user name or password

wardellcastles
8/3/2006 7:35:19 PM

sql server reporting services: Whenever I run a report in SSRS 2005, I receive the message:

Logon failed (rsLogonFailed)
Logon failure: unknown user name or bad password. (Exception from
HRESULT: 0x8007052E)

Can someone give me a hint as to what the report was logging into when
it failed?

Was it the data source logging into SQL Server (because those
credentials seem correct).

Is there another login other than to SQL Server that is happening?

There are no unusual messages in the Windows Event log indicating there
was a problem.

Thanks!

RE: SSRS 2005 - Logon Failure: Unknown user name or password

Ravi
8/4/2006 9:03:02 AM

Your DomainName\UserLogin should be able to authenticate to the report
server. Ask the report server admin to add you as "ReportBrowser" in the
report server.
--
Thanks & Rate the Postings.
-Ravi-

[quoted text, click to view]

RE: SSRS 2005 - Logon Failure: Unknown user name or password

Needy Info
8/9/2006 4:32:29 PM

I also have the same problem except that the reports on the report server
were working and now I am recieving the same login error. I am set up as
admin on the sql server and on the report server. It does not seem to matter
if I use integrated security or set up the datasource using sa, I get the
same login error. Is there something in the surface area config that needs to
change? I swear I didn't change anything and now the reports can't log on to
the report server. Confused.

[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 in the sql server reporting services group.