[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Issue connecting ODBC to SQL Server 2005

Hi,

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.

Thank you,
0
nicolas-cableorganizer
Asked:
nicolas-cableorganizer
1 Solution
 
Chris LuttrellSenior Database ArchitectCommented:
One thought would be to add a login to SQL Server for "NT AUTHORITY\Authenticated Users" and grant access to your database objects to that login.  This will lump all users together.  If that is not ok and/or a more secure solution would be to create one or more groups on the machine or domain, grant those groups appropriate db access and put the users in there.  It would still mean you have to add each new user somewhere, but it would be outside of SQL.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now