configure log shipping between 2 sql servers stand alone

  • Hi,

    I am trying to configure log shipping between two standalone servers (they are no joined to a domain), I have a VPN between them.

    In Both Servers the MSSQLSERVER Service is running as NT Authority\NetworkService same configuration for SQL Server Agent, but when i finish the configuration I got this message

    BackupDiskFile::CreateMedia: Backup device '\\192.168.0.29\bkp\prueba_logSH.bak' failed to create. Operating system error 1326(Logon failure: unknown user name or bad password.).

    The folder that I am sharing has full control to everyone for sharing and also on the security options; indeed I can copy files, delete and read files from \\192.168.0.29\bkp

    I hope you guys can help me

    Thanks

    Carlos

  • Try to create a local logon to each of the servers and give it the same password (same account same password). Then use that account to run the services and grant that account necessary permissions to the file shares.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply