if you put the ip address in a web browser, does it work?
the web URL you use in the site definition must be one that you can use to browse to the site using a web browser.
When you make a database connection, DW will use that address to connect to the web and test the connection to the DB Server.