Multiple Instances is it safe and secure ?

[Alex]

Hi everybody.
One of department want to place db application from one server somewhere else on corparation network for 3 month period.
Problem is they want to keep it with max security.
Company does not want set up another server , so we want to create another
Instance and place database on it.
1. Is safe to keep 2 instances on same server ?
2. How remove access to this instance from members of local and domain admin role(If we deny acces to BuildInAdministrators how it is going to affect security?)
Thank you

[mmwops]

Hi Alex,

It is safe to run 2 instances, however you need a heavy server.
Remove the builtin/administrators from the sysadmin role to disable local and domain administrator access to 2nd instance.
Make sure that the admin accounts that SQLserver and SQLserveragent are using are member of sysadmin on 2nd instance.
Create logins for those clients that need access to 2nd instance. Remember that SQL security is on a per server, per databse basis.



------------
Alex at 2/6/2002 4:13:59 PM

Hi everybody.
One of department want to place db application from one server somewhere else on corparation network for 3 month period.
Problem is they want to keep it with max security.
Company does not want set up another server , so we want to create another
Instance and place database on it.
1. Is safe to keep 2 instances on same server ?
2. How remove access to this instance from members of local and domain admin role(If we deny acces to BuildInAdministrators how it is going to affect security?)
Thank you