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
>

Reporting Services not working after Windows 2003 Service Pack 1 installed

Help. After we installed Windows 2003 service pack one the SQL reporting is
getting an error:
The request failed with HTTP status 401: Unauthorized.
Can anybody help?Check if the 401 error has the same call stack as discussed in this thread:
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=d2f44745-4eb8-420d-b44a-da1b388069d7&sloc=en-us
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:euKwWDDRFHA.996@.TK2MSFTNGP09.phx.gbl...
> Help. After we installed Windows 2003 service pack one the SQL reporting
> is getting an error:
> The request failed with HTTP status 401: Unauthorized.
> Can anybody help?
>sql

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.
Thanks

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?

Reporting services installation

When I install reporting services in sqlserver 2005,its stops half way saying ' sqlserver setup failed to obtain system account information for the ASPNET account.To proceed re install the .NET framework and continue'

How do I set up an ASP account so as to continue with the installation?

Try running aspnet_regiis.exe -i to reinstall ASP.NET.

Reporting Services install failed

Hi,
When installing Reporting Services 2005 I receive the following error.
'SQL Server setup failed to retrieve the SSL Certificate Name'
I installed the SSL certificate using IIS Resources SelfSSL with the
following cmd
'selfssl.exe /N:CN=[ComputerName] /T /V:365
Reporting Services 2000 was working fine. The error occurs if I upgrade or
do a fresh install.
TIA
RachelHi,
I have removed the SSL Certificate and all is working, I do need SSL on my
report server though. Should I reinstall the certificate now or will that
cause problems?
TIA
Rachel
"Rachel" wrote:
> Hi,
> When installing Reporting Services 2005 I receive the following error.
> 'SQL Server setup failed to retrieve the SSL Certificate Name'
> I installed the SSL certificate using IIS Resources SelfSSL with the
> following cmd
> 'selfssl.exe /N:CN=[ComputerName] /T /V:365
> Reporting Services 2000 was working fine. The error occurs if I upgrade or
> do a fresh install.
> TIA
> Rachel
>

Reporting Services Failed Install

Hi all,

I have an SBS server that I tried to installed SQL Server 2005 Express edition for some testing/dev work (non-production server here) and although SQL installed, the reporting services component failed with the following.

--
Machine : RAND
Product : Reporting Services
Error : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.

--
Machine : RAND
Product : Microsoft SQL Server 2005 Reporting Services
Product Version : 9.1.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_RAND_RS.log
Last Action : InstallFinalize
Error String : The setup has encountered an unexpected error while Setting reporting service and share point exclusion path. The error is: Fatal error during installation.
Error Number : 29528
--

Could use some help figuring that out...heh. I am able to shoot the entire log (the SQLSetup0001.RAND.RS.log) but it's like 10MB, and I didn't see a file upload option here. Any help is much appreciated though!

As you have SBS installed you should define the exclude path for your Report Server. See the Screencasts on my website for more information about defining an exclude path on the Sharepoint system. The Screencast cab be found under the tab nav bar entry "Screencast"

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

Reporting Services Error

Hello. I Do a report with a matrix, the report until the preview work
correctly, but when I publish it show me the next error
JIT debugging failed with the following error: Access Denied
JIT debugging was initiated by the user acount 'NT AUTHORITY\Servicio de
red'.
Check the documentation index for 'Just-in-time debugging, errors' for more
information.
htp://go.microsoft.com/fwlink/events.asp
I make the report again, publish it after every small change and I find that
it fail after I put a groups of rows in the matrix, but in the preview, it
dont show me any warning or errors, only fail after I publish it.
for better reference: the report use a shared data source and is publised in
a Windows 2003 server. the server test is a Windows 2000 Advance Server, SQL
2000, and .NET 2003Are you using any custom .dll files in this report? What else is it
referencing? It is clear that you have a permissions/security issue. The
designer will bypass code level security checks so it is not good for testing
this.. that would explain why you only get the error on deployed reports.
Bret Updegraff
http://bretup.spaces.live.com/
"UsuarioNovato" wrote:
> Hello. I Do a report with a matrix, the report until the preview work
> correctly, but when I publish it show me the next error
> JIT debugging failed with the following error: Access Denied
> JIT debugging was initiated by the user acount 'NT AUTHORITY\Servicio de
> red'.
> Check the documentation index for 'Just-in-time debugging, errors' for more
> information.
> htp://go.microsoft.com/fwlink/events.asp
>
> I make the report again, publish it after every small change and I find that
> it fail after I put a groups of rows in the matrix, but in the preview, it
> dont show me any warning or errors, only fail after I publish it.
> for better reference: the report use a shared data source and is publised in
> a Windows 2003 server. the server test is a Windows 2000 Advance Server, SQL
> 2000, and .NET 2003
>
>