Cannot use the special principal 'SA'

• SSW

  Old Hand

  Points: 351

  More actions

  November 28, 2007 at 2:01 pm

  #201355

  I just finished a sql server upgrade and have 6 or so databases working correctly in 2005. The upgrade was from 2000. I have one nasty database left that no matter what I do spits out the following error:

  Cannot use the special principal 'SA'

  Can you help? I am stuck!

• GRE (Gethyn Ellis)

  SSCrazy Eights

  Points: 9602

  More actions

  November 28, 2007 at 3:46 pm

  #755174

  Have you configured the new 2005 for "Mixed Authentication" If your new server is configued for Windows authenication you will get this message.

  Gethyn Elliswww.gethynellis.com