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.

image

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.

Solution:

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

image

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

Advertisements
Leave a Comment

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: