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

Summery

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?

 

 

Details

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.

Outcomes