I need to add one of our production servers (that hosts SQL Server 2008) let's say XXX to SharePoint Admin in SharePoint 2010. How can I do that?

I agree that a server is not a user or a group. Let me share a background. I'm in a process of running a SSIS package from SQL Job. The package extracts data from a SharePoint list to sql table using http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 When I run it as myself( I have access to SharePoint server site), it runs fine. But when I try to run as a system user, it fails.

SO i m thinking of a way to add the server XXX that hosts SQL Server to the SharePoint farm so that SharePoint when sees that ok here's SQL Job from XXX as a System user is trying to access my list items, so lets grant it access!

migrated from stackoverflow.com Jun 27 '12 at 15:33

This question came from our site for professional and enthusiast programmers.

  • 1
    What do you mean, "add it to SharePoint admin"? – John Saunders Jun 27 '12 at 14:42
  • I meant to add XXX like adding a group/user in SharePoint farm and giving it the full control rights. – Nemo Jun 27 '12 at 14:45
  • 1
    A server is not a user or group. Again, what are you trying to accomplish? – John Saunders Jun 27 '12 at 14:46
  • @John Saunders- I edited the Question. Hope it helps. TIA. – Nemo Jun 27 '12 at 14:52
  • 1
    I don't understand why you don't just run the SQL job as a specific user. – John Saunders Jun 27 '12 at 14:57

Simply run the nightly job under the identity of a specific user who is granted specific rights to the SharePoint site. That way, you get your automation, but also get control of what the specific user is permitted to access.

I recommend creating a new user instead of reusing an existing user. This will create a sort of "separation of concerns".

  • I agree John. Thanks for your patience in providing prompt responses. :) But I don't think you can add a prod server XXX just like that in SharePoint farm right? And again, creating a new user instead of reusing an existing user will again go through the process of putting that user in active directory to be able to add him/her to SharePoint farm right? – Nemo Jun 27 '12 at 15:22
  • That is correct. Create a specific user like, "DOMAIN\auto-user1" and add that user to the farm with only the access privileges required. – John Saunders Jun 27 '12 at 15:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.