Microsoft
70-516 · Question #172
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…
The correct answer is B. SERVER=MyServer; DATABASE=AdventureWorks. SQL Server autentification using the passed-in user name and password. User ID, Uid, User, Password, Pwd Connection String Syntax (ADO.NET)
Implementing Data Access
Question
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?
Options
- ASERVER=MyServer; DATABASE=AdventureWorks;
- BSERVER=MyServer; DATABASE=AdventureWorks;
- CSERVER=MyServer; DATABASE=AdventureWorks;
- DSERVER=MyServer; DATABASE=AdventureWorks;
How the community answered
(32 responses)- A3% (1)
- B84% (27)
- C3% (1)
- D9% (3)
Explanation
SQL Server autentification using the passed-in user name and password. User ID, Uid, User, Password, Pwd Connection String Syntax (ADO.NET)
Topics
#connection strings#SQL Server authentication#ADO.NET#security
Community Discussion
No community discussion yet for this question.