{"id":719,"date":"2013-03-15T11:04:45","date_gmt":"2013-03-15T18:04:45","guid":{"rendered":"https:\/\/mmman.itgroove.net\/?p=719"},"modified":"2023-02-24T21:48:48","modified_gmt":"2023-02-24T21:48:48","slug":"the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated","status":"publish","type":"post","link":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/","title":{"rendered":"The data connection uses Windows Authentication and user credentials could not be delegated"},"content":{"rendered":"

As detailed in this<\/a> post on the topic, you may sometimes see the follow error message when running a PowerPivot report (either when opening the report, running an explicit data refresh, or it may pop up on its own if the worksheet is setup to refresh automatically).  You may also encounter this error in other instances unrelated to PowerPivot.<\/p>\n

\"image\"<\/a><\/p>\n

In my case, when I see this in combination with a SharePoint installation (2010 or 2013), I\u2019ve often found that the advice in the article regarding setting the Claims to Windows Token Service to use the Local System Account, is actually what resolves this.<\/p>\n

From the article:<\/p>\n

What account is the Claims to Windows Token Service running as?<\/u> By default it is configured to run as Local System, and I am not aware of the reasons for changing this configuration (the msdn article also refers to the fact that it should be running as Local System).  If you have permissions, switch it back to Local System and try the scenario again.<\/p>\n

To do this, follow these steps:<\/p>\n

Go into your services window and find the Claims to Windows Token Service.  You may find that the service is running as a SharePoint service account.<\/p>\n

\"image\"<\/a><\/p>\n

Double click on the Service to open the dialog, and under the \u201cLog On\u201d tab, change this to the Local System account.<\/p>\n

\"image\"<\/a><\/p>\n

Click OK to commit the change.  I recommend you make this change on all servers in your farm, but for certain, you\u2019ll need to do this on any server running the PowerPivot Analysis Services instance.<\/p>\n

That\u2019s really all there is to it.  Hopefully this resolves your authentication delegation issues.<\/p>\n","protected":false},"excerpt":{"rendered":"

As detailed in this post on the topic, you may sometimes see the follow error message when running a PowerPivot report (either when opening the report, running an explicit data refresh, or it may pop up on its own if the worksheet is setup to refresh automatically).  You may also encounter this error in other … <\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[30,7],"tags":[],"acf":[],"yoast_head":"\nThe data connection uses Windows Authentication and user credentials could not be delegated - Archive<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The data connection uses Windows Authentication and user credentials could not be delegated - Archive\" \/>\n<meta property=\"og:description\" content=\"As detailed in this post on the topic, you may sometimes see the follow error message when running a PowerPivot report (either when opening the report, running an explicit data refresh, or it may pop up on its own if the worksheet is setup to refresh automatically).  You may also encounter this error in other …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/\" \/>\n<meta property=\"og:site_name\" content=\"Archive\" \/>\n<meta property=\"article:published_time\" content=\"2013-03-15T18:04:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-24T21:48:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/03\/image_thumb45.png\" \/>\n<meta name=\"author\" content=\"Colin Phillips (Alumni)\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Colin Phillips (Alumni)\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/\",\"url\":\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/\",\"name\":\"The data connection uses Windows Authentication and user credentials could not be delegated - Archive\",\"isPartOf\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/03\/image_thumb45.png\",\"datePublished\":\"2013-03-15T18:04:45+00:00\",\"dateModified\":\"2023-02-24T21:48:48+00:00\",\"author\":{\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\"},\"breadcrumb\":{\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#primaryimage\",\"url\":\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/03\/image_thumb45.png\",\"contentUrl\":\"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/03\/image_thumb45.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog Archive\",\"item\":\"https:\/\/regroove.ca\/archive\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The data connection uses Windows Authentication and user credentials could not be delegated\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/regroove.ca\/archive\/#website\",\"url\":\"https:\/\/regroove.ca\/archive\/\",\"name\":\"Archive\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/regroove.ca\/archive\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b\",\"name\":\"Colin Phillips (Alumni)\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g\",\"caption\":\"Colin Phillips (Alumni)\"},\"url\":\"https:\/\/regroove.ca\/archive\/author\/cphillips\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The data connection uses Windows Authentication and user credentials could not be delegated - Archive","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/","og_locale":"en_US","og_type":"article","og_title":"The data connection uses Windows Authentication and user credentials could not be delegated - Archive","og_description":"As detailed in this post on the topic, you may sometimes see the follow error message when running a PowerPivot report (either when opening the report, running an explicit data refresh, or it may pop up on its own if the worksheet is setup to refresh automatically).  You may also encounter this error in other …","og_url":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/","og_site_name":"Archive","article_published_time":"2013-03-15T18:04:45+00:00","article_modified_time":"2023-02-24T21:48:48+00:00","og_image":[{"url":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/03\/image_thumb45.png"}],"author":"Colin Phillips (Alumni)","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Colin Phillips (Alumni)","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/","url":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/","name":"The data connection uses Windows Authentication and user credentials could not be delegated - Archive","isPartOf":{"@id":"https:\/\/regroove.ca\/archive\/#website"},"primaryImageOfPage":{"@id":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#primaryimage"},"image":{"@id":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#primaryimage"},"thumbnailUrl":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/03\/image_thumb45.png","datePublished":"2013-03-15T18:04:45+00:00","dateModified":"2023-02-24T21:48:48+00:00","author":{"@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b"},"breadcrumb":{"@id":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#primaryimage","url":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/03\/image_thumb45.png","contentUrl":"http:\/\/mmman.itgroove.net\/wp-content\/uploads\/mmman\/2013\/03\/image_thumb45.png"},{"@type":"BreadcrumbList","@id":"https:\/\/regroove.ca\/archive\/2013\/03\/15\/the-data-connection-uses-windows-authentication-and-user-credentials-could-not-be-delegated\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Archive","item":"https:\/\/regroove.ca\/archive\/"},{"@type":"ListItem","position":2,"name":"The data connection uses Windows Authentication and user credentials could not be delegated"}]},{"@type":"WebSite","@id":"https:\/\/regroove.ca\/archive\/#website","url":"https:\/\/regroove.ca\/archive\/","name":"Archive","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/regroove.ca\/archive\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/adeb0df1cc7a862160be620ca7eace1b","name":"Colin Phillips (Alumni)","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/regroove.ca\/archive\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/14eeab0d377e9630e0983d9c08911979?s=96&d=mm&r=g","caption":"Colin Phillips (Alumni)"},"url":"https:\/\/regroove.ca\/archive\/author\/cphillips\/"}]}},"_links":{"self":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/719"}],"collection":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/comments?post=719"}],"version-history":[{"count":1,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/719\/revisions"}],"predecessor-version":[{"id":1959,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/posts\/719\/revisions\/1959"}],"wp:attachment":[{"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/media?parent=719"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/categories?post=719"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/regroove.ca\/archive\/wp-json\/wp\/v2\/tags?post=719"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}