Hi, we configured our SQL 2008 reporting services to send emails to the user by setting the "SendEmailToUserAlias" in the config file. Our problem is now, that the server tries to send the mail to the USER-alias not to the EMAIL alias. In our company the user alias is just the name, so the server wants to send the mail to name@company.com - but the correct email adress should be "first name"."name"@company.com Is it possible to configure the server to do this the right way? Thanks Dennis

Hi Dennis_k5121, According to your description, it seems that you put user’s alias in the To field when you create E-mail subscription. Actually, you should put email address in the to field instead of alias. So this is the root cause of your scenario. When SendEmailToUserAlias is set to True, users who define individual subscriptions are automatically specified as recipients of the report. The To field is hidden. If this value is False, the To field is visible. Set this value to True if you want maximum control over report distribution. Valid values include the following: True: the e-mail address of the user creating the subscription is used. This is the default value. False: any e-mail address can be specified. Moreover, if you are using Windows Server 2003, you can use an alias instead of an e-mail address. This operation system resolves the correct e-mail address automatically. However, you must use an e-mail address if you are using Windows Vista or Windows Server 008, because neither of these operation systems performs the same type of alias resolution as windows server 2003. For more information about email delivery in SSRS, you can refer to the following article, Configuring a Report Server for E-Mail Delivery: http://msdn.microsoft.com/en-us/library/ms159155.aspx If you have any question, please feel free to ask. Thanks, Eileen

Hi, yes, we set the SendEmailToUserAlias to TRUE, so the field is hidden, thats ok so far. Our problem is, that the system don't resolves the right eMail adress - it only builds an email adress "user alias"@domain name, but that is no valid email adress... So you say Server 2003 can resolve the right email adress out of the user name and Server 2008 can not? That means there is no other way than set the "SendEmailToUserAlias" to False and type in the email adress manually?

Hi Dennis_k5121, what you are saying is right, there is no way instead of type in email address manually if you are not using server 2003. If you have concern about it, I suggest you submitting a feedback at http://connect.microsoft.com/SQLServer/Feedback and hope Microsoft can improve this feature in the next service pack or product release. Thanks, Eileen

Ok... thank you :-)