You use Microsoft .NET Framework 4 to develop an application that connects to a Microsoft SQL
Server 200B 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=AdventureUorks; Integrated Security=SSPI; UID=sa; PWD=secret
B.
SERVER-MyServer; DATABASE-AdventureWorks; UID=sa; PWD=secret
C.
SERVER-HyServec; DATABASE-AdventureUocks; Integrated Security=false
D.
SERVER-HyServer; 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)