SQL 2005 Express Backup/Restore from UNC path
Posted on 2009-02-19
I have several computers that have SQL 2005 Express running. I am trying to restore a backup that is located on another machine via a UNC path. I found that it would not work if the SQL server was running using the Local System Account, so I changed it to run using a domain account.
The service started fine and I was able to restore the backup, however every time the computer reboots the sql service cannot start with a "Log In" error. If I go to the service properties and type in the password to the user account again everything works fine.
What could I do to make sure this service can always log in as the domain user and/or is there any way to keep using the Local System Account and still have the capability of accessing the UNC Path?