Exam DP-300 topic 7 question 23 discussion

Actual exam question from Microsoft's DP-300

Question #: 23
Topic #: 7

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?

A. sp_addremotelogin
B. xp_instance_regwrite
C. sp_change_users_login
D. xp_grant_login

Show Suggested Answer

Suggested Answer: B 🗳️

by vcloudpmp at July 12, 2023, 10:34 p.m.

Comments

Submit Cancel

vcloudpmp

Highly Voted 1 year, 11 months ago

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

upvoted 6 times

...

bingomutant

Most Recent 8 months ago

looks OK - The xp_instance_regwrite stored procedure is used to modify the registry keys directly for the SQL Server instance, and it's commonly used for enabling mixed mode authentication by setting the correct registry values.

upvoted 1 times

...

vcloudpmp

1 year, 11 months ago

What is mixed mode authentication in SQL? There are two possible modes: Windows Authentication mode and mixed mode. Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication. Mixed mode enables both Windows Authentication and SQL Server Authentication. Windows Authentication is always available and cannot be disabled.Feb 28, 2023 Choose an Authentication Mode - SQL Server | Microsoft Learn Microsoft https://learn.microsoft.com › Learn › SQL › SQL Server

upvoted 2 times

...