Create Trusted SQL Server Connection String

Question

Hi friends I want to know how to create trusted SQL Server connection string. Thank you.

Jignesh Trivedi · Answer

Hi Add Integrated Security=SSPI; or Trusted_Connection=Yes (Windows authentication only) in your connection string. please refer http://msdn.microsoft.com/en-us/library/ff647396.aspx http://www.sqlteam.com/article/sql-server-connection-string hope this will help you.

Vulpes · Answer

These links shows how you can create a trusted connection to SQL Server 2005 or 2008 when using various providers: http://www.connectionstrings.com/sql-server-2005 http://www.connectionstrings.com/sql-server-200 8 As you'll see including Integrated Security=SSPI; or Trusted_Connection=True; in the connection string generally suffices.