SQL Blog - Pieter van Maasdam, Macaw

SSIS, SSAS, SSRS & other SQL-things I come across...
SSRS -Report execution failed. Solution: SSPI=NTLM

When executing reports (Reporting Services 2008) with Analysis Services 2008 as a source I sometimes get an error saying: "Query execution failed for...". The problem seemed to have something to do with large amounts of data (just guessing this...)

To fix this error we had to add SSPI=NTLM to the connectionstring:

Data Source=MyServer;Initial Catalog=MySSASDB;SSPI=NTLM;

I'm glad it's working now, although I don't understand what it actually does... 

 

 

 

Published 17 November 2009 13:55 by Repieter

Filed under: ,

Comments

# re: SSRS -Report execution failed. Solution: SSPI=NTLM@ 20 November 2009 10:09

Hi Pieter,

This sounds like a Kerberos issue. There have been a number of reports regarding Kerberos issues with Analysis Services if you using Windows Server 2008 or Vista (blogs.msdn.com/.../errors-may-occur-after-configuring-analysis-services-to-use-kerberos-authentication-on-advanced-encryption-standard-aware-operating-systems.aspx) and a fix has now been released (support.microsoft.com/.../969083).

Thanks,

Rob

robcarrol

# re: SSRS -Report execution failed. Solution: SSPI=NTLM@ 23 November 2009 07:23

Hi Rob,

Thanks for the comment. That blog explains a lot!

Regards,

Pieter

Repieter

# Handy SQL Server knowledge nuggets « C# Hacker – The Rambling Coder@ 25 January 2010 04:40

Pingback from  Handy SQL Server knowledge nuggets «  C# Hacker – The Rambling Coder

Handy SQL Server knowledge nuggets « C# Hacker – The Rambling Coder