AnsweredAssumed Answered

Can't restore Database, Permission Denied - going from Server 2008 to 2012

Question asked by John Huntington on May 7, 2015
Latest reply on Sep 21, 2015 by John Huntington


Trying to move EPDM 2014 from a server 2008 to 2012 R2, same server different Hard Drives.  When I try to restore the data base I get a permission denied error, what would be causing this?




We have EPDM 2014, I wanted to go to 2015 but it won't install on server 2008, so I got a new HD and installed server 2012 R2.  Knowing little about SQL I used the help file and backed up my databases from SQL 2008.  On the new OS I installed SQL 2014 from my EPDM 2015 CD, apparently you can't restore a 2008 database to 2014.  I then installed SQL 2008 from my EPDM 2014 CD but I am getting a permission denied error.  I am installing as administrator and everything is pretty much identical on the sever from the 2008 OS such as the computer name and passwords.


  • Steps I took
  • Backed up EPDM as per Help File instructions
  • Installed New HD on the server
  • Removed old HD
  • Installed Server 2012 R2
  • Updated OS via MS update wizard
  • Installed SQL 2014 off  PEDM 2015
  • Installed SQL 2008
  • Logged into SQL management Studio
  • Tried to Restore Database
  • Got Permission Denied error


I am not sure what I am missing or doing wrong, for now I am back on server 2008 EPDM 2014 until I get some ideas how to fix this, this means I will be making a new copy of the Database when I attempt this again.