Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elracorey
Starting Member
30 Posts |
 Posted - 2008-04-07 : 10:10:09
|
| Hi there,I have successfully set up a Report Subscription and it sends the report to our internal users at a given time each day.I recently added an external email address in the 'CC' & 'BCC' boxes but i got an error saying the address was invalid (i've tried with just the 'To' box as well). There's nothing special about the external address, i've tried with gmail, BT, and Yahoo.So it would seem that any address outside of my local domain is invalid.Is there some config setting that i'm overlooking? Has anyone had this problem?I'm using SQL Server 2005 Standard Edition. Any help would be great.Thanks,Lee. |
|
|
jhermiz
3564 Posts |
Posted - 2008-04-08 : 08:03:37
|
quote:
Originally posted by elracorey
Hi there,I have successfully set up a Report Subscription and it sends the report to our internal users at a given time each day.I recently added an external email address in the 'CC' & 'BCC' boxes but i got an error saying the address was invalid (i've tried with just the 'To' box as well). There's nothing special about the external address, i've tried with gmail, BT, and Yahoo.So it would seem that any address outside of my local domain is invalid.Is there some config setting that i'm overlooking? Has anyone had this problem?I'm using SQL Server 2005 Standard Edition. Any help would be great.Thanks,Lee.
Your report server serves pages on the intranet not the internet. So it doesn't know anytihng about bill.gates@ms.com nor does it know anything about joeblow@yahoo.com, it can only recognize you@yourdomain.com.Its simply a web server thats used internally. You can change this to be a true web server but you'll have to of course make your box available over the internet. Be careful with this type of implementation as you will be opening the ports to the entire world, I hope your db server is not on the same box as your rs server.JonWeblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
elracorey
Starting Member
30 Posts |
Posted - 2008-04-08 : 08:35:12
|
| I think the problem lies at the mail exchange server. I can send externally via Database Mail in SQL Server Management Console.I don't agree that Report Server was designed for the Intranet as that would make the product a waste of time in all honesty.Regards. |
|
|
|
jhermiz
3564 Posts |
Posted - 2008-04-08 : 08:41:00
|
quote:
Originally posted by elracorey
I think the problem lies at the mail exchange server. I can send externally via Database Mail in SQL Server Management Console.I don't agree that Report Server was designed for the Intranet as that would make the product a waste of time in all honesty.Regards.
As usual you did NOT read the post correctly. No where in there did I say reporting services is implemented ONLY for an intranet.By default it is setup like an Intranet...as you cannot go tohttp://www.yourcompany.com/reports and see your reports...YOU can set it up as a true web server, so please reread the post.Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
elracorey
Starting Member
30 Posts |
Posted - 2008-04-08 : 09:28:49
|
| Did you read my post?I'm only interested in sending external e-mail. I CAN send externally from my local machine via SQL Server Management using the company SMTP server. I'm using the same SMTP server for Reporting Services. The Reporting Services doesn't know what is valid and what isn't. That's the responsibility of DNS.If you want to reply with something more useful than your last post then fine, otherwise please don't bother as we'd end up abusing the forum.Cheers. |
|
|
|
jhermiz
3564 Posts |
Posted - 2008-04-08 : 09:33:34
|
quote:
Originally posted by elracorey
Did you read my post?I'm only interested in sending external e-mail. I CAN send externally from my local machine via SQL Server Management using the company SMTP server. I'm using the same SMTP server for Reporting Services. The Reporting Services doesn't know what is valid and what isn't. That's the responsibility of DNS.If you want to reply with something more useful than your last post then fine, otherwise please don't bother as we'd end up abusing the forum.Cheers.
My point was you put words in my mouth, I NEVER stated you cannot make it a true web server, of course you can..ever hear of port 80?But you misread it and quickly made a post without fully understanding my post.I'm done with this post and any other post you create sorry.Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
|
|
|
|
|
|
|
|
Email Subscription Can't Use External Domain