First, I am not a SQL DB admin. I inherited this system and working to migrate away from it...that said:
I have an old MSServer2000 SQL DB we migrated to VM. That server offloads data to another SQL Server running server2008 via an SSIS package executed by the 2008 server.
After the migration the SQLSrv2008 SSIS package is not running, and the error log indicates the "login failed for user '(username)'.". However the username was not changed in the SSIS connection string or on the VM (MSSQL2000)? So I have no idea why the SSIS package is having trouble authenticating.
Thanks for any input!