Permission issues when restoring a 2000 DB onto a 2005Exp box

• Joel Cogley

  Newbie

  Points: 1

  More actions

  April 9, 2009 at 9:13 am

  #384333

  Hey everyone,

  I've got a data migration for a website refresh next week, and I'm trying to do some dry runs on my local 2005 Express DB. I've restored backups from our production DB (running MS 2000), and I can query against it without a problem. However, when I try to set the IDENTITY_INSERT for a table, I get the following error:

  Cannot find the object "DBName.dbo.Table" because it does not exist or you do not have permissions.

  I've tried updated the User Mappings of the 'sa' account (the one I'm using), to include the restored databases (and set the database role membership to db_owner, but I get the error:

  Cannot use the special principle 'sa'.

  Does anyone have any suggestions?

  Thanks in advance!

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  April 10, 2009 at 6:38 am

  #975710

  error: Cannot use the special principle 'sa'.

  Are you use Windows authentication, if so sa is disabled by default.

  Use "Mixed Mode" authentication.

  Tanx 😀