Which connection string should you use?

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database.
You need to ensure that the application connects to the database server by using SQL Server authentication.
Which connection string should you use?

You use Microsoft .NET Framework 4.0 to develop an application that connects to a Microsoft SQL Server 2008 database.
You need to ensure that the application connects to the database server by using SQL Server authentication.
Which connection string should you use?

A.
SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=SSPI; UID=sa; PWD=secret;

B.
SERVER=MyServer; DATABASE=AdventureWorks; UID=sa; PWD=secret;

C.
SERVER=MyServer; DATABASE=AdventureWorks; Integrated Security=false;

D.
SERVER=MyServer; DATABASE=AdventureWorks; Trusted Connection=true;

Explanation:
SQL Server autentification using the passed-in user name and password. User ID, Uid, User, Password, Pwd

Connection String Syntax (ADO.NET)
(http://msdn.microsoft.com/en-us/library/ms254500.aspx)



Leave a Reply 0

Your email address will not be published. Required fields are marked *