June 19, 2009 at 3:43 am
Hi, guys!
I have a report on my Report Server. In SSMS I'm trying to make an email-subscription. Here is what I do to make it:
- I have special domain user, who has rigths to run reports and to query my Datasource. This user also has an email box on our MS Exchange Server, so I configured Database mail parameters using its name and password. The Database mail works, I got the test message from it.
- I make the subscription in SSMS, enter my e-mail and report parameters.
- The SQL Agent Job was created.
And from this moment I'm facing with some problems. When I start this job, the SQL Server reports a successful execution. But I don't receive any emails with my report. In Windows Event Viewer I see the error message:
Logon Failure:
Reason:Unknown user name or bad password
User Name:
Domain:
Logon Type:3
Logon Process:Authz
Authentication Package:Kerberos
Workstation Name:DB-IBM
Caller User Name:DB-IBM$
Caller Domain:DOMAIN
Caller Logon ID:(0x0,0x3E7)
Caller Process ID:1872
Transited Services:-
Source Network Address:-
Source Port:-
If I change a User in a Job Step Properties, I have the same error message.
If I change the owner of the job (my domain user instead of NT AUTHORITY\NETWORK SERVICE which was by default), I get an error message from SQL Server that job has failed.
Many thanks in advance.
Greg.
June 23, 2009 at 1:40 am
We had a different scenario to you but I believe the same underlying cause. If you have not set up Kerberos for your servers, it loses the security token, so you will probably find its connecting with blank credentials. If you were to open it up to anonymous it would probably work. I would get one of your AD guys to take a look. If its the same issue we wasted hours on it!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply