Thanks for the help welsh, I'll give it a try now and see what I get. I do set the "Run As" to "SQL Server Agent Account Service", but when...

Any new suggestions on how I would be able to fix that connection issue with the server that I've posted before, I have exhausted a lot of options, just wondering...

I did a lot of changes on package rights and on what user runs the package, I'm kind of stuck now because I can't remember how or where I changed...

I redid the job, calling the proxy in the Run As section and even declaring the datasources for all of the package datasources in the "DataSources" tab in the Job...

Woops I forgot to add that one to the list. Its attached now.

I have attached JPEG files that show my configurations. Let me know if there is any other things you want to see as far as my configurations go.

I just tested to see if I could make my user the only user and I can, but I don't know what you're next suggested course of action would be...

Local System is the account running the SQL Server Agent (MSSQLSERVER)

Is there something else I should change it to? Maybe to my account name instead (Don't know if that is...

I know why my username doesn't show up, its because my username is sysadmin already and users with sysadmin rights automatically have access and thus won't show up on the...

Posted the same reply twice because I thought it didn't post the first time. :hehe:

I keep on finding something strange when I'm trying to add my username as a SQL Login in the "principals" section of the proxy settings. This is how it goes,...

I keep on finding something strange when I'm trying to add my username as a SQL Login in the "principals" section of the proxy settings. This is how it goes,...

That link you sent in your last post is one that I was looking at earlier to verify what I was doing earlier, but I created a new proxy, checked...

Yeah I know what you mean, but after spending too much time on this issue it sure feels that way 😛

I'm going to spend some time making sure my settings...

Ok, I see where you are getting it, you might be right, when I run the job manually it runs fine because its running under my user because obviously I'm...