Hi there,

Thank you for your reply. Perhaps I should go more into more details about how and why we are using this procedure.

We're using terminal licences because they are rather cost affective and that in the fee that we charge our customers, that cost is included. If we were to use individual virtual machines for each SQL instance, we would need to full Windows licences and that would cost more and we would need to charge the customers a lot more than $35 a month (per user).

Also, we are using SQL 2008 R2 Express, not the commercial version. We are using the free version also for cost measures but also because our mid-version software is only compatible with SQL Express (per design) and since we don't want to separate the SQL servers based on our software version, it's best to use SQL Express since it's compatible for both our mid and high version.

I did think about making generic names for the SQL instances, but it was voted as bad idea due to maintenance time, having to look at a list to see who Cust047 is would be a pain since we already have to look at a 6 digit customer number in our systems to see the customer's name.

As for the user rights, each user has rights on his own SQL instance and although they can't delete a DB from our software (this requires Studio Management), they can create new databases and overwrite an existing one. This is why we needed to have separate instances because they need that freedom and putting everyone on the same instance would have required us to create their DB every time and put in their security group inside to give them the option to open it.

Thank you for your time