What is a Trusted Connection?

by

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.

More Related Contents:

  1. SQL server query to output the data shown below
  2. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  3. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  4. How to use a variable for the database name in T-SQL?
  5. What is the difference between char, nchar, varchar, and nvarchar in SQL Server?
  6. Missing artifact com.microsoft.sqlserver:sqljdbc4:jar:4.0
  7. Create a view with ORDER BY clause
  8. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  9. INSERT INTO vs SELECT INTO
  10. Why is 1899-12-30 the zero date in Access / SQL Server instead of 12/31?
  11. Date conversion and culture: Difference between DATE and DATETIME
  12. Why does select SCOPE_IDENTITY() return a decimal instead of an integer?
  13. How to remove accents and all chars a..z in sql-server?
  14. RODBC odbcDriverConnect() Connection Error
  15. Calling an API from SQL Server stored procedure
  16. Escape Character in SQL Server
  17. Is there a way to not use square brackets in SQL Server?
  18. Retrieve data from stored procedure which has multiple result sets
  19. Use of Begin / End Blocks and the Go keyword in SQL Server?
  20. How do you set autocommit in an SQL Server session?
  21. Ampersand (&) operator in a SQL Server WHERE Clause
  22. Avg of float inconsistency
  23. how to write number to word function in sql server [closed]
  24. Milliseconds wrong when converting from XML to SQL Server datetime
  25. Using GROUP BY with FIRST_VALUE and LAST_VALUE
  26. How to set value to variable using ‘execute’ in t-sql?
  27. Taking the second last row with only one select in SQL Server?
  28. What is the difference between Cartesian product and cross join?
  29. How to Bulk Insert from XLSX file extension?
  30. Count number of records returned by group by

Leave a Comment