EXPERT RESPONSE
SQL Server 2000 directly supports authenticating users via Windows Authentication. You need to:
- Create an appropriate database role for the users
- Assign appropriate permissions within the database to that role
- Add the windows users (or better – their windows group) to that role
View questions and answers from all of our SQL Server experts here.
|