I spoke too soon.
I have created a new windows login and added it to the server. The login has minimal rights to run reports.
In report manager I have tried to create a connection where credentials are stored securely, the attached screen shot illustrates what I am getting.