You have a SQL Server database named MyDB that uses SQL Server Authentication.Which connection string should you use to
Posted: Thu Oct 20, 2022 2:48 pm
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. 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