What is a Trusted Connection?
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 … Read more