View Complete Post
I realize this is probably going to be one of those vague questions that I am not going to get much help on here, but I thought I'd give this a shot before we go the MS Incident route on monday.
We have tried to setup Kerberos between MOSS 2007 AND SSAS 2005 to no avail. We have been through the knowledge base articles outlining the setup multiple times with all the experts on MOSS and Security here where I work. We've used other materials
we have on kerberos here. But the end result is that the double hop is not happening. We are trying to connect three ways: excel services, ssrs 2005 in integrated mode, and Sharepoint KPI's (using analysis services). In every case the connection
is not happening.
Other details are that the ssrs integrated mode seems to be setup right because I do get a report (albiet all it has is a connection error message). Excel services works fine if I use the unattended service account, but when I switch the odc file to
windows (should cause kerberos to kick in) it fails. When I try to add a kpi to the kpi list it can't retrieve a list of kpi's from ssas.
In all cases I am the user trying to perform these operations, and I have total access to the cube -- I'm the developer. I have no problems connecting to the cube directly through excel, so the security at that end passes t