I move my database from Test to Prod environment(SQL 2208 Ent.).I just copy paste *.mdf and 8.ldf files and attache the DB.
I created login in production and map with user.
I am seeing in Log following error message.
Login failed for user '<login name>'. Reason: Password did not match that for the login provided. [CLIENT: <IP>]
Though I am able to login DB through app and SSMS.Able to do all activities.
Then why this message occurs every login in log file.
I deleted login and user n created again but it giving me same message
View Complete Post