I need to move a database from one machine to another. I did a backup of a database from my SQL server 2005. I tried to do a restore on my other machine where SQL 2005 is installed (I am using this because the program I use installs this). When I install SQL Studio Express and try to open the database I get access denied. How do I give myself permissions? I cant seems to add myself. Or am I doing this wrong?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.