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
A is correct. You have to pass an username and password with sql server authentication
2
0