MSSQL Windows Authentication Permissions on Win2k3 SBS
Posted on 2008-01-30
Ive got a Windows 2k3 SBS with MSSQL on it with Windows Authentication enabled. There is a database which programA uses and it all works correctly. ProgramA uses individual windows auth to connect to the db and has its own internal security permissions for users built in to the app/db.
4 out of 5 users can access the DB fine using win auth and the program has no issues, the 5th users cannot. 4 users are a member of Domain Admins, the 5th is not.
How can I tell MSSQL to allow Domain Users to access the DB's/SQL Server?