SQL 2005 Express Backup/Restore from UNC path

Posted on 2009-02-19
Last Modified: 2012-05-06
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?
Question by:dtsmith1984
    LVL 25

    Accepted Solution

    Is there a chance that there are login/policy scripts being applied to the user account used currently for the SQL Server service that are perhaps interfering with the service using the account?

    You should ideally be using a domain non-interactive user account for running the SQL Server service..
    LVL 57

    Expert Comment

    by:Raja Jegan R
    Go to SQL Server Configuration Manager and choose SQL Server service and right click on it. Choose Properties and then choose the Log on Tab. Provide the credentials which you provided there to connect that UNC path.

    Kindly type services.msc in RUN prompt, and check whether SQL Server Service is set to Automatic so that if Server restarts it will not fail back.

    Author Comment

    Well I still cannot get it working.  I recently had some SQL Server Updates and they were all failing because the service would not restart during the installation so I had to switch these computers back to using Local System Account for the SQL service.

    reb73:  How can I tell if a login or policy script is in fact interfering?  And also,  how would I go about creating a "domain non-interactive user account" ?


    Author Comment

    Anybody else have any ideas?

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Can I legally transfer my OEM version of Windows to another PC?  (AKA - Can I put a new systemboard in my OEM PC?) Few of us are both IT and legal experts but we all have our own views of Microsoft's licensing rules and how they apply.  There are…
    If you are a user of the discontinued Microsoft Office Accounting 2008 (MSOA) and have to move to a new computer running Windows 8, you will be unhappy to discover that it won't install.  In particular, Microsoft SQL Server 2005 Express Edition (SSE…
    This video discusses moving either the default database or any database to a new volume.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now