Showing posts with label logon. Show all posts
Showing posts with label logon. Show all posts

Wednesday, March 28, 2012

Reporting Services Scheduled Subscription Logon Error

Hi all,
For 8 months, I have had a set of Timed Subscriptions in use to generate
and email reports. In the last few days, they've failed.
The SQL Agent says success, but when you view the subscriptions in report
manager, they say Logon Failed.
There is nothing in Event viewewr, and I can say that the logon details
have not changed in the slightest! They are still valid. Exactly what
credentials is it picking from?
I'd appreciate suggestions.
Thx
PaulPaul,
Next thing you can do is to see whether the same report is running on the
preview of VS.
Amanarth
"Paul Buxton" wrote:
> Hi all,
> For 8 months, I have had a set of Timed Subscriptions in use to generate
> and email reports. In the last few days, they've failed.
> The SQL Agent says success, but when you view the subscriptions in report
> manager, they say Logon Failed.
> There is nothing in Event viewewr, and I can say that the logon details
> have not changed in the slightest! They are still valid. Exactly what
> credentials is it picking from?
> I'd appreciate suggestions.
> Thx
> Paul
>

Tuesday, March 20, 2012

Reporting Services Login Error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Logon failed. (rsLogonFailed) Get Online Help The parameter is incorrect.

I can view my report inside of visual studio 2003 no problem, but when I navigate to the http://servername/Reports/Pages/Folder.aspx and click on my report to load inside of IE I get the error. I have serached all over but not able to get a correct answer.
Any help woould be greatly appreciated.
ThanksBig Smile

check your datasource to make sure it deployed properly and that the report is using the proper datasource (in properties)|||Yes.. its using the Source and be able to see the corrcet datasource in SQL manager. I am thining its more Login Setup, but there is not enough documents.|||It is definitely a data souce error, although it is a strange message. What type of credentials are used to connect to the data source?