Excel Services and Delegated Security

by keruibo 10. January 2009 15:18

Just as with other BI front-end technologies in a Microsoft environment, Excel Services worksheets that access back-end data (e.g. Cubes, Databases) require Kerberos delegation configuration.  However, most MOSS installations are initially configured for NTLM security, and making the transition over to Kerberos becomes a challenge since all the things done by installer programs have to be done by hand.

 If you're trying to get your Excel Services worksheets to refresh to a back-end database and receive "Data Refresh Failed" error messages, odds are Excel Services hasn't been configured to delegate security. 

 1. Open Command Prompt
 2. cd C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
 3. stsadm -o set-ecssecurity -accessmodel delegation -ssp SharedServices1
 4. stsadm -o execadmsvcjobs
 5. iisreset

In the interest of giving credit where due, thanks to Gunter Staes (http://blogs.msdn.com/gunterstaes) for the original command sequence some time back.

Tags: , ,

Configuration | Security | SharePoint

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (31) | Post RSSRSS comment feed

Comments


February 4. 2010 08:40
Be glad of life because it gives you the chance to love, to work, to play, and to look up at the stars.


February 21. 2010 11:26
Well, this is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a marvellous job!


February 24. 2010 14:43
Do you accept guest posts? I would love to write couple articles here.
I was wondering what is up with that weird gravatar??? I know 5am is early and I'm not looking my best at that hour, but I hope I don't look like this! I might however make that face if I'm asked to do 100 pushups. lol


February 25. 2010 08:53
Admiring the time and effort you put into your blog and detailed information you offer! I will bookmark your blog and have my children check up here often. Thumbs up!


February 26. 2010 06:21
Admiring the time and effort you put into your blog and detailed information you offer! I will bookmark your blog and have my children check up here often. Thumbs up!


February 26. 2010 12:36
You got a really useful blog I have been here reading for about an hour. I am a newbie and your success is very much an inspiration for me.


February 27. 2010 21:33
Do have an email system where your blog posts emailed to me?


February 28. 2010 00:01
You got a really useful blog I have been here reading for about an hour. I am a newbie and your success is very much an inspiration for me.


March 2. 2010 04:45
Thank you for the sensible critique. Me & my neighbour were preparing to do some research about that. We got a good book on that matter from our local library and most books where not as influensive as your information. I am very glad to see such information which I was searching for a long time.This made very glad Smile


March 2. 2010 07:35
You really make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post, I will try to get the hang of it!


March 2. 2010 10:40
Welcome First time skipped here on your site, founde on Google. Thank you very much for your advice.


March 4. 2010 02:54
Welcome First time on Excel Services and Delegated Security hopped here on your site, founde on Yahoo. bassa  Send me news to videocitytv@yahoo.com


March 5. 2010 02:27
I am not much of a guy who thinks in so deeply about web design but I think your post had some valid points in it. Like designers are forced to design stuff within the limited code available and not go beyond it, their innovation is somewhat limited but still I think Web Design won't die! I agree that Amazon and other some big sites won't have a blog but now a days it's very important to have some sort of option available so people can quickly communicate their thoughts. I think Amazon if wants to shift it to that, they can get a customized CMS for themselves.


March 5. 2010 02:36
I enjoy watching movies online, it is way easier than going to the theaters.


March 6. 2010 01:57
I don't agree with everything in this blog, but you do make some very good points. Im very interested in this subject matter and I myself do alot of research as well. Either way it was a well thoughtout and nice read so I figured I would leave you a comment. Feel free to check out my website sometime and let me know what you think.


March 6. 2010 21:51
I have read a few of the articles on your website now, and I really like your style of blogging. I added it to my favorites blog site list and will be checking back soon. Please check out my site as well and let me know what you think.


March 7. 2010 01:39
Howdy, i read your blog occasionally and i own a similar one and i was just wondering if you get a lot of spam comments? If so how do you prevent it, any plugin or anything you can advise? I get so much lately it's driving me mad so any assistance is very much appreciated.


March 7. 2010 03:10
You got a really useful blog I have been here reading for about an hour. I am a newbie and your success is very much an inspiration for me.


March 7. 2010 03:20
Valuable information and excellent design you got here! I would like to thank you for sharing your thoughts and time into the stuff you post


March 7. 2010 23:32
Do you accept guest posts? I would love to write couple articles here.
I was wondering what is up with that weird gravatar??? I know 5am is early and I'm not looking my best at that hour, but I hope I don't look like this! I might however make that face if I'm asked to do 100 pushups. lol


March 8. 2010 06:12
Thank you for another great article. Where else could anyone get that kind of information in such a perfect way of writing? I have a presentation next week, and I am on the look for such information.


March 8. 2010 13:08
Your site Excel Services and Delegated Security is clearly a labor of love. Some of your posts take hours or even days to compile. Hi HI  First time skipped here on your site, founde on ASK. Thank you so much for responding so quickly. It really helped me. sevener Send me news to Cardo@yahoo.com  Send me news to Cardo@yahoo.com


March 8. 2010 19:17
I would like to add your blog to my blogroll delight aver me what backbone should I use?

Regards
Devita








March 9. 2010 06:06
I liked the layout and it is really a nice one


March 9. 2010 12:51
You prefab large high ideas here. I through a investigate on the master and learnt most peoples leave concur with your diary.

Regards
Nunes





March 9. 2010 14:29
I still believe Excel Services and Delegated Security that you should have affiliate links for the products that meet your standards for excellence. Welcome First time jumped here on your site, founde on Yahoo. Thank you!! You have given me much to think about. codings Send me news to pisit_252@hotmail.com


March 9. 2010 21:33
Do you know which cell phone companies allow tethering?


March 11. 2010 01:41
Hi. this is kind of an "unconventional" question , but have other visitors asked you how get the menu bar to look like you've got it? I also have a blog and am really looking to alter around the theme, however am scared to death to mess with it for fear of the search engines punishing me. I am very new to all of this ...so i am just not positive exactly how to try to to it all yet. I'll just keep working on it one day at a time.


March 11. 2010 03:17
I don't agree with everything in this blog, but you do make some very good points. I'm very interested in this matter and I myself do alot of research as well. Either way it was a well thoughtout and nice read so I figured I would leave you a comment. Feel free to check out my website sometime and let me know what you think.


March 11. 2010 05:00
I was wondering what is up with that weird gravatar??? I know 5am is early and I'm not looking my best at that hour, but I hope I don't look like this! I might however make that face if I'm asked to do 100 pushups. lol


March 11. 2010 15:21
This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work.

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading



Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2010 Rob Kerr's BI Blog