Trusted Connection Setup - SQL Server 2008

To setup a trusted connection

1. Open SQL Server Management Studio
1.1 Login to the correct SQL Server Instance as SA
2. Right click on Security
2.1 Create new user (make sure to select windows authentication
3. Apply the correct security to the user
4. Give user access to the correct DB's

Trusted conenction is needed for users to access the database especially via Excel Data Sources.