locked
Cannot access the specified path or file on the server. RRS feed

  • Question

  • Windows Server OS 2012 R2

    SQL Server Default Instance: SQL Server 2008 (10.0.6241.0)

    SQL Server Named Instance: SQL Server 2014 (12.0.5546.0)

    I just installed SQL Server 2014 SP2 (as named instance) and patched it with CU5 ((12.0.5546.0). When I tried to restore one of our databases (backup from database that is compatible set to SQL Server 2008) using T-SQL, I get

    "Msg 3201, Level 16, State 2, Line 2
    Cannot open backup device '\\svrname\backup\test.bak'. Operating system error 5(Access is denied.)."

    When I tried to restore using the GUI, I get

    "Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.

    If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box."

    1. I know the service account have access because it's using the same service account as the Default Instance on the same server. The restore on Default Instance has no issues.

    2. I have even granted SYSADMIN to the service account on SQL Server 2014 but still getting the same errors.

    3. I have also configured SQL Server Properties, Database Settings, Backup location.

    4. The only way I can restore is copy the .bak file to local server.

    Possibly related to this article? But it looks like SP1 CU8 fixes it. I'm on SP2 CU5.

    What's the issue with SQL Server 2014 that it cannot find that path? How do I fix it?

    Thank you.


    • Edited by Ami2013 Friday, April 28, 2017 6:42 PM
    Friday, April 28, 2017 6:37 PM

Answers

  • Never mind, silly me. Services were not running as the service account.
    • Marked as answer by Ami2013 Friday, April 28, 2017 6:49 PM
    Friday, April 28, 2017 6:49 PM