Fixed.

I tried the configuration without "Authentication" set on and it worked.
It was because it is using a trusted account.

Couldn't of twigged it without your help. Thank you.