Skip to content

Writing Backups to A Network or Remote Location in SQL Server 2012 in Maintenance Plans

by on May 6, 2014

Logic would dictate that the SQL Server Agent service and its specified account would be used to run jobs in SQL Server – after all, they appear under the sql server agent object in SSMS.


Research may even lead you to believe this, as Microsoft is unclear on this point. Even the error messages are vague and do not state what account does not have access, just that access is denied to the location.


You actually need “SQL Server” to use a domain account to access the network location.

Sql Server Configuration Manager > sql server services > right click > properties


NOTE: You still need to make sure the network location grants that domain user full permissions on the folder to which you are setting the path.

Right click the folder > properties > security

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: