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 |
|
java148
Yak Posting Veteran
63 Posts |
 Posted - 2011-12-07 : 09:31:53
|
| I need to set up a database system for a small company which is in the another city. I want to expose the computer login ID to another person so that he can shut down that PC and restart it. But he doesn't have any permissions to do anything on sql server. how to setup the security role and login ?Thanks |
|
|
sandy123
Starting Member
14 Posts |
Posted - 2011-12-07 : 12:37:26
|
| -remove the BUILTIN/Administrators group to prevent local server administrators from being able to access SQL Server In SQL Server 2005 and earlier,. In SQL Server 2008, the BUILTIN/Administrators group does not exist by default.-give SQL Server service accounts the minimum rights and permissions needed to run the service. local administrator rights are not required, -Configure login auditing so you can see who has succeeded, and failed, to loginsandy |
 |
|
|
java148
Yak Posting Veteran
63 Posts |
Posted - 2011-12-07 : 23:24:09
|
Could you please give me more details about this ?many thanksgive SQL Server service accounts the minimum rights and permissions needed to run the service. local administrator rights are not required, |
|
|
|
|
|
|
how to setup a login ?