Today we moved a production database from our sql 2000 server to a sql 2005 server. all went well. EXCEPT we are getting on our sql 2000 server, 'login failed for user <sql user name> . there is nothing else in the message to lead us as to where this message is coming from. We have changed all possible odbc connections on all servers possible. Now this user name 'was' a user to the database we moved. the message occurs ever 5 minutes to the T.
is there anyway for me to find out where this is coming from?
Thank you in advance for any leads !!