Okay, I am not sure what would have been local host. The root path in the image below I removed from the testing server and I recreated the connection and all tables now now. However, I'm getting an inaccessible usr folder created each time I connect to the site in DW.