One service with multiple databases

Hi all

Is it possible to have one service, which can connect to multiple SQL databases?

We have a SQL server with multiple databases, all with the same schemas, but right now we have to create a new service for each database and therefore also change or add roles. Since all users have the same rights across all databases it would be must easier for us with just one service.

Hope you can help :slight_smile:

  • Christian