Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
webcomber
Starting Member
10 Posts |
 Posted - 2008-07-22 : 12:17:48
|
| Hello -I am trying to set up a subscription on SSRS 2005. I have send as permission on an account set up for reporting. I also confirmed SMTP authentication, and set up the account in subscriptions but received the error: Failure sending mail: The server rejected the sender address. The server response was: 530 5.7.1 Client was not authenticated.I changed IIS to Basic Authentication, and Anonymous, and now receive the error: A subscription delivery error has occurred. (rsDeliveryError) One of the extension parameters is not valid for the following reason: The account you are using does not have administrator privileges. A subscription cannot be created for (username).I am an administrator on the server and SQL server. Any help would be greatly appreciated!webcomber |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2008-07-22 : 15:33:10
|
| If you set IIS to use Anonymous, then when you browse there, you are the anonymous user, not yourself. Therefore, you do not have administrator privileges any more.Are you using Exchange or just a regular SMTP server to send out your mail? Is it configured to require authentication? I'd go back to scenario 1 and re-check that your user is actually authenticated to send from that server. If you're using Exchange, you may have to approve your report server IP for relaying through Exhange.---------------------------EmeraldCityDomains.com |
 |
|
|
webcomber
Starting Member
10 Posts |
Posted - 2008-07-23 : 14:52:47
|
| Hi AjarnMark -Thanks for the response! I was messing with IIS and had to change it back because other users were locked out of SSRS, and I could no longer see the properties tab on SSRS. It is currently set to Windows Authentication and to ASP.net Impersonation (which seems to be the setting that removes the properties tab from SSRS if I uncheck it).So yes scenario one is the original problem, for which I have yet to find a solution. The group running SMTP server have confirmed that the email account I am using is authenticated for SMTP, but they said they would not help for any client issues (e.g. SQL Server). I do not know what SQL Server uses for Subscriptions - I thought it simply relied on the SMTP Server in Reporting Services Configuration Manager, and the email address, so it would use regular SMTP Server. Our company states: The SMTPHOST service can be used by any SMTP client or application that supports the SMTP protocol. The application must also support submitting e-mail in an authenticated manner using NTLM authentication. From there I just followed SQL Server documentation for SMTP mail. Not sure what else to do! |
|
|
|
elracorey
Starting Member
30 Posts |
Posted - 2008-07-29 : 08:12:00
|
| Hi,I had the same issue. The checkboxes on the SMTP server don't do what you'd expect. I had to manually add the static IP addresses to allow the emails to go to external addresses. Didn't have any problems with internal addresses however.Also, with regards to Anonymous IIS users, have you set up a user to be stored securely in SQL Server? That works very well.Lee.Just because something doesn't do what you planned it to do doesn't mean it's useless. |
|
|
|
siddh
Starting Member
2 Posts |
Posted - 2011-04-25 : 05:06:28
|
| Hi all,How to set the SEND AS Permission on an account set up for reporting.siddharth.singh |
|
|
|
|
|
|
|
|
Subscription Error