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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2007-07-28 : 08:00:36
|
| Most of our connections to SQL are through SQL Logins and management want to change to NT Logins which is good as it is easy to implement as i can assign developers to NT Logins.In active Directory the web guy tells me in order for web pages to work the AD account has to be a service account and then you have groups and assign the people to the group...the group is then assigned to the service account. In SQL I be using the Service Account ...Is that correct....i use Service Account rather than the Group in SQL Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-28 : 13:51:25
|
| You need create sql login for whatever windows account that needs sql access. If app connects to sql with service account, that's what you need. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2007-07-29 : 06:33:21
|
| Thanks i was not sure if best using group or service account as the web guy could use both....What is best for security |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-29 : 22:36:05
|
| Depends on app requirement. |
|
|
|
|
|
|
SQL logins and NT Logins