I'm running SQL Server 2005 Standard Edition on a Windows Server 2003 SP2 Standard Edition.
I have a database in SQL Server used for a program installed on each client of my network.
To access the database, each client has an ODBC connection setup on their machine to connect to the database.
I want the ODBC to use Windows Authentification.
For the Admins on the domain I have no issue to create an ODBC and connect to the database.
But for the "regular" domain users (without Admin rights),
the ODBC won't work (Error: 18456, Severity: 14, State: 11) unless I add each individual username as a user in SQL Server.
I have over 40 clients and I don't want to add the users one at a time in SQL Server.
I was wondering if there is a way to allow all my domain users to connect to SQL Server without adding them one by one?
I hope I was clear enough.