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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-12-19 : 05:55:16
|
| Dear All,we are planning to change the sql server 2005 server into windows authentication mode. we have around 300 users.1)can i make them a group?2)if so, i'l create a role named myrole with the previleges read, write, and execute sp permissions.3) i'd like to assign the rule to the group. so that i can get more secured environment.please correct me where ever i was wrong, and provide me guidance to do thisArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
JamesRyan
Starting Member
18 Posts |
Posted - 2008-12-19 : 06:37:07
|
| This should help....-Configure SQL Server to use Windows authentication mode-group users into different global groups in the domain-Consolidate these global groups from all the trusted domains into the Windows NT/2000 local groups in your SQL Server computer-The Windows local groups are then granted access to log into the SQL Server-Add these Windows NT/2000 local groups to the required fixed server roles in SQL Server-Associate these local group logins with individual user accounts in the databases and grant them the required permissions using the database roles-Create custom database roles if required, for finer control over permissionsJames Ryanwww.sqlhowto.co.uk |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-12-19 : 06:40:28
|
SQL Server 2005 IS always configured to use Windows authentication mode - isn't it?Webfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
JamesRyan
Starting Member
18 Posts |
Posted - 2008-12-19 : 07:07:04
|
| You use windows auth if possible, but you can use SQL logins (they are mainly used for legacy apps which dont support windows authentication)James Ryanwww.sqlhowto.co.uk |
|
|
|
JamesRyan
Starting Member
18 Posts |
Posted - 2008-12-19 : 07:08:28
|
ignore me WebFred, just re read your post!  James Ryanwww.sqlhowto.co.uk |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-22 : 00:53:04
|
| Nicely Explained James Ryan...thanks for the time...exactly you have the given the explanation what i'm expectingArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
users grouping