You are reviewing an application that accesses a SQL Server database. The application uses the following connection string:

MultipleActiveResultSets=True;Encrypt=True;Persist Security Info=True;
user id=username;password=password;database=northwind;server=dataServer

where username is the SQL Server login and password is the password associated with that account.

You need to minimize the chance that malicious code can access SQL login credentials.

Which configuration string parameter should you set?

 Posted by Rajkatie on 8/31/2012 | Category: ADO.NET Interview questions | Views: 1034 | Points: 40
Select from following answers:
  1. Set Persist Security Info to False.
  2. Set Enlist to False.
  3. Set Encrypt to False.
  4. All Above

Show Correct Answer

Source: | | Alert Moderator 

Comments or Responses

Login to post response