You are implementing a WPF application that must access data from a SQL Server database named northwind on server dataServer. You need to connect with a trusted connection that uses the identity of the currently logged-on user.

Which connection string should you choose?

Set the Integrated Security parameter to SSPI to create a trusted connection - that is, one for which the current Windows account credentials are used for authentication.

A connection string must set Integrated Security to SSPI or include a user and password. The given connection string that omits both is invalid. Setting Persist Security Info to False or No (strongly recommended), causes security-sensitive information, such as the password, to not be returned as part of the connection if the connection is open or has ever been in an open state. This is unrelated to authentication credentials.