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 SQL1 to use mixed mode authentication…

The correct answer is B. xp_instance_regwrite. https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/change-server- authentication-mode?view=sql-server-ver16 EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 1;

Submitted by suresh_in· Mar 6, 2026Implement a secure environment

Question

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 SQL1 to use mixed mode authentication. Which procedure should you run?

Options

Asp_addremotelogin
Bxp_instance_regwrite
Csp_change_users_login
Dxp_grant_login

How the community answered

(36 responses)

B
89% (32)
C
8% (3)
D
3% (1)

Explanation

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/change-server- authentication-mode?view=sql-server-ver16 EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 1;

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice