I will first explain the senario.
The client has given me SQL Server Authentication by creating a login in that server through SQL Server Management Studio. He has also given me sysadmin Server Role. But I am not the Administrator in that system, I mean which can be given clicking the properties of My Computer and then clicking on Manage.
I am trying to execute the job in that server with my SQL Server Authentication. But it is giving me the error that login failed for the user that is me.
I tried changing the protection level to DontSaveSensitive. Running the package through the Config files which stores all the connection strings. But still I am getting the same error.
I believe untill I become the Administrator in that server I wont be able to execute the job.
Can you guys put some more inputs into that and also correct me if I am wrong.