How to get email to show in subscriptions INSTEAD of UserID

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>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.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Bienstock" <DavidBienstock@.discussions.microsoft.com> wrote in
message news:8F5C45D3-4388-4F83-A58F-46467BB0C1B4@.microsoft.com...
> 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>|||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
> 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.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "David Bienstock" <DavidBienstock@.discussions.microsoft.com> wrote in
> message news:8F5C45D3-4388-4F83-A58F-46467BB0C1B4@.microsoft.com...
> > 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>
>
>|||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.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"David Bienstock" <DavidBienstock@.discussions.microsoft.com> wrote in
message news:17149E65-0C81-4579-9D1F-E24EF95E89AF@.microsoft.com...
> 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
>> 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.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "David Bienstock" <DavidBienstock@.discussions.microsoft.com> wrote in
>> message news:8F5C45D3-4388-4F83-A58F-46467BB0C1B4@.microsoft.com...
>> > 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>
>>

HOW TO GET DETAILS OF DB_OWNERS ON A SQL SERVER.

Hi,
This is kiran from India. I would like to ask one question regarding the
MS-SQL 2000
"db_owner" access permission user.
On one server we have 50 databases and indivual database have there own
db_owner access assigned to WINODWS 2000 DOMAIN LOCAL USERS and Local users
and Global users .
My question is how to retirve the list of users who are members of DB_OWNERS
and WINODWS 2000 DOMAIN LOCAL USERS and Local users and Global users using
SQL script or by any other means other than going to each database and check
the users in DB_OWNERS.
Please help me ....
Kiran S
Hi
sp_helplogins
"KIRAN MAHA PATRO.S" <KIRANMAHAPATROS@.discussions.microsoft.com> wrote in
message news:C9BCE7B7-BE41-4A88-87D9-F483F6929201@.microsoft.com...
> Hi,
> This is kiran from India. I would like to ask one question regarding the
> MS-SQL 2000
> "db_owner" access permission user.
> On one server we have 50 databases and indivual database have there own
> db_owner access assigned to WINODWS 2000 DOMAIN LOCAL USERS and Local
users
> and Global users .
> My question is how to retirve the list of users who are members of
DB_OWNERS
> and WINODWS 2000 DOMAIN LOCAL USERS and Local users and Global users using
> SQL script or by any other means other than going to each database and
check
> the users in DB_OWNERS.
> Please help me ....
> Kiran S
>