Re: Log shpping security/access problem....
From: Ken Schaefer (kenREMOVE_at_THISadopenstatic.com)
Date: 02/14/05
- Next message: gv: "Re: Admin sql login"
- Previous message: Uri Dimant: "Re: Sql Server Authenicated logins - password aging, 3 try lockout"
- In reply to: gordon: "Log shpping security/access problem...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 14 Feb 2005 17:35:00 +1100
http://support.microsoft.com/?id=288577
Cheers
Ken
"gordon" <gordon@discussions.microsoft.com> wrote in message
news:A21C498F-EF0D-4A2B-80A5-A7113C1D1A2B@microsoft.com...
>I don't understand, have sql 2000 on a win2000server. I set the sqlserver
>to
> startup using the ./administrator account.
>
> I use Windows XP on my destkop and use desktop connection to get to the
> server. I log on as the administrator account.
>
> I created a log shipping maintenance plan. As long as I am logged on to
> the
> server, and use the SA account to register the servers in in Ent Manager.
> The jobs ALL run fine. Until I log off. Once off, the jobs all go to
> hell..
> The restores all start to fail. The backups still work, but the restores
> fail. This happens every time I recreate the jobs. I get the following
> erron on the restore
>
> .....Executed as user: CHLSNT010\Administrator. sqlmaint.exe failed.
> [SQLSTATE 42000] (Error 22029). The step failed.
>
> I can't find anything on error 22029.
>
> Can anyone help with this.
>
> Thanks
> Gordon
- Next message: gv: "Re: Admin sql login"
- Previous message: Uri Dimant: "Re: Sql Server Authenicated logins - password aging, 3 try lockout"
- In reply to: gordon: "Log shpping security/access problem...."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
