Database connection error when target changed

Hello
I’ve successfully been using a database connection, with the target set to our production server.
I’ve installed, configured and tested a local IIS server for development. The project i’ve created in wappler, works great in the browser on both localhost and on the production server.

The issue I have, is creating a second target for localhost development within wappler.
The existing database connection works when the target is set to the production server, fails when using localhost as the target (error attached)image|456x500

If i create a new database connection, whilst the target is set to localhost, and use exactly the same login / pw credentials - the DB test connection works perfectly.

Unsure what to do from here. Any help, greatly appreciated.

Summary:
Existing db connection fails when target is changed to localhost.
Creating a new db connection with the same credentials, works when localhost is the target.