" Weekly multivitamin for programmers "

© 2013 . Powered by Blogger.

Database Engine service could not resolve the specified file location

By Deep Posted On Monday, October 11, 2010 // 4 comments

Have you encountered this error message while trying to back up or restore a sql database from or to your local instance  from/to remote location or network drive ??



The message specified here is quite clear that
  1. Either location does not exist  (I know you can see the drive folder open, just make sure path spellings you are entering into sql backup/restore wizard are correct)
  2. Current login account does not have access to it. (yea, i know you can access the remote network folder (where you want restore or back up from) in windows explorer using the same login (generally windows login and you are connected to local sql server instance using same windows login)
So where is the problem ?


If your network protocols are enabled liek TCP/IP  then check


Go to control panel -> services OR open run command and type services.msc
This brings you list of all the services running on your current machine. Look for SQL Server in that list and right click and open properties





Now make sure that you have same account/credentials specified here (which have access to network folder). Restart sql server using same dialog here (under general). Done

PS: It does not matter if you have express edition or standard or enterprise edition of sql server. It does not matter if  Sql Agent is installed or not or running or not
Labels:

4 comments:

  1. AnonymousNovember 16, 2010 at 1:42 PM

    Thanks, this was what i was looking for

    ReplyDelete
  2. AnonymousNovember 30, 2012 at 5:23 AM

    Exactly what i needed! thanks alot!

    ReplyDelete
  3. AnonymousOctober 1, 2013 at 5:19 AM

    Perfect! Thank you.

    ReplyDelete
  4. AnonymousJanuary 28, 2014 at 2:11 AM

    Thank you, this helped me.

    ReplyDelete