Email validation in ReportManager

Setting up a timed subscription in Reporting Services works just fine on our
server when the email address is joe@.domain.com. The Report server is set
up pointing to our SMTP server and works like a champ. Reports go out and
our chosen format (PDF) is generated and all is good.
When we enter a non-standard Email in the TO field (a RightFax email
address), the timed event runs and gives us a status of "The e-mail address
of one or more recipients is not valid."
Our question is: How can we turn off email validation within reporting
services so it will connect to the SMTP server (Exchange)?
ThanksHi,
This issue is usually caused by the fact that Email Relay is not turned on.
You may see something like the following in the Reporting Services Logfiles:
ReportingServicesService!emailextension!b14!10/14/2004-08:20:06:: Error
sending mail, CDO error -2147220977, will not resend
ReportingServicesService!emailextension!b14!10/14/2004-08:20:06:: Error
sending email. System.Runtime.InteropServices.COMException (0x8004020F):
The server
rejected one or more recipient addresses. The server response was: 550
5.7.1 Unable to relay for xxx@.xxx.xxx
at ReportingServicesCDOInterop.MessageClass.Send()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Noti
fication notification)
ReportingServicesService!notification!b14!10/14/2004-08:20:06::
Notification 02710147-2025-4ed0-9c58-b37f12b64a79 completed. Success:
False, Status: The e-mail
address of one or more recipients is not valid., DeliveryExtension: Report
Server
Emai
If this is the case, you need to turn on email relay on the SMTP server.
If the error in the Reporting Services log file is not the same, please let
me know the exact error message so that we could get a better idea of the
issue.
The log file is usually located at:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Logfiles
Thanks & Regards,
Justin Shen
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.
This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
If you are outside the United States, please visit our International
Support page:
http://support.microsoft.com/default.aspx?scid=%2finternational.aspx.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| Reply-To: "isicoder" <isicoder@.newsgroups.nospam>
| From: "isicoder" <isicoder@.newsgroups.nospam>
| Subject: Email validation in ReportManager
| Date: Fri, 27 Jan 2006 12:35:16 -0800
| Lines: 16
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <OPD1vE4IGHA.424@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 67.96.36.252
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67707
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Setting up a timed subscription in Reporting Services works just fine on
our
| server when the email address is joe@.domain.com. The Report server is
set
| up pointing to our SMTP server and works like a champ. Reports go out
and
| our chosen format (PDF) is generated and all is good.
|
| When we enter a non-standard Email in the TO field (a RightFax email
| address), the timed event runs and gives us a status of "The e-mail
address
| of one or more recipients is not valid."
|
| Our question is: How can we turn off email validation within reporting
| services so it will connect to the SMTP server (Exchange)?
|
| Thanks
|
|
|
|

Email Validation in reporting Sevices...

Hi.
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?
ThanksIm using Reporting Server to send that...please any hints'sql

Email Validation in reporting Sevices...

Hi.
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?Have you tried emailing the file to an external email account of yours?
Something like hotmail, yahoo, gmail...
Open the file at home and see if it opens correctly.
By the way, there is a newsgroup for reporting services -
microsoft.public.sqlserver.reportingsvsc. If you do not get a solution here
you might want to post to the other group (with move information).
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...
> Hi.
> IM trying to send a scheduled excel report to some emails but when he
> runs it tells me that the emails are not valid..
> Any help? i can put any email?
>|||Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution h=
ere
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Who is the "he" that you are referring to in your post?
What is the error?
Where do you see the error?
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution
> here
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "Pp" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Well...sorryy..i didnt explained well..
Im working with the report server and im trying to make a
"subscription" that triggers an action. The action is send every
fridays a report in excel format of some database fields to some email
accounts.
When the subscription is triggered an error is showed in the report
server saying that the emails specified are not valid.
Keith Kratochvil escreveu:
> Who is the "he" that you are referring to in your post?
> What is the error?
> Where do you see the error?
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
> Yes...i tried to send to may personal account and other hotmail
> email...and he tells me the same error..
> Thx Keith..you were the only one that tried to help me..i ve been in
> the newsgroup of reporting server already..and they didnt helped me..
> Keith Kratochvil escreveu:

Email ID Validation in SQL Query

Hi,
Can someone help me with a query to validate if a value stored in the
emailaddress field in a table is a valid email id or no. Please mail me
ASAP. Thanks in advance.
Regards
DineshDinesh
I'm not sure iunderstood your question.
Since you have not provided a table structure along with sample data , I
guess you can do something like that
IF EXISTS (SELECT * FROM Table WHERE email_id=@.par)
--do soemthing
ELSE
--do somethimg else
"Dinesh" <Dinesh@.discussions.microsoft.com> wrote in message
news:80CE816E-A91C-4ECE-93E4-19006167B567@.microsoft.com...
> Hi,
> Can someone help me with a query to validate if a value stored in the
> emailaddress field in a table is a valid email id or no. Please mail me
> ASAP. Thanks in advance.
> Regards
> Dinesh|||Dinesh skrev:

> Hi,
> Can someone help me with a query to validate if a value stored in the
> emailaddress field in a table is a valid email id or no. Please mail me
> ASAP. Thanks in advance.
> Regards
> Dinesh
Depends on what you actually want to validate...
Is it only that the value looks like 'somename@.someaddress', or is it
to check if there really IS such an (active?) email account, or is it
to check against a table with valid email addresses? Or something else?
/impslayer, aka Birger Johansson|||Please explain in detail, your question? Mean provide sample data situation
Thanks,
Siva
"impslayer" wrote:

> Dinesh skrev:
>
> Depends on what you actually want to validate...
> Is it only that the value looks like 'somename@.someaddress', or is it
> to check if there really IS such an (active?) email account, or is it
> to check against a table with valid email addresses? Or something else?
> /impslayer, aka Birger Johansson
>

Email adddress format validation question

Trying to find the best way to vaildate email formats when importing records to result tables etc... the first seems to run faster, but it seems too easy, like something is getting missed.

Does anyone know if using:

WHERE email LIKE '%@.%.%'

instead of using:

WHERE
( CHARINDEX(' ',LTRIM(RTRIM([email]))) = 0
AND LEFT(LTRIM([email]),1) <> '@.'
AND RIGHT(RTRIM([email]),1) <> '.'
AND CHARINDEX('.',[email],CHARINDEX('@.',[email])) - CHARINDEX('@.',[email]) > 1
AND LEN(LTRIM(RTRIM([email]))) - LEN(REPLACE(LTRIM(RTRIM([email])),'@.','')) = 1
AND CHARINDEX('.',REVERSE(LTRIM(RTRIM([email])))) >= 3
AND (CHARINDEX('.@.',[email]) = 0 AND CHARINDEX('..',[email]) = 0) )

is any better, or are they both pretty much bring back the same result sets?

Thanks for sharing your insight.Looks like T-SQL from where I am standing. Moving to SQL Server. Any mod spot something I missed please relocate.|||The latter is more thorough but restrictive. You may also get false positives (for example my email address ends .uk). You don't need to use LEFT and RIGHT - you can use LIKE (especially for the LEFT since it is then sargable) so it could be more efficient. Perhaps create more of a mask (off the top of my head)

LIKE '_%@._%.__%'
Min 1 char then @. then min 1 char then . then min 2 chars.

HTH|||most people use regex for this kind of thing, although you don't have that option in t-sql.

The regex for the RFC 822 definition of what constitutes a valid address is amusing, see link below.

http://www.regular-expressions.info/email.html|||Great insights! I didnt think about the .uk etc.... Thanks! And I've never used regex before. Thanks so much for the link! I will read up on it! Thank you both!!!!!