Which connection string should you use to connect to MyDB?

You have a SQL Server database named MyDB that uses SQL Server Authentication.
Which connection string should you use to connect to MyDB?

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Johan

Johan

A is correct. You have to pass an username and password with sql server authentication