Saturday, February 25, 2012

Maintenance plans

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
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" <jaylou@.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!
"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" <jaylou@.discussions.microsoft.com> wrote in message
> news:46733E11-AF11-4398-AC8F-4F6FE694A54D@.microsoft.com...
>

No comments:

Post a Comment