Home / server / Questions / 125833
In Process
Edoode
Asked: 2010-03-25 07:31:35 +0800 CST

Configure SQL server reportign service to send email

  • 772

I'm configuring SQL server 2005 reporting server to send emails outside the domain. I have followed the steps outlined at MS but have a question:

How can I supply a domain user to connect to the Exchange server in the same domain? I've tried 

<SMTPAccountName>DOMAIN\User</SMTPAccountName>

in the rsreportserver.config.

sql-server-2005 email ssrs

2 Answers

  1. maybe you can find the answer here:
    http://www.mssqltips.com/tip.asp?tip=1453

    • 1

  2. I'm not familar with how SQL Server 2005 interacts with SMTP, but for other apps they expect the mail account to be in smtp (email) format rather than LANMAN format.

    If you've got a working AD tree this should be [email protected], failing that try using user@domain.

    • 0