<div>
<div class="content wysiwyg-content">
Ive got a Windows 2k3 SBS with MSSQL on it with Windows Authentication enabled. &nbsp;There is a database which programA uses and it all works correctly. &nbsp;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.<br />
<br />
4 out of 5 users can access the DB fine using win auth and the program has no issues, the 5th users cannot. &nbsp;4 users are a member of Domain Admins, the 5th is not.<br />
<br />
How can I tell MSSQL to allow Domain Users to access the DB's/SQL Server?
</div>
</div>


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?

MSSQL Windows Authentication Permissions on Win2k3 SBS

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).