Login Failed for sa

• yameen_mohd_khan

  Valued Member

  Points: 71

  More actions

  January 11, 2009 at 11:24 am

  #195855

  I installed SQL Server 2008 Restored a databse from earlier 2005 Server. Able to connect Database Engine with user 'sa' but the applications throws error "Login Failed for user sa". Checked the Database owner it is 'sa' if i tried to map sa from security it says dbo already exists cannot drop the user dbo to re map.

  Please advise iam going hell of it from 2 days.........

  Thanks

  Yameen

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  January 11, 2009 at 11:49 am

  #925031

  I would presume that the Applications have the wrong password for SA. Passwords for SQL Logons are not stored in the application/user databases.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• vbguy-978122

  Mr or Mrs. 500

  Points: 508

  More actions

  January 11, 2009 at 5:18 pm

  #925073

  Check out the properties of your schemas in Management Studio and you may find the problem.