Re: Log Shipping

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: bill (belgie_at_datamti.com)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 12:10:31 -0500

I added the account I'm using for SQL Server service to db owner group, and
now it works fine.
Thanks for your help.
-Bill

"Mike Hodgson" <mwh_junk@hotmail.com> wrote in message
news:uFeAtUw5EHA.3644@tk2msftngp13.phx.gbl...
> Bill,
>
> I spent a while fiddling around with permissions to get log shipping to
> work right and in the end I just added the service accounts for both my
> primary SQL instance and my secondary SQL instance to sysadmins on my
> monitor box. It's probably overkill but nothing (except for the log
> shipping coordination info) is kept on the monitor box and my primary &
> secondary service accounts are pretty secure.
>
> I expect the secondary is probably calling some stored procs during the
> update of the msdb.dbo.log_shipping tables at a guess (like
> msdb.dbo.sp_log_shipping_monitor_restore perhaps?). Maybe adding the
> accounts to db_owners in msdb on the monitor box would do the trick, if
> you're concerned about super-tight security on your monitor box.
>
> Cheers,
> Mike.
>
> bill wrote:
> > The log shipping works fine, but the destination server is not updating
the
> > monitor server 'log_shipping_secondaries' table, so I am getting out of
sync
> > errors.
> >
> > I had the destination server using the localsystem account, and I
thought
> > this might be a problem updating a table on another server, so I changed
it
> > to a network account. I created a login for this account and a user in
> > msdb, and gave it permissions to update the log_shipping_secondaries
table
> > in msdb, but it still isn't happening.
> >
> > I expect I am just doing something dumb, but I can't figure out what it
is.
> >
> > I would appreciate any thoughts on this.
> >
> > thanks
> > Bill
> >
> >

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
  • Re: SQL Express Fails with Hardware Error
    ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
    (microsoft.public.sqlserver.setup)
  • Re: SCCM with a remote SQL instance problems (IT IS NOT A WARNING)
    ... PreReq check is not a WARNING it is a FAILURE. ... account the run the SQL Server Service on the server, Domain Memberships, AD ...
    (microsoft.public.sms.installer)
  • Re: Distributed Query - Linked Servers?
    ... In the case of SQL style accounts, it doesn't seem very secure to me, because the password will be transmitted over the network. ... it should also be able to work by setting up a credential and proxy account on Server1. ... In this case it could work with NTLM authentication. ... we just need to verify that the 2 sql server instances are under sql server and windows authentication mode and the sql account you use has the permission on the 2 sql server instances. ...
    (microsoft.public.sqlserver.server)