What is a trusted connection in terms of SQL Server 2005 (Trusted vs Windows Auth)?
Asked
Active
Viewed 1.1e+01k times
78
-
11For google travellers, format of conn string is
– fiat Mar 18 '14 at 10:25 -
1@fiat also https://www.connectionstrings.com is very handy – Jan 15 '19 at 14:00
2 Answers
78
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.
Eric
- 92,005
- 12
- 114
- 115
-
3@Mitch: My highest voted answer ever is that difference. How sad is that? http://stackoverflow.com/questions/1045107/what-different-terms-mean-the-same-thing-or-dont-but-people-think-they-do/1049435#1049435 – Eric Aug 09 '09 at 03:59
19
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.
Mitch Wheat
- 295,962
- 43
- 465
- 541