Thanks for the reply Thom. 

I tried creating a new data source from scratch, and got the same error, "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.". I am scheduled to meet my network team some time this week, will keep you posted.
Thanks
Kaz