SQL Server Performance

ssrs 2005 email

Discussion in 'SQL Server 2005 Reporting Services' started by fmardani, Jun 12, 2007.

  1. fmardani New Member

    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
  2. satya Moderator

    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.
  3. fmardani New Member

    This is now done but still get the same error.
    Thanks
  4. satya Moderator

    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.
  5. fmardani New Member

    Not sure if this makes a difference, but the user can ping the mail server.
  6. satya Moderator

    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.
  7. fmardani New Member

    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
  8. satya Moderator

    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.
  9. fmardani New Member

    What do you mean by "power user" ?
  10. satya Moderator

    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.

Share This Page