PrepAway - Latest Free Exam Questions & Answers

Which connection string should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

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)


Leave a Reply