Which procedure should you run?

You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1. You need to configure SQL! to use mixed mode authentication.

Which procedure should you run?
A . sp_addremoteIogin
B. xp_instance_regwrite
C. sp_cnarge_users_login
D. xp_grant_login

View Answer

Answer: B