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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Report Services(subscription)

Author  Topic 

marlowkoch
Starting Member

18 Posts

Posted - 2007-03-14 : 17:12:14
When I setup a report with a subscription and after it runs it says that email address is invalid. We can send it internally by using the subscription but externally. We use a remote email host provider(smtp). Please help I have tried everything.. We are using sql 2005 server with windows pro.

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-03-14 : 21:57:20
activate your email address. I think that is the issue.

-Ron-
Go to Top of Page

marlowkoch
Starting Member

18 Posts

Posted - 2007-03-14 : 22:17:36
I am saying i can email to my email address and any one with the same @domain.com but no one else?
Go to Top of Page

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-03-14 : 22:33:49
You should also put the email in the Report Configuration Manager under EMAIL SETTINGS.

-Ron-
Go to Top of Page

marlowkoch
Starting Member

18 Posts

Posted - 2007-03-14 : 22:38:06
I have setup the report configuration manager under email settings. We use an outside email hosting provider. I can get sql to send the report to my email address but not my personal email or anyone else outside my company.
Go to Top of Page

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-03-14 : 22:47:51
Not yet encounter that kind of problem... As far as i know, only the administrator can set the subscription of the report to the user. You must log as an admin then set the subscription to the users.

-Ron-
Go to Top of Page

marlowkoch
Starting Member

18 Posts

Posted - 2007-03-14 : 22:54:16
Here is goes: I am trying to set a subscription in report manager to jeff@xxx.com but when it runs it comes back invaild email address. If I set up the subscription to send it to my email or anyone else in the company it works but not out side the company.
Go to Top of Page

cwtriguns2002
Constraint Violating Yak Guru

272 Posts

Posted - 2007-03-14 : 22:57:14
what you mean by "but not out side the company" ?
Go to Top of Page

marlowkoch
Starting Member

18 Posts

Posted - 2007-03-15 : 06:58:13
I mean if i setup a subscription to email company A(my company) to cfo,ceo,it manger etc. it works fine.Then if I try to set up the subscription to company B, C,D, ETc the subscription runs but says invalid email address.
Go to Top of Page
   

- Advertisement -