January 11, 2009 at 11:24 am
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
January 11, 2009 at 11:49 am
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]
January 11, 2009 at 5:18 pm
Check out the properties of your schemas in Management Studio and you may find the problem.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply