I have a dedicated SQL server that is setup as a service in DNP. I assigned that SQL service to a virtual server that is linked to a customer VPS. The customer then installed SQL Server on their VPS.
I added the SQL service to the VPS server in DNP, then deleted the dedicated SQL servise from the virtual server and added the VPS SQL service.
When I go into his account and add a SQL db, it is still being added to the dedicated SQL server, not the VPS SQL Server.
I hope this makes sense.