Post reply

Error when backing up to a backup server

  • July 11, 2014 at 12:54 am

    #397044

    I'm trying to backup my databases to another backup server though I'm receiving the attached error.

    the SQL service is logged on as "Network Service"

    Please let me know if you can think of a potential cause.

  • July 11, 2014 at 2:50 am

    #1728634

    go onto the remote server and find the backups share. You need to check and set Share permissions then move to the folders security tab and set NTS ACLs too.

    The computer account for the sql server must be granted permissions in both these places.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 11, 2014 at 2:54 am

    #1728635

    Please check folder rights. It seems folder doesnt have required rights.

    Thanks

  • July 14, 2014 at 12:05 am

    #1729038

    The SQL Service account is logged on as "Network Service" instead of a domain network account.

    Am I still able to give it permissions to the backup server somehow?

  • July 14, 2014 at 1:07 am

    #1729047

    cstrati (7/14/2014)

    The SQL Service account is logged on as "Network Service" instead of a domain network account.

    Am I still able to give it permissions to the backup server somehow?

    Did you read my post above??

    The computer account of the sql server must be added to the share\NTFS ACLs on the remote server.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • July 20, 2014 at 11:58 pm

    #1730886

    Sorry can you please step me through on how to do this?

  • July 20, 2014 at 11:59 pm

    #1730887

    The actual SQL Server is running under "Network Service" and is on a different domain so I'm not sure how to give it access the way you mentioned.

  • July 21, 2014 at 12:24 am

    #1730892

    cstrati (7/20/2014)

    and is on a different domain

    You never mentioned this before, complicates things even further. Is there a trust relationship between the 2 domains?

    You really should be working with your network admin to get this resolved

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 8 posts - 1 through 7 (of 7 total)

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