Log shpping security/access problem....

From: gordon (gordon_at_discussions.microsoft.com)
Date: 02/12/05

  • Next message: Dan Guzman: "Re: Execute Persmission denied on object 'sp_OACreate'" 
    Date: Fri, 11 Feb 2005 17:09:02 -0800

    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: Dan Guzman: "Re: Execute Persmission denied on object 'sp_OACreate'"

    Relevant Pages

    • Re: Log shpping security/access problem....
      ... I log on as the administrator account. ... > server, and use the SA account to register the servers in in Ent Manager. ... the jobs all go to ... The backups still work, but the restores ...
      (microsoft.public.sqlserver.security)
    • Re: log shipping restore failure
      ... >> server, and use the SA account to register the servers in in Ent Manager. ... the jobs all go to ... >> The restores all start to fail. ... The backups still work, but the restores ...
      (microsoft.public.sqlserver.replication)
    • Re: SQL 2005 Trying to run jobs owned by the NT AUTHORITY SYSTEM user.
      ... running on the SQL 2005 system. ... I am trying to get the SQL agent jobs to ... run as the local NT_AUTHORITY\System account. ... TransactionLogMaintenance.Subplan_1 does not have server access." ...
      (microsoft.public.sqlserver.server)
    • Error with Log shipping auto restore
      ... I log on as the administrator account. ... server, and use the SA account to register the servers in in Ent Manager. ... the jobs all go to hell.. ... The restores all start to fail. ...
      (microsoft.public.sqlserver.setup)
    • Re: SQL Service Accounts
      ... > feeding" of SQL Server 2000. ... > DBA tasks at prior jobs, so I'm not a complete novice. ... > account and the servers are set for mixed security. ...
      (microsoft.public.sqlserver.security)