Re: sql agent permission

From: Lan Lewis-Bevan [MS] (lanlb@online.microsoft.com)
Date: 07/04/02 

From: lanlb@online.microsoft.com (Lan Lewis-Bevan [MS])
Date: Wed, 03 Jul 2002 23:10:41 GMT

It looks like that DB1\sqlservice has the right to copy files over to
serverB (your 2nd step, copy the backup file from serverA to serverB, was
successful), but does not have the right to run a SP on ServerB's SQL
server.

You may consider to map DB1\sqlservice to a remote user on your linked
server security page.

Hope this helps.

Thanks.

Lan

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.