Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / April 2005

Tip: Looking for answers? Try searching our database.

How to get email to show in subscriptions INSTEAD of UserID

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David Bienstock - 29 Apr 2005 18:28 GMT
I've looked at most of the emails from people that are confused regarding how
to setup the email.  But in the
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp
_configserver_v1_4bzl.asp

from Microsoft, it indicates that in SendEmailToUserAlias "true=The e-mail
address of the user creating the subscription is used. This is the default
value", but it is putting the User!UserID instead.

We are using Exchange, and it takes SMTP request OK using SendUsing 2.  I
can send emails to those in the same domain, but I'm wondering how to get the
username to show their email address, instead of blanking it in the TO: box.  
I'd like it to only go to the user that made the subscription only, but the
SMTP email isn't being recognized by Exchange as a valid user name (it isn't
getting resolved).

If I typed in a username in an Exchange window it WILL resolve, but through
Subscriptions it will not.

Here are some of the important settings:

<SMTPServerPort>25</SMTPServerPort>
                        <SMTPAccountName></SMTPAccountName>
                        <SMTPConnectionTimeout>60</SMTPConnectionTimeout>
                        <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
                        <SMTPUseSSL>0</SMTPUseSSL>
                        <SendUsing>2</SendUsing>
                        <SMTPAuthenticate>2</SMTPAuthenticate>

    <SendEmailToUserAlias>false</SendEmailToUserAlias>
                        <DefaultHostName>companyname.com</DefaultHostName>
                        <PermittedHosts></PermittedHosts>
Daniel Reib \(MSFT\) - 29 Apr 2005 22:34 GMT
The subscription UI does not attempt to resolve the name with the Exchange
server.  It merely takes the current authenticated user and places it in the
TO line.  If your user names don't resolve to your exchange names then set
SendEmailToUserAlias and each user will have to type in their own address.

Signature

-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

> I've looked at most of the emails from people that are confused regarding
> how
[quoted text clipped - 32 lines]
> <DefaultHostName>companyname.com</DefaultHostName>
> <PermittedHosts></PermittedHosts>
David Bienstock - 30 Apr 2005 00:17 GMT
The BOL says "true=The e-mail address of the user creating the subscription
is used. This is the default value", but it is putting the User!UserID
instead.  

My point was I wanted it the way it said but what it said wasn't exactly
right.

"Daniel Reib (MSFT)" wrote:

> The subscription UI does not attempt to resolve the name with the Exchange
> server.  It merely takes the current authenticated user and places it in the
[quoted text clipped - 37 lines]
> > <DefaultHostName>companyname.com</DefaultHostName>
> > <PermittedHosts></PermittedHosts>
Daniel Reib \(MSFT\) - 30 Apr 2005 01:16 GMT
The user creating the service is the authenticated user, which is also the
User!UserID.  I am not sure why you think they would be different.

Signature

-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

> The BOL says "true=The e-mail address of the user creating the
> subscription
[quoted text clipped - 56 lines]
>> > <DefaultHostName>companyname.com</DefaultHostName>
>> > <PermittedHosts></PermittedHosts>
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.