Thanks for quick response.
Live server and yes to your other questions. I have another site ( these are live sites not local ) in which the database connection IS working. I know the server setting in DW are correct for the site that's not connecting so I am stumped as to why i cannot connect to the DB. Looks like it's my problem to solve - would you have any ideas on how to solve this?Thanks