{"id":52,"date":"2008-10-23T10:40:32","date_gmt":"2008-10-23T08:40:32","guid":{"rendered":"http:\/\/jsiegmund.wordpress.com\/?p=52"},"modified":"2013-04-18T18:51:57","modified_gmt":"2013-04-18T17:51:57","slug":"sharepoint-and-analysis-services-the-connection-either-timed-out-or-was-lost","status":"publish","type":"post","link":"http:\/\/blog.repsaj.nl\/index.php\/2008\/10\/sharepoint-and-analysis-services-the-connection-either-timed-out-or-was-lost\/","title":{"rendered":"SharePoint and Analysis Services: The connection either timed out or was lost"},"content":{"rendered":"<p>In my last post, I wrote about enabling access to SQL Server Analysis cubes by specifying an account for impersonation. It now seems that&#8217;s not the way to go because I started receiving security validation errors with impersonation set to any account. I think that&#8217;s caused because SharePoint detects a difference between the user actually performing an action and the user being impersonated by ASP.NET.<\/p>\n<p>So I went on searching for a way to enable access to Analysis Services. We don&#8217;t have a proper setup Kerberos environment, so that wasn&#8217;t an option. I tried giving read-only access to all domain users, but that wouldn&#8217;t work either. Then I came accross <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/cc262899.aspx#section5\">this article <\/a>in which an explanation is given on howto provide a Single Sign On account for ODC connections. It&#8217;s a nice and clear article and it helped my solving this problem. Once you&#8217;ve setup SSO and specified an account for your SSAS cube, you can specify that SSO id in your ODC connection file and it&#8217;ll use the stored credentials to pick up data from Analysis Services. Works great!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In my last post, I wrote about enabling access to SQL Server Analysis cubes by specifying an account for impersonation. It now seems that&#8217;s not the way to go because I started receiving security validation errors with impersonation set to any account. I think that&#8217;s caused because SharePoint detects a difference between the user actually<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[34],"tags":[7,10],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p3KFR1-Q","_links":{"self":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/52"}],"collection":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/comments?post=52"}],"version-history":[{"count":0,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/posts\/52\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/media?parent=52"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/categories?post=52"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.repsaj.nl\/index.php\/wp-json\/wp\/v2\/tags?post=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}