Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error when backing up to a backup server Expand / Collapse
Author
Message
Posted Friday, July 11, 2014 12:54 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 4:26 PM
Points: 21, Visits: 58
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.


  Post Attachments 
SQLError.gif (16 views, 22.67 KB)
Post #1591463
Posted Friday, July 11, 2014 2:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 6,619, Visits: 14,185
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"
Post #1591486
Posted Friday, July 11, 2014 2:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 5:13 AM
Points: 1,131, Visits: 1,394
Please check folder rights. It seems folder doesnt have required rights.

Thanks
Post #1591487
Posted Monday, July 14, 2014 12:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 4:26 PM
Points: 21, Visits: 58
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?
Post #1592065
Posted Monday, July 14, 2014 1:07 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 6,619, Visits: 14,185
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"
Post #1592076
Posted Sunday, July 20, 2014 11:58 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 4:26 PM
Points: 21, Visits: 58
Sorry can you please step me through on how to do this?
Post #1594438
Posted Sunday, July 20, 2014 11:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 11, 2014 4:26 PM
Points: 21, Visits: 58
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.
Post #1594439
Posted Monday, July 21, 2014 12:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 7:46 AM
Points: 6,619, Visits: 14,185
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"
Post #1594444
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse