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, PwdConnection String Syntax (ADO.NET)
(http://msdn.microsoft.com/en-us/library/ms254500.aspx)