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 |
|
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- |
 |
|
|
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? |
 |
|
|
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- |
 |
|
|
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. |
 |
|
|
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- |
 |
|
|
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. |
 |
|
|
cwtriguns2002
Constraint Violating Yak Guru
272 Posts |
Posted - 2007-03-14 : 22:57:14
|
| what you mean by "but not out side the company" ? |
 |
|
|
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. |
 |
|
|
|
|
|