Moving database

Question

Moving database

pchiro

SSC Rookie

Points: 27
More actions
March 19, 2018 at 12:34 pm

#410333

I have moved a database from one computer (and server) to another by using a backup copy, and then restoring it on the other using Management studio to restore it on the other machine. This involved making the backup and moving it to the appropriate folder on the new computer. That worked fine, I am able connect to the db in Management Studio, but when I try to connect to the db from Visual Studio, I get an error message that I do not have permission to access the file. Since I am just using Windows authentication I am baffled. In case it makes a difference, I am using SQLExpress and VS Community 2013.
Any help would be greatly appreciated.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

pchiro - Monday, March 19, 2018 12:34 PM
I have moved a database from one computer (and server) to another by using a backup copy, and then restoring it on the other using Management studio to restore it on the other machine. This involved making the backup and moving it to the appropriate folder on the new computer. That worked fine, I am able connect to the db in Management Studio, but when I try to connect to the db from Visual Studio, I get an error message that I do not have permission to access the file. Since I am just using Windows authentication I am baffled. In case it makes a difference, I am using SQLExpress and VS Community 2013.
Any help would be greatly appreciated.

Could you post the full error message you are getting?

pchiro SSC Rookie Points: 27 More actions · Answer 2

I just went in to run it again, to get the exact error, and this time it worked. I had tried it several times with not luck, but accidentally closed VS so I restarted VS and now it works, so problem solved, thanks for the help.

Ron

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

pchiro - Monday, March 19, 2018 1:00 PM
I just went in to run it again, to get the exact error, and this time it worked. I had tried it several times with not luck, but accidentally closed VS so I restarted VS and now it works, so problem solved, thanks for the help.
Ron

Edit: Missed the end of the response.