User Created failed in Create Schema

• Junior_DBA

  SSCrazy

  Points: 2002

  More actions

  July 18, 2008 at 11:09 am

  #188307

  Hi All,

  You could find this question a little silly, but I am using the SSMS and make a copy from one DB host to other, but I got the following error: "Cannot find user 'sa', because it does not exist, Msg 2759, Level 16, State 0, line 1....Create Schema failed due to previous error.."

  Please I create several users in the "security" option, but nothing happend, please some help?

  Thanks.

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  July 18, 2008 at 11:38 am

  #845188

  Is there a login for sa?

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot