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!