How to change SQL Server Authentication Mode by using TSQL Query

-
SQL Server Authentication mode can be changed by using GUI.

Simply click on Server -> Properties -> Security.

There you can change the SQL Server Authentication mode to

1. Windows Authentication mode
2. SQL Server and Windows Authentication mode( Mixed Mode)

You can also use below scripts to check and change the SQL Server Authentication mode:

--Use this to Check the SQL Server Authentication Mode

SELECT CASE SERVERPROPERTY('IsIntegratedSecurityOnly') 
WHEN 1 THEN 'Windows Authentication' 
WHEN 0 THEN 'Windows and SQL Server Authentication' 
END as [SQLServerAuthenticationMode]
------------------------------------------------------------------------------
--To Change to Windows Authentication

USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 1
GO
------------------------------------------------------------------------------
--To change to Mixed Mode( SQL Server and Windows Authentication mode)

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

------------------------------------------------------------------------------
--Finally:
--Please note: After running one of the above query, you have to restart SQL Server and Agent Service.



Comments

  1. atalnetworksOctober 17, 2020 at 9:26 PM

    Very elegantly composed article. It was a magnificent article to peruse. Complete rich substance and completely useful about SQL server. Cheap Dedicated Server

    ReplyDelete
  2. Girls of South Bay HacksJuly 17, 2021 at 8:20 AM

    I am very thankful to you that you have shared this information with us. I got some different kind of knowledge from your web page, and it is really helpful for everyone. Thanks for share it. Read more info about Online Hackathon for Beginners USA

    ReplyDelete
  3. iteducationcentreJuly 30, 2024 at 11:55 PM

    That was very helpful and useful blog.
    SQL training in Pune

    ReplyDelete

Post a Comment

Popular posts from this blog

Python - GUI - Tkinter(Bar & Pie Chart)

-
Image
Quickly, i just want to show you a simple example of creating bar and pie chart with Tkinter . Try this simple example: import tkinter as tk root = tk.Tk() root.title("Tkinter Bar and Pie Graph") #here is for bar chart............ tk.Label(root, text='Bar Chart').pack() data = [21, 20, 19, 16, 14, 13, 11, 9, 4, 3] c_width = 400 c_height = 350 c = tk.Canvas(root, width=c_width, height=c_height, bg= 'white') c.pack() #experiment with the variables below size to fit your needs y_stretch = 15 y_gap = 20 x_stretch = 10 x_width = 20
Read more

Azure SQL, Cloud Migration and Modernization

-
Image
  What is Azure SQL? Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud. Azure SQL Database: Support modern cloud applications on an intelligent, managed database service, that includes serverless compute. Azure SQL Managed Instance : Modernize your existing SQL Server applications at scale with an intelligent fully managed instance as a service, with almost 100% feature parity with the SQL Server database engine. Best for most migrations to the cloud. SQL Server on Azure VMs: Lift-and-shift your SQL Server workloads with ease and maintain 100% SQL Server compatibility and operating system-level access. Azure SQL is built upon the familiar SQL Server engine, so you can migrate applications with ease and continue to use the tools, languages, and resources you're familiar with. Your skills and experience transfer to the cloud, so you can do even more with what you already have. What do you want to do? Suppor
Read more

Bringing Kubernetes to Windows Server apps(Google Cloud Platform)

-
Image
Firstly, before we begin. For those that don't already know. What is Google Kubernetes Engine ?: GKE is an enterprise-grade platform for containerized applications, including stateful and stateless, AI and ML, Linux and Windows, complex and simple web apps, API, and backend services. Leverage industry-first features like four-way auto-scaling and no-stress management. Optimize GPU and TPU provisioning, use integrated developer tools, and get multi-cluster support from SREs. Now that we know GKE, the purpose of this post is about running Windows Server apps as containers on Kubernetes, where you get many of the benefits that Linux applications have enjoyed for years. Running your Windows Server containers on GKE can also save you on licensing costs, as you can pack many Windows Server containers on each Windows node. In the beta release of Windows Server container support in GKE (version 1.16
Read more