CR Server error: database vendor code 18456

[neboat]

I am running CR Server and I am able to connect to the SQL Server via ODBC. Both servers are in the same domain. However, when I try to schedule an instance of the report on the CR Server, I get an error message on CR Server's CMS: "Unable to connect: incorrect log on parameters. Details: [Database Vendor Code: 18456]. I checked the error logs on the SQL server and found this:

2007-08-14 09:22:27.10 Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 10.1.101.167]
2007-08-14 10:36:08.76 Logon Error: 18456, Severity: 14, State: 11.

What am I doing wrong and how can I fix this problem? FYI, I am using Windows Authentication for the SQL server. I am logging as an user login I created, not as admin. Any help would be much appreciated!!!!!

Ben

 

[Turkbear]

Hi,
Be sure the account that the job server runs under has the correct permissions needed to access the database.



To Paraphrase:"The Help you get is proportional to the Help you give.."