Bhuvnesh (2/19/2010)

---

Try this

declare @tbl table ( logdate datetime, processinfo nvarchar(20), login_text nvarchar(max))

insert into @tbl (logdate, processinfo, login_text)

exec sp_readerrorlog

select * , '[' + SUBSTRING( login_text , PATINDEX ( '%CLIENT:%',...

The account is a newly created account, but I am able to log in using that account. Since this is a new account, does that mean it needs time to...

I already checked with AD admin, what they told me is this account is no difference than other account. but I am sure there is some difference.

I finally am able to resolve this issue:

All I need to do is:

The job is type of "T-SQL", go to edit the step in that job, two options in the...

DavidZahner (2/8/2010)

---

There is a Run As setting for the job step, but that would just muddy the authentication waters here. I would recommend creating a Windows account for the SQL...

DavidZahner (2/8/2010)

---

If you are using Execute As and are accessing resources outside of the current database (all mail items in this case) you will need to set the trustworthy setting...

DavidZahner (2/8/2010)

---

Cool, at least it is logging the issue. I would guess that the job step/ proxy is not configured correctly so the job step is defaulting to the security...

I did more test: I added 'NT AUTHORITY\SYSTEM' as member of DatabaseMailUserRole, I would assume this allows NT AUTHORITY\SYSTEM' to send out email, (although this is not professional and might...

DavidZahner (2/8/2010)

---

To get some more detail, you can query msdb.dbo.sysmail_mailitems to see what the result was and to get the send_request_user to see what authentication is being used when called,...

DavidZahner (2/8/2010)

---

If it is simply sending mail which is not part of any alert, make sure that the account under which the SQL Server Agent service is running is a...

thank you

Thank you and please DO do something when you have time later on, I did lots of search, I didn't find any complete working example so far, so this got...

I do have another 2k5 version with more recent patch:

Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20 Copyright (c) 1988-2005 Microsoft Corporation...

Here is the query result:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows...

Hi Lynn,

Thank you for your reply, but I am desperately in dark here, I've attached some snapshots in the attachment, can you help me with it? all the approaches I...