Groups | Blog | Home
all groups > sql server reporting services > october 2004 >

sql server reporting services : kerberos



Will Byron
10/29/2004 3:52:43 PM
Hi
Want to know how to get kerberos to work
3 workstations involved
User computer with Windows 2000 runs I.E 6.0 and accesses a web page on
Reporting services server (Web Portion-IIS) running windows 2003.
USer is running a report that runs an mdx statement on a data server which
is also windows 2003
We included in the connection string sspi=kerberos
We also when to the domain controller which is windows 2003 and enabled
kerberos delegation on the web and data server.

We still get the below error

An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
a.. Cannot create a connection to data source 'OLAP'.
(rsErrorOpeningConnection) Get Online Help
a.. The operation requested failed due to security problems - the user
could not be authenticated
b.. Thanks in advance

Scott Allen
10/30/2004 10:00:50 AM
Hi Will:

There are some Kerberos troubleshooting tips in the following doc:

HOW TO: Troubleshoot Kerberos-Related Issues in IIS
http://support.microsoft.com/default.aspx?kbid=326985

HTH,

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Fri, 29 Oct 2004 15:52:43 -0400, "Will Byron"
[quoted text, click to view]
AddThis Social Bookmark Button