September 6, 2012 at 11:42 am
Today I migrated two databases from one SQL Server 2008 R2 instance to another instance on our cluster. I removed all associated jobs and the SQL Server login. I continue to get "Login Failed" messages in the SQL Server Error Log. Can you tell me what I missed in the migration process?
Message
Login failed for user 'vtiger'. Reason: Could not find a login matching the name provided. [CLIENT: 136.150.170.32]
Message
Error: 18456, Severity: 14, State: 5.
I did a tracert and the server that has the IP address in the first message above is the server that is using the database I migrated. I checked the two ODBC connection on this server and they both point to the new instance now.... I do not know what is causing these errors to occur. Any advice would be greatlyl appreciated.
Charlie
September 6, 2012 at 12:02 pm
That user is being used in a connection string somewhere. It could also be in use by somebody who knows the pw to that account. Check to see if anybody might be trying that account from somewhere.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply