This project has moved and is read-only. For the latest updates, please go here.

SqlQuery : Double hop concerne

Topics: Developer Forum, Project Management Forum, User Forum
Jun 14, 2012 at 7:55 AM
Edited Jun 14, 2012 at 7:58 AM

Hello....

after installation of the assembly SQLQUERY on SSAS 2008R2 with a impersonate option set to "Current user" we get a "Login Failed for User NT...\Anonymous Logon" error from client tool.

Of course we faceing double hop issue. Does someone can tel what kind of spn has to be declared in order to make it work ?

does MSSQLSvc/<SSASserver>:SQLPort would help ?

What about the "Server SPN" in the OLE DB connect string ?

NOTE  :  both SQL and SSAS (account is ok for delegation).

 

Thank's for your help