Worked it out again guys - not long after posting on here.

I enabled remote errors. - see here on how to do this -

https://www.youtube.com/watch?v=PLIDL0FLkqI

Then this changed the error to basically say that the service id that connects to the datasources didn't have access to the database that I was trying to connect to. Doh!