Cannot open database requested by the login error

• Vertigo44

  SSCarpal Tunnel

  Points: 4055

  More actions

  March 23, 2011 at 8:49 am

  #104051

  I copied .bak and .trn files over to my local server.

  I then restored the database on my local server under a different name to the time when all the data was still in the table.

  I am now trying to use the import/export wizard to export the data from the table and place it back into the production databse but I keep getting this error above?

  I then added myself (domain/user account) to the local restored database under security >> users. Still haven't had any luck. What am I missing here?

• Meet George Jetson

  SSChampion

  Points: 11638

  More actions

  March 23, 2011 at 10:27 am

  #1302585

  Make the login you are wanting to use the db_owner

  Chris Powell

  George: You're kidding.
  Elroy: Nope.
  George: Then lie to me and say you're kidding.