I've just taken a look at the logs that you mentioned. The last message I see there is one from 12/6/2008 that says, "DatabaseMail process is shutting down". ...

Well, iqtedar, you put me on the right track. The university said that I had to use port 465, but I decided to use port 25 instead, and it...

I'm using the port that the university says I need to use for outward bound SMTP traffic, and they don't use port 25 (or 26). Although I could get...

I've contacted my network administrator and talked to him about it. He said that it might be possible the firewall is blocking SMTP traffic, so he's going to look...

I wrote a quick .NET app to test it from my PC, and discovered that I'm getting the same error here as well. Very odd, as I can use...

No, I haven't tried sending an email from that server using some other program. That is an interesting idea. I'll see what I can do to make that...

I forgot to mention that I'm also using basic authentication instead of Windows authentication for the SMTP authentication, since it is reaching a SMTP server that isn't a part of...

Lynn, this is a very simple follow-up question, but I've got to ask it. In the one other SQL Job I've written I've got something like:

spMySP 2009, 4

but you...

That is true, but I...

Yes, it does help, Steve. Thank you for moving this discussion to the appropriate forum (strategies). I'll subscribe to it there to get replies.

Thank you, David, for your reply. Being able to leave the SQL 2005 client tools and (in my case) developer edition of SQL 2005 on my machine, and install...

SanjayAttray (10/23/2008)

---

I had the same issue sometime back and going through some blogs, I found this and it worked for me.

Try setting the IIS security level to low and it...

That does help, Matt. Some of those column names in those Rtb* tables are identically named as those in my mysterious UnK* tables. That at least suggests to...

I also found that I have to change the OverwriteDataSources property in the SSRS project. Be default it is set to false, which meant that even though I changed...

I think I've got this taken care of.