Restrict access to the database

[iamdking]

Hello friends, I am using SQL Server 2005 and want to restrict windows authenticated users from accessing my database. Only SQL Server authenticated users should be allowed to access database. How is it possible? Thanks..

Amit

[Ashfield]

Set the sql server authentication to sqlserver rather than windows.

Bob Ashfield Consultants Ltd

[Wendelius]

You have two choices: 1. create a group (or groups) in Windows (either in domain or locally) and use that group (or groups) for login. 2. use SQL Server authentication. Mika

The need to optimize rises from a bad design. My articles[^]