Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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!

share|improve this question
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
show 6 more comments

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

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

1 Answer

up vote 2 down vote accepted

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".

share|improve this answer
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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