Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pmanyara
Starting Member
5 Posts |
 Posted - 2008-03-25 : 08:33:21
|
| Dear Colleagues,How do I install a Microsoft SQL Server 2005 database application in an existing server in an existing database server and still have the control over it and also restrict the new server Admin user from editing or even opening my DB. Any modification of my database or code should be implemented only by me. Is it possible to remove the Builtin Admin from the server role?? As in my case, there is no need for anyone else to open the DB in Management Studio at all as my VB application does all that is required.Thanks and best regards,Peter |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
|
|
pmanyara
Starting Member
5 Posts |
Posted - 2008-03-25 : 10:07:58
|
quote:
Originally posted by elancaster
didn't you get an answer here?http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99027Em
I did not get an answer for this question from the link above. That was a different question which I'd asked first and got a good answer from another poster.Thanks, P |
 |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-03-25 : 10:18:26
|
| well, as stated in your other post... you can and should remove the builtin\administrators from sysadmin role, you cannot stop sysadmin from having access to your DB. if you really need to stop any access other than your app, i'd consider a new / seperate instanceEm |
|
|
|
|
|
|
Implementing DB Security in Existing Server