You have a SQL Server database named MyDB that uses SQL Server Authentication.
Which connection string should you use to connect to MyDB?
A.
Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales
B.
Data Source=MyDB; Integrated Security=SSPI; Initial Catalog=Sales
C.
Data Source=MyDB; Integrated Security=True; Initial Catalog=Sales
D.
Data Source=MyDB; Trusted_Connection=True; MultipleActiveResultSets=True; Initial
Catalog=Sales
Answer should be B
https://msdn.microsoft.com/en-us/library/ms228094(v=vs.85).aspx
It is A. The connection here is based on SQL authentication not just on sql data source.
https://msdn.microsoft.com/en-us/library/ff648340.aspx
I think A, SQL Authentication requires SQL password, not Windows authentication (computer log-on)