I am assuming that you are running the task from your client rather than the server? Is that correct? If from the Server, that is a whole different set of troubleshooting
When you add a new task, the default is to have no connection until you add a report. Can you see it adding the connection after you add the report?
If you can do a preview, you should not have trouble having security to get to the connection.