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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 NT auth - setup group?

Author  Topic 

qwertyjjj
Posting Yak Master

131 Posts

Posted - 2007-09-19 : 07:43:04
Usually, we set up a SQL login for an applucation to use.
On this occasion, the connection is being done through NT authentication.
I am having to set up a login for each DOMAIN\user.

Is there a better way of doing this maybe a logn for a group and add the users to the group?

I assumed SQL login was the preferred way as if you designed an app for thousands of users, you would have a large amount of administration if everything was done through NT ?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-19 : 23:05:48
You can create group in domain and create sql login for the group, then just add domain account into that group.
Go to Top of Page
   

- Advertisement -