Exchange Server or NS filtering email addresses?

My Notification Services (NS 2.0 SP1) application works fine, except one big problem:

I am using a built-in SMTP provider, and notifications are delivered ONLY to those subscribers who have email addresses within our company's domain.

That is, all subscribers with addresses like someone@.ourcompany.com always get their notifications, whereas any other email addresses do not work. I tried my gmail.com, aim.com, and optonline.net email addresses, and none of them ever received a notification, not even once.

As soon as I change a particular subscriber's email address from whatever to anybody@.ourcompany.com (whether I do it via SMI or directly in the NS subscribers table, does not matter), it works again.

So, something is filtering emails based on the recipients' addresses.
I do not know for sure whether it's done by NS or by the SMTP server, but the situation is the same regardless of whether I use my local machine's SMTP server or our company's MS Exchange Server 5.5 (I specify it only in the InstanceConfiguration.xml file).

Could someone point me in the right direction as to where to look for what's causing this kind of filtering, please?

Thank you very much!Answering my own question...
Here's what the Exchange Server 5.5 returns in an exception message:
The server rejected one or more recipient addresses. The server response was: 550 Relaying is prohibited.
It's a spam-filtering -related feature.

Exchange data

Hi,
Is there a wahy to get AD user info in a SP?
I need a list of AD users with name, login name and email.
Thanks.
George.Hi.
I think there is not a function or something like that in SQL2005 that
retrieve all user from you Active Domain Controler (I'm not quiet sure about
that).
You can only get information abour your principals:
SELECT * FROM sys.server_principals
SELECT suser_name()
For advanced solution you must use CLR to get information about Active
Domain users.
Mladen.
"Microsoft" <g2@.bla.cl> wrote in message
news:OzjHniWOHHA.3668@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Is there a wahy to get AD user info in a SP?
> I need a list of AD users with name, login name and email.
> Thanks.
> George.
>|||Microsoft wrote:
> Hi,
> Is there a wahy to get AD user info in a SP?
> I need a list of AD users with name, login name and email.
Getting the name and login name is possible. But since email is a
multivalued field, it can't be done out of the box.
http://articles.techrepublic.com.com/5100-6345_11-5259887.html|||Hi.
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',
'ADSDSOObject', 'adsdatasource'
SELECT *
FROM OPENQUERY (ADSI, 'SELECT givenName, sn FROM ''LDAP://
DC=DOMAIN,DC=COM''
where objectcategory=''User''')
After time of trying to do best thing in my query (and I succed), i found
this one (this is very useful):
http://www.atlantamdf.com/presentations/AtlantaMDF_111201_examples.txt
Second solution is, as I say earlier, to do some code in C# and call it from
SQL as assembly (try to modify this as you wish):
string rootQuery = LDAP://DC=DOMAINNAME, DC=COM;
DirectoryEntry root = new DirectoryEntry(rootQuery);
DirectorySearcher dirSearch = new DirectorySearcher(root);
//dirSearch.Filter = String.Format("(cn={0})",
"Administrators");
dirSearch.Filter = String.Format("(objectClass=user)");
SearchResultCollection results = dirSearch.FindAll();
ArrayList userNames = new ArrayList();
if (results != null)
{
foreach (SearchResult result in results)
{
for (int i = 0; i < result.Properties["name"].Count;
i++)
{
string user = (string)result.Properties["name"][i];
Console.WriteLine(user);
}
}
}
Console.ReadLine();
Mladen.
"Microsoft" <g2@.bla.cl> wrote in message
news:OzjHniWOHHA.3668@.TK2MSFTNGP02.phx.gbl...
> Hi,
> Is there a wahy to get AD user info in a SP?
> I need a list of AD users with name, login name and email.
> Thanks.
> George.
>

Exchange cluster

Dont know clusters, just starting to look into them. I do, however, have
needs for fault tolarance. Starting with our email server. Sounds to me
that Clustering is a bit over kill for an Exchange server or 12gig database
to be useing as a fail over system. I'm i correct in making this
assumption?
Does anyone have any recomendations, other than Neverfail, or Double Take?
Thanks much!
Irv
http://home.pacbell.net/irvingf
No, it isn't overkill.
I have a database that is 750 MB and another one that is 2.4 GB that we
installed a cluster explicitly for those two databases. We also have a 3rd
server which we log ship those databases to as well as 2 other servers that
we replicate the data to. That's a total of 5 machines, 2 Windows 2003
Advanced Server licenses, 3 Windows 2003 Server licenses, 3 SQL Server 2000
Enterprise Edition licenses, and 2 SQL Server 2000 Standard Edition
licenses. All of that for ~3.15 GB of data.
It all depends upon how highly you value the data. This particular data had
a monetary value to that particular company of about $400 million with a
downtime cost of approximately $400K per minute, so in comparison the
technology we threw at the problem was pretty cheap considering the
alternative.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Exchange 5.5 email problem

I have an Active Directory network with an Exchange 5.5 server running on a
Windows NT box.
I am hosting 3 email domains on that box. For example lets call them
mydomain1.com, mydomain2.com and mydomain3.com.
All external emails come in and work just fine except for the mydomain3.com
emails. My internal Active Dirctory domain is mydomain3.com.
Currently my Exchange server on the NT box is pointing at the internal DNS
server that forwards requests to the outside. I was thinking my problem is
that and that I might need to have the NT box with Exchange on it use our
ISP DNS servers instead.
Any ideas? I read something about Active Directory Connector, but didn't
know if I need to look at that or how the DNS settings are set up on the
Exchange server.
Thanks...if anyone wants to email me directly...feel free!!
"CJ" <chrisj@.illicom.net> wrote:

>I have an Active Directory network with an Exchange 5.5 server running on a
>Windows NT box.
>I am hosting 3 email domains on that box. For example lets call them
>mydomain1.com, mydomain2.com and mydomain3.com.
>All external emails come in and work just fine except for the mydomain3.com
>emails. My internal Active Dirctory domain is mydomain3.com.
>Currently my Exchange server on the NT box is pointing at the internal DNS
>server that forwards requests to the outside. I was thinking my problem is
>that and that I might need to have the NT box with Exchange on it use our
>ISP DNS servers instead.
>Any ideas? I read something about Active Directory Connector, but didn't
>know if I need to look at that or how the DNS settings are set up on the
>Exchange server.
>Thanks...if anyone wants to email me directly...feel free!!
>
If your Exchange server is running without ADC then it's not AD aware
(but you'd worked that out)
The Internet Mail Service should receive mail for all three domains
and route them to wherever you need.
Can you confirm that all three domains are set to "Route Inbound"? Or
alternatively two of the domains are routed to a third domain (be it
1, 2 or 3)
Then you need to make sure that you are receiving the mails for
domain3.com in the first place. Is it a registered domain? Does it
have MX records that point to a valid A record in the ISP DNS?
If domain3 isn't valid then you're not going to get mail into it.
Check by doing an nslookup against all three domains and make sure
that they point to the same A record and that the A record matches the
IP address you want the mail delivered to.#
Mark Arnold MCSA MCSE+M MVP,
FAQ: http://www.swinc.com/resource/exchange.htm
Blog: http://www.msexchange.me.uk
|||Figured it out.. the problem ended up being i simply needed my Exchange
server to have the DNS settings for my ISP, not my internal DNS servers
"Mark Arnold [MVP]" <mark@.mvps.org> wrote in message
news:9gaif051c15fpakgru8be75a35dgaefh9p@.4ax.com... [vbcol=seagreen]
> "CJ" <chrisj@.illicom.net> wrote:
a[vbcol=seagreen]
mydomain3.com[vbcol=seagreen]
DNS[vbcol=seagreen]
is
> If your Exchange server is running without ADC then it's not AD aware
> (but you'd worked that out)
> The Internet Mail Service should receive mail for all three domains
> and route them to wherever you need.
> Can you confirm that all three domains are set to "Route Inbound"? Or
> alternatively two of the domains are routed to a third domain (be it
> 1, 2 or 3)
> Then you need to make sure that you are receiving the mails for
> domain3.com in the first place. Is it a registered domain? Does it
> have MX records that point to a valid A record in the ISP DNS?
> If domain3 isn't valid then you're not going to get mail into it.
> Check by doing an nslookup against all three domains and make sure
> that they point to the same A record and that the A record matches the
> IP address you want the mail delivered to.#
>
> Mark Arnold MCSA MCSE+M MVP,
> FAQ: http://www.swinc.com/resource/exchange.htm
> Blog: http://www.msexchange.me.uk

Excel page setup / Email subscriptions

Hi,
I'm a newbie when it comes to Reporting Services, so please bear with me.
I am having 2 issues:
1) I am trying to get an exported Excel report to automatically select the
correct paper size. I have a report that is fairly wide, so I set the
report page up to 14" x 8.5" (Legal) and set the margins to .25" on each
side. Based on the limited info online, I was hoping this would translate
into Excel's Page Setup, but I was wrong. When I open the resulting Excel
workbook, the pages are set up as Landscape (which I hoped would happen),
but they are still Letter (11" x 8.5") sized. Is there any way to force
Excel to include Legal in the page setup?
2) I set up several Windows users with the role "Browsers" in Reporting
Services. I want them to be able to subscribe to a report via email. When
the user creates a new subscription, the "To" field is disabled, and is
populated only with their Windows username (ie, "jmarx"). The email
generated by the system fails (I think) due to not being able to resolve the
username into an email address. The server being used to send the emails is
Exchange 2000, and everything is integrated with Active Directory. If I go
to the Reporting Services site (I have all permissions on the site), I can
set up a new subscription with no problems, as the To, Cc, and Bcc fields
are all enabled and I can type in the full email address(es) as needed. The
email(s) get sent with no issues that way. Any ideas on how to map the
usernames to email addresses, thus allowing users with only "Browser" access
to subscribe to reports?
Thanks in advance for any help you can offer!
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]Jake,
I have the same problem. When a user (with "browser" privledges)
subscribes to a report, only their "username" show up in the TO: box
for email and it is greyed out so they can't change it. Hopefully,
someone from Microsoft is monitoring this board and will provide a
solution...
Pete|||Hi Pete,
hradecky wrote:
> I have the same problem. When a user (with "browser" privledges)
> subscribes to a report, only their "username" show up in the TO: box
> for email and it is greyed out so they can't change it. Hopefully,
> someone from Microsoft is monitoring this board and will provide a
> solution...
I finally figured that one out from searching google groups, but I'm not
entirely happy with the answer. You can enable this field by changing the
following in your RSReportServer.config file:
<SendEmailToUserAlias>True</SendEmailToUserAlias>
to
<SendEmailToUserAlias>False</SendEmailToUserAlias>
I believe you can set <DefaultHostName> to the hostname (ie, microsoft.com),
and that will be appended to all users' aliases. So if all your users are
in the same domain for email purposes, you could leave
<SendEmailToUserAlias> at True and enter your hostname in <DefaultHostName>.
Unfortunately for me, I have users in 2 domains, so this won't work. I
would really like to know how to map user aliases to email addresses, but I
haven't had the time to figure it out yet (or if it can even be done).
Changing <SendEmailToUserAlias> to False gives me an interim solution
anyway.
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]|||Did you ever find your answer to your printing question? We're having
the same sort of problem.
"Jake Marx" <msnews@.longhead.com> wrote in message news:<urY4CcemEHA.1908@.TK2MSFTNGP14.phx.gbl>...
> Hi Pete,
> hradecky wrote:
> > I have the same problem. When a user (with "browser" privledges)
> > subscribes to a report, only their "username" show up in the TO: box
> > for email and it is greyed out so they can't change it. Hopefully,
> > someone from Microsoft is monitoring this board and will provide a
> > solution...
> I finally figured that one out from searching google groups, but I'm not
> entirely happy with the answer. You can enable this field by changing the
> following in your RSReportServer.config file:
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> to
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> I believe you can set <DefaultHostName> to the hostname (ie, microsoft.com),
> and that will be appended to all users' aliases. So if all your users are
> in the same domain for email purposes, you could leave
> <SendEmailToUserAlias> at True and enter your hostname in <DefaultHostName>.
> Unfortunately for me, I have users in 2 domains, so this won't work. I
> would really like to know how to map user aliases to email addresses, but I
> haven't had the time to figure it out yet (or if it can even be done).
> Changing <SendEmailToUserAlias> to False gives me an interim solution
> anyway.|||Did you ever find your answer to your printing question? We're having
the same sort of problem.
"Jake Marx" <msnews@.longhead.com> wrote in message news:<urY4CcemEHA.1908@.TK2MSFTNGP14.phx.gbl>...
> Hi Pete,
> hradecky wrote:
> > I have the same problem. When a user (with "browser" privledges)
> > subscribes to a report, only their "username" show up in the TO: box
> > for email and it is greyed out so they can't change it. Hopefully,
> > someone from Microsoft is monitoring this board and will provide a
> > solution...
> I finally figured that one out from searching google groups, but I'm not
> entirely happy with the answer. You can enable this field by changing the
> following in your RSReportServer.config file:
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> to
> <SendEmailToUserAlias>False</SendEmailToUserAlias>
> I believe you can set <DefaultHostName> to the hostname (ie, microsoft.com),
> and that will be appended to all users' aliases. So if all your users are
> in the same domain for email purposes, you could leave
> <SendEmailToUserAlias> at True and enter your hostname in <DefaultHostName>.
> Unfortunately for me, I have users in 2 domains, so this won't work. I
> would really like to know how to map user aliases to email addresses, but I
> haven't had the time to figure it out yet (or if it can even be done).
> Changing <SendEmailToUserAlias> to False gives me an interim solution
> anyway.