Please help I am just new to SQL 2005.
I restored a backup copy of Sql 2000 DB to another PC which is running on SQL 2005 it all work fine and then I am having a login issue problem in this. What I do is I Delete the user at the Database level. Create the user at the Server Level and give my DB database permissions under the User Mapping section.
Now after that I try to connect with my front end client or login page
I get the below error message
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(UID)'. Reason: The password of the account must be changed
Please advised what is wrong.
Thank you so much.