Logon Error: 18456, Severity: 14, State: 8 - NEED HELP!!!!

Hi All,

I am getting the following error in the ERRORLOG File when I am
trying to connect to SQL Server 2005 Enterprise Edition 64bit with SP2 from
Reporting Services Configuration tool - Database Setup. The SQL Server
database and reporting services are on 2 different servers. Both are running
2003 SP2 64 bit.

2007-04-12 07:30:05.54 Logon Error: 18456, Severity: 14, State:
8.
2007-04-12 07:30:05.54 Logon Login failed for user 'sa'.
[CLIENT: xx.xx.xx.xx]

I know my password is valid as I can logged into SSMS using SA. I can create
the 2 reportserver databases using the Reporting Services Configuration tool
on the database server. The db server is in MIXED mode.

What am I missing?

Related articles I have followed are:

Login failed for user 'x'
http://msdn2.microsoft.com/en-us/library/ms366351.aspx

Change Server Authentication Mode
http://msdn2.microsoft.com/en-us/library/ms188670.aspx

Any help to get passed this problem would greatly be appreciated.
Thanks in advance for your time!

Hello,

Can you verify that you have "SQL Server Credentials" selected as the "Credentials Type" in the Database Setup section?

Hope this helps.

Jarret

|||Yes I have "SQL Server Credentials" selected as the "Credentials Type" in the Database Setup section.|||

Can you try to use a Windows account (with administrator privileges) instead of the SQL account?

Jarret

|||I un-install and re-installed Reporting Services on the web server. This corrected the problem.

Thanks to everyone for their replies.