I recently installed SQL Server on a Windows 2008 machine. Down the line the machine was renamed from and when I recently deployed and executed a SSIS package I got the following error message:
The job failed. Unable to determine if the owner (IP-0AC455TA\Administrator) of job Package has server access (reason: Could not obtain information about Windows NT group/user 'IP-0AC455TA\Administrator', error code 0x534. [SQLSTATE 42000] (Error 15404)).
I assumed this was because of the "old" Administrator name. So logged into SQL Server using the "sa" account and navigated to Security\Logins and removed the IP-0AC455TA\Administrator user. I then re-added the NewName\Administrator account and set it as sysadmin.
This did the trick BUT is it the proper way to do it? I want to make sure that by doing it this way I did not break anything that I don't know of yet. Also, I only created one database on the server and that database is not using any built in administrator accounts.