What is a Trusted Connection?

Sql ServerTrustedconnection

Sql Server Problem Overview

What is a trusted connection in terms of SQL Server 2005 (Trusted vs Windows Auth)?

Sql Server Solutions

Solution 1 - Sql Server

A trusted connection is the same thing as using Windows Authentication in SQL Server 2005. Authentication is done by the domain, and authorization is handled by SQL Server.

SQL Server can also use its own logins, such as the sa user. These are both authenticated and authorized by SQL Server. They are only viable if SQL Server is run in Mixed Authentication Mode.

MSDN has a good article about choosing the right Authentication Mode. It's a good primer.

Solution 2 - Sql Server

A Trusted connection means Windows Authentication (i.e. a Windows login).

SQL Server has two Authentication modes: Mixed and Windows Authentication Mode.

Mixed has the option of SQL server logins (username and password) and Windows Authentication.

Categories
Recommended Sql Server Solutions

Previous Solution:

Getting an iPhone app's product name at runtime?

IosIphone

Next Solution:

How do you run multiple programs in parallel from a bash script?

BashParallel Processing

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionCsharpView Question on Stackoverflow
Solution 1 - Sql ServerEricView Answer on Stackoverflow
Solution 2 - Sql ServerMitch WheatView Answer on Stackoverflow