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.

I have applied SP2 for...

OK, I've found a MSDN article titled Moving the Report Server Databases to Another Computer which described, for SQL Server 2005, how to move SSRS from one server to another....

I checked all 18...