HOw long does it take to stop the Mail Service? It has been over 10 min's , the query is still executing. Will keep updated when the service stops.

Lowell...

Is this a firewall issue?

Does the Database Mail Service need the SQL Server Browser Service? Right now the state of browser service is stopped.

We are using Basic Authentication. I have tried 3 accounts that have rights on SMTP server. None of these accounts are locked.

ashok.faridabad1984 (9/8/2011)

---

whjat kind of authentication you are using for...

When I tried the following Query

SELECT * FROM msdb.dbo.sysmail_allitems

I get the values mentioned below for all the mails that were not delivered.

sent_account_id : NULL

sent_status : unsent

sent_date : NULL

I have tried this option too. Yet the same problem.

When I try sending a mail manually, I get the message "Mail Queued". But there is no log in the Database mail for mail being sent or for an error.

Nope!! This does not return any results for dates 01/09 to 07/09. But I do get results for dates less than 01/09.

Lowell (9/7/2011)

---

(: Hakuna Matata 🙂 (9/7/2011)

---

Tried all the 4...

Even my test mails are not getting delivered. And there is no log for that too. There is no entry in Database Mail log after 01 SEP.

The Jobs are getting...

Tried all the 4 options, Everything is working fine. Tried sending a test mail. No entry in the Database Mail logs.

Thanks a loooooooot!!!!!!!! for the valuable suggestions provided.

I did try using my dataset as shown below

=iif(RowNumber(GroupName) Mod 2, "silver", "White")

It also gave me the same result as shown in the below link:

http://www.4shared.com/photo/adC_tc2z/SS_online.html

Thaaaaaaaaaaanks a loooooooooooot!!!!!!! for the timely help :-):-):-):-):-):-)!!!!!!

The issue is currently the SSRS is configured with Windows authentication. I want to change the Windows authentication to user specified authentication. Is there any good documentation for...

OMG:w00t::w00t::w00t: !!! Thanks a TON Stewart for spending your precious time to help me out!!!!!!!! This is what I have been looking out for .. Thanks...