|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Maintenance plansI am not sure if this is the correct forum, but here goes.
can anyone tell my what account (SQL Agent or SQL Server) runs Maintenance plans? I always thought it was the Agent that ran all jobs on the server. I am using 2 different Accounts, one for server and the other for Agent. the server keeps trying to log onto the server where my backups are going not Agent. Is this the way it's supposed to be? Thanks, Joe Agent executes an xp which in turn executes an exe file which logs on to SQL Server and execute the
BACKUP command and then SQL Server tries to access the drive where to put the backup. So, it is SQL Server that need permission. -- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ "jaylou" <jay***@discussions.microsoft.com> wrote in message news:46733E11-AF11-4398-AC8F-4F6FE694A54D@microsoft.com... >I am not sure if this is the correct forum, but here goes. > > can anyone tell my what account (SQL Agent or SQL Server) runs Maintenance > plans? I always thought it was the Agent that ran all jobs on the server. I > am using 2 different Accounts, one for server and the other for Agent. the > server keeps trying to log onto the server where my backups are going not > Agent. Is this the way it's supposed to be? > > Thanks, > Joe Thank you!
Show quote "Tibor Karaszi" wrote: > Agent executes an xp which in turn executes an exe file which logs on to SQL Server and execute the > BACKUP command and then SQL Server tries to access the drive where to put the backup. So, it is SQL > Server that need permission. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > Blog: http://solidqualitylearning.com/blogs/tibor/ > > > "jaylou" <jay***@discussions.microsoft.com> wrote in message > news:46733E11-AF11-4398-AC8F-4F6FE694A54D@microsoft.com... > >I am not sure if this is the correct forum, but here goes. > > > > can anyone tell my what account (SQL Agent or SQL Server) runs Maintenance > > plans? I always thought it was the Agent that ran all jobs on the server. I > > am using 2 different Accounts, one for server and the other for Agent. the > > server keeps trying to log onto the server where my backups are going not > > Agent. Is this the way it's supposed to be? > > > > Thanks, > > Joe > > |
|||||||||||||||||||||||