Share via

How to change Sql Server Windows Authentication to Mixed Authentication by Azure Data Studio

KK 191 Reputation points
2022-08-01T10:55:18.483+00:00

Hello,

As mentioned in the title, how can I change the default windows authentication to mixed authentication using Azure Data Studio?

I could not install SSMS on my local because it kept stucking on the package installation and at last throwing error. Tried a couple of times restart, wiped up regit, clear folder and reinstall. All same results. So I am finally trying to use Azure Data Studio to do the change.

Does anyone have a clue of how to do it?

Thanks in advance.

Azure SQL Database
0 comments
Answer accepted by question author
  1. Erland Sommarskog 128.7K Reputation points MVP Volunteer Moderator
    2022-08-01T12:15:51.273+00:00

    There does not seem any way to do this from the UI in Azure Data Studio. However, as with anything else, SSMS is running a T-SQL batch for the task. Using the Script button in SSMS, I found this batch: 

       USE [master]  
   GO  
   EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2  
   GO

    So just run this from a query window in ADS.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,776 Reputation points
    2022-08-01T12:45:23.9+00:00

    Azure Data Studio does not have all the functionality of SSMS. You need to get SSMS installed.

    What exactly is the error during SSMS installation? What version of SSMS are you trying to install?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.