ssrs 2005 email | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

ssrs 2005 email

Hi,
I have configured the reporting services configuration in sql server 2005.
The sender address and the smtp server are configured corretly
I get this error when a report is to be emailed.
Failure sending mail: The transport failed to connect to the server.
Thanks
It seems the RS server configuration is not correct or unable to connect to the appropriate mail server, make sure that the unattended execution account is setup and is a user that has access to the mail server.
http://msdn2.microsoft.com/en-us/library/ms155851.aspx fyi.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
This is now done but still get the same error.
Thanks
On that mail server ensure the account used to start SQLAgent has the privilege, say the ADMIN privileges. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Not sure if this makes a difference, but the user can ping the mail server.
Have you referred to the BOL link above? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Yes, referred to the link.
What privileges should the user have on the mail server.
It is not possible to have admin rights due to security reasons.
Is readonly ok or should the user have writes to?
Thanks
To process mails I believe atleast power user is required, otherwise based upon the security policies on the server you might use this account without a local login facility on the server. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
What do you mean by "power user" ?
Not sure which operating system you are using here.
The Power Users group is a built-in local group that primarily provides backward compatibility for running non-certified (or "legacy") programs. However, members of the Power Users group can also change COM object registrations, change file associations, change Start menu shortcuts, and install drivers for hardware devices. For additional information about the default rights and permissions that are granted to members of the Power Users group, visit the following Microsoft Web sites. Privileges http://technet2.microsoft.com/windowsserver/en/library/fa01a57a-a0ef-4cb9-af9a-f30182a25bf71033.mspx http://technet2.microsoft.com/windowsserver/en/library/fa01a57a-a0ef-4cb9-af9a-f30182a25bf71033.mspx) Logon rights http://technet2.microsoft.com/windowsserver/en/library/244d92f3-7466-47ec-aee0-9723fc75c7961033.mspx http://technet2.microsoft.com/windowsserver/en/library/244d92f3-7466-47ec-aee0-9723fc75c7961033.mspx)
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>