Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a SQL 08 Standard box that I would like to use a Maintenance Plan to backup a database over a network share? Is this possible as the GUI won't let me do that? It tells me it can't find the path. The SQL service has permissions to write on the share.

share|improve this question
    
Can you access the path from Windows Explorer on the SQL Server? –  joeqwerty Mar 11 '12 at 21:03
    
@joeqwerty Yes I can –  Jacob Mar 11 '12 at 21:15
    
when you say "SQL service has permissions to write on the share" is this a domain based account? –  tony roth Mar 12 '12 at 1:05
    
@tonyroth yes it does –  Jacob Mar 12 '12 at 1:12
    
can you login local to the server as the service account then browser the remote share. –  tony roth Mar 12 '12 at 1:32

1 Answer 1

up vote 5 down vote accepted

This is usually because the SQL server is running under an account that does not have permission to access the network shares.

If your SQL server account is not running under a "real" AD account, this might be the time to set that up. It's simple enough to do:

  1. Create an account for your SQL Server to run under (Feel free to make the password long and complex, you only need it once).
  2. Go to the Services control panel for that server
  3. Right-click on the SQL Services (you should do the SQL Server and the Agent), go to Properties, Log On
  4. Select "This Account" and enter the credentials for your SQL Server

    enter image description here

  5. Restart the service

(May I suggest you test this first before shutting down a live SQL server)

Then you can specify share permissions on the network folder to state that the SQL Server account has full read/write access, but others might only have read access, or perhaps no access at all.

share|improve this answer
    
you'd think thats what he meant by "SQL service has permissions to write on the share" wouldn't you? –  tony roth Mar 12 '12 at 1:05
    
I was actually just in chat with Jacob and we went through the issue there, so it might not have been the case when I posted my answer –  Mark Henderson Mar 12 '12 at 1:13
    
also I'd set the account to not expire. –  tony roth Mar 12 '12 at 2:06
    
Ohh yeah that too –  Mark Henderson Mar 12 '12 at 2:55
    
Doubt this is a public facing sql server but if so then I hope they have proper control of the "domain user" group. Hackers are loving the fact that once they inject they pretty much know that the "domain user" group is poorly managed, as in its applied everywhere. –  tony roth Mar 12 '12 at 13:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.