InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 13:33:54 GMT20http://www.sqlservercentral.com/Forums/Topic703643-146-1.aspxYou may want to look around for the Double Hop issue. Once the SPNs were set up correctly, I didn't have any issues passing through authentication.http://jesseorosz.spaces.live.com/Blog/cns!E322FD91218E57CF!329.entryTue, 18 May 2010 11:36:19 GMTGreg Growhttp://www.sqlservercentral.com/Forums/Topic703643-146-1.aspxYou might look through a few articles like this to check your setup.There's also a white paper our on Publishing Performance Point Server in an Extranet Environment that also applies to Sharepoint Server.You don't give much details on your setup.Here's a very Rough outline -Servers and Service Accounts (Domain Account, not Local) need to be allowed to delegate.SPN's need to be setup - takes Domain Admin.If a web site is involved, this will need SPN's setup too.[url=http://support.microsoft.com/kb/319723]http://support.microsoft.com/kb/319723[/url][url=http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx[/url][url=http://msdn.microsoft.com/en-us/library/ee191523.aspx][/url]I also find setting this registry key on all machines helpful.This forces Kerberos to use TCPIP instead of UDP.Windows Registry Editor Version 5.00[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\Kerberos\Parameters]"MaxPacketSize"=dword:00000001Greg ETue, 18 May 2010 06:25:40 GMTGreg Edwards-268690http://www.sqlservercentral.com/Forums/Topic703643-146-1.aspxDid you ever get this resolved. I have the same issue with SQL 2008 linked server to SSAS 2008. The linked server works fine on the server but when trying to activate it remotely get the cannot be intialized error. Also tried this on a test box where everything is local so SSAS and SQL on same server and again it works fine locally but from a client trying to use linked server it fails to initialise again.Mon, 17 May 2010 08:33:40 GMTJames Perryhttp://www.sqlservercentral.com/Forums/Topic703643-146-1.aspxThanks. I will have our network guy verify the ports are open. If I add Anonymous Users to the cube, they have access. I would imagine, that if the ports were having issues, it would prevent anonymous as well. We have a case with Microsoft open. Once I hear back from them, I will post the fix.Fri, 24 Apr 2009 09:29:19 GMTGreg Growhttp://www.sqlservercentral.com/Forums/Topic703643-146-1.aspxThe 7373 error code may refer to any errors in the ole db provider itself. Also you may check that ports for your server (1434 and 2383) are listening proper locally and externally.Thu, 23 Apr 2009 21:52:34 GMTAShehzadhttp://www.sqlservercentral.com/Forums/Topic703643-146-1.aspxCan someone please help me with the steps to allow for the "Double Hop" scenario using Linked Servers to MSOLAP.Our Environment: 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 7373Its 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?ThanksGreg G.Thu, 23 Apr 2009 15:24:19 GMTGreg Grow