January 12, 2004 at 2:21 pm
When running a SQL Server Job that connects to a remote SQL Server using linked server, is there any way to setup each job to use different login mappings?What I meant is, if I have a server A, that has few jobs, and each of those jobs call a proc that connects to Server B in the procedure. In the linked server properties, under security tab, I have a mapping between accounts on server A and Server B. I would like to use a different account login map for each jobs based on business function. I don't seem to find a way. It looks like "all" SQL jobs use the login mappings set for the service account that the SQL Agent runs under, ie., all remote connections from SQL Jobs go under one identity. Though there is an owner for each job, that ownership is used only to determine whether or not he can run xp_cmdshell (by being a member of sysadmin group). Does the owner filed have any other use? In our case I would like to limit what each jobs can access by limiting it to access level of specific accounts. Any work arounds?
Thanks.
January 12, 2004 at 2:47 pm
You can do it by configuring master-target server.
Shas3
January 13, 2004 at 4:24 pm
Would running the job under windows account that has access to both the SQL Servers help? Or, it would use the SQL Service account no matter what..I just do not have enough time to get into the master-target server setup, since I have never done that before..
thanks in advance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply