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 (43) | Post RSSRSS comment feed

Comments


February 4. 2010 18: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 21: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 25. 2010 00: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 18: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 16: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 22: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 28. 2010 07:33
Do have an email system where your blog posts emailed to me?


February 28. 2010 10: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 14: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 17: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 20:40
Welcome First time skipped here on your site, founde on Google. Thank you very much for your advice.


March 4. 2010 12: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 12: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 12:36
I enjoy watching movies online, it is way easier than going to the theaters.


March 6. 2010 11: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 7. 2010 07: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 11: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 13: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 13: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 8. 2010 09: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 16: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 23: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 9. 2010 05:17
I would like to add your blog to my blogroll delight aver me what backbone should I use?

Regards
Devita








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


March 9. 2010 22: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 10. 2010 00: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 10. 2010 07:33
Do you know which cell phone companies allow tethering?


March 11. 2010 11: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 13: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 15: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 12. 2010 01: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.


March 13. 2010 06:35
Hello All, I just wanted to start by saying that the contribution here is simply amazing. I think everyone does a fine job here and just wanted to make that known. Have you ever thought about blogging for money? there is a website http://www.article-pie.com that pays you to write articles, you would be good at it.


March 13. 2010 09:34
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 13. 2010 11:15
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 15. 2010 09:56
Do you acquire unobjectionable money from this blog or are you doing it fair for fun?

Regards
Seth







March 15. 2010 10:27
Very newsworthy topic module bookmark your tract to checker if you indite author some in the next.

Regards
Stewart



March 17. 2010 02:37
This is a good piece of content, I was wondering if I could use this piece of writing on my website, I will link it back to your website though. If this is a problem please let me know and I will take it down right away. Excel Services and Delegated Security


March 17. 2010 08:53
I admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well.


March 17. 2010 09:33
I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post


March 17. 2010 10:15
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 17. 2010 11:16
Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon.


March 17. 2010 18:33
You own a very interesting blog covering lots of topics I am interested as well.Just bookmarked your blog so I can read more in the future... Please continue your marvellous work


March 18. 2010 20:54
Awesome stuff you guys got here.  I really like the theme of the website and how well you organized the content.  It's a marvelous job I will come back and check you out sometime.

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