Hi,

I'm working on a Windows 2000 machine which hosts a SQL 2005 Express
Database.

This database is backed up using the following method -

http://www.sqldbatips.com/showarticle.asp?ID=27

As part of this method, I have a Task which is scheduled to run once a
day. All words fine until I need to change my password. When I am
prompted to change my password every month or so, I need to go back
into the Scheduler and update my password there also. Otherwise my
backup process will fail. How can I solve this problem?

Another problem is that I will be soon handing the database over to
another employee at the company who will then be in charge of
maintaining it. Therefore I will have to configure the Scheduler to
run from his account. I'm sure there's a better approach...

Thanks for your help,

Barry.

<(E-Mail Removed)> wrote in message
news:0c1db6c7-a7ba-49d3-817c-(E-Mail Removed)...
> Hi,
>
> I'm working on a Windows 2000 machine which hosts a SQL 2005 Express
> Database.
>
> This database is backed up using the following method -
>
> http://www.sqldbatips.com/showarticle.asp?ID=27
>
> As part of this method, I have a Task which is scheduled to run once a
> day. All words fine until I need to change my password. When I am
> prompted to change my password every month or so, I need to go back
> into the Scheduler and update my password there also. Otherwise my
> backup process will fail. How can I solve this problem?
>
> Another problem is that I will be soon handing the database over to
> another employee at the company who will then be in charge of
> maintaining it. Therefore I will have to configure the Scheduler to
> run from his account. I'm sure there's a better approach...
>
> Thanks for your help,
>
> Barry.

The standard approach is to create and use a dedicated account for scheduled
tasks (e.g. "Scheduler") with a strong but non-expiring password.

((E-Mail Removed)) writes:
> As part of this method, I have a Task which is scheduled to run once a
> day. All words fine until I need to change my password. When I am
> prompted to change my password every month or so, I need to go back
> into the Scheduler and update my password there also. Otherwise my
> backup process will fail. How can I solve this problem?

Can't you create new user that you specify as the owner of this job?

--
Erland Sommarskog, SQL Server MVP, (E-Mail Removed)

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Nov 18, 2:27 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (Magnus.Morab...@gmail.com) writes:
> > As part of this method, I have a Task which is scheduled to run once a
> > day. All words fine until I need to change my password. When I am
> > prompted to change my password every month or so, I need to go back
> > into the Scheduler and update my password there also. Otherwise my
> > backup process will fail. How can I solve this problem?
>
> Can't you create new user that you specify as the owner of this job?
>

Hah! I tried that at work, and the admins force password policy on the
new account as well. Still, that would be my vote too.

((E-Mail Removed)) writes:
> Hah! I tried that at work, and the admins force password policy on the
> new account as well. Still, that would be my vote too.

Hm, can't you make a local machine account? That should not be subject
to group policy.

But if you need a service account that has to be a domain account, why
don't you talk to your admin folks?

--
Erland Sommarskog, SQL Server MVP, (E-Mail Removed)

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Nov 20, 1:57 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (patrick...@yahoo.com) writes:
> > Hah! I tried that at work, and the admins force password policy on the
> > new account as well. Still, that would be my vote too.
>
> Hm, can't you make a local machine account? That should not be subject
> to group policy.
>
> But if you need a service account that has to be a domain account, why
> don't you talk to your admin folks?
>

These sorts of jobs I want executed need too much network access for
local accounts, and I already did ask the admins to no avail. I think
that these sorts of practices are pretty much embraced to save on the
work researching the ramifications of doing something different (often
to a comically extreme extent) but on the bright side, if I keep my
protestations at a friendly academic level, I'm more likely to keep a
job.