Can someone please help me with the steps to allow for the "Double Hop" scenario using Linked Servers to MSOLAP.
Computer A - SSAS (SQL 2008 64bit, uses a service account for log on)
Computer B - Has a Linked Server to Computer A (SQL Server 2008 Enterprise 64bit, uses a service account for log on)
Computer C - My Desktop with SSMS to test the linked server (2008 Developer 32bit)
When I open my SSMS session and connect to computer B to test the linked server it fails with the following error:
"Cannot set the initialization properties for OLE DB provider "MSOLAP.4" for linked server.. etc... etc... OLE DB provider for linked server returned message "The following system error occured: The system cannot find the file specified." Error 7373
Its interesting; if I log onto the host where the linked server is at with the same domain credentials, the test of the linked server works on the computer B host. And, it now works from my desktop computer C. Once I log off of Computer B, my computer C test begins to fail again. I am guessing that my credentials and profile is authenticating properly.
The Windows Adminsitrators say that everything is set up correctly with Kerberos and SPNs, but I still am not sure since I am unable to test successfully. Not sure what to try next.
Does anyone of have any lists or steps they used to get the double hop working from personal desktops?