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!

  • 1
    What do you mean, "add it to SharePoint admin"? Jun 27, 2012 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, 2012 at 14:45
  • 1
    A server is not a user or group. Again, what are you trying to accomplish? Jun 27, 2012 at 14:46
  • @John Saunders- I edited the Question. Hope it helps. TIA.
    – Nemo
    Jun 27, 2012 at 14:52
  • 1
    I don't understand why you don't just run the SQL job as a specific user. Jun 27, 2012 at 14:57

1 Answer 1


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, 2012 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. Jun 27, 2012 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.