I have been moving my Databases from SQL 2000 to SQL 2005. I use following steps
Make a back up of DB in 2000 on Server A. Restore the Backup file in 2005 on server B.
The problem I am having is when user try to odbc connection to SQL server 2005 on server B they are getting error
SQL State: '28000'
On the SQL server event Log it says "Error: 18456, Severity: 14, State 11"
I am unable to connect using windows authentication but if i use SQL Server Authentication and give the user id and password for "SA" account I am able to connect.
Any help will be appreciated