I have been trying for 2 days to setup my system to use iPad (RDP setup). But now I encounter issue whereby I cannot migrate from SQL Single Local DB to the SQL Server:
Previosly I’m using the SQL Single Local DB
I installed the SQL Server 2012
Using the database backup module, I tried to restore my single DB database to my new SQL Server environment but following error shown up:
Oh… Thanks for the quick reply. Hmm should I uninstall the 2012 and reinstal with 2014?
Sorry if it become out of topic. I also patch the windows 7 professional to be able to accept concurent rdp. But whenever I try to connect the rdp session, it terminate me immediately. Any similar case?Thank you
And then I thicked the database backup module setting that said about to overwrite the database name or something. And when I tried to restore, this error shown up:
To those who experiencing the same issue as me. You can fix the error by restoring the database backup using the SQL Server Management Studio, and when restoring, select “files” on the left panel and choose to set your “Restore As” folder to generic folder like C:\SambaPOS Database\ instead of inside your C:\Users.
You beat me to it - good to hear you figured it out.
The error message is due in particular to the fact that the application (SSMS) does not have permission to the User’s folder, thus the Access Denied error message.
The reason you run into this issue is because LocalDB installs the DB files to a users folder - it is after-all a single-user database by design.
When you install SQL Server Express, it sets the data folder to a path that it can access, so you don’t really ever see this issue crop up when backing up or restoring.