This post describes changing Window Authentication mode to Mixed Authentication mode in SQL Server. When you install SQL Server by default window authentication is installed If you do not choose mixed authentication at the time of SQL Server installation. However these modes can be changed even after installation of SQL Server.
Step 1 : Start Query Express.exe/SQL MANAGEMENT STUDIO .
NOTE : You can find queryexpress.exe in application path of RELYON products
- Connect to an instance of Database Engine.
- Copy and paste the following queries into the query window and click Execute.
USE [master]
GO
EXEC xp_instance_regwrite N’HKEY_LOCAL_MACHINE’, N’Software\Microsoft\MSSQLServer\MSSQLServer’, N’LoginMode’, REG_DWORD, 2
GO
ALTER LOGIN [sa] ENABLE
GO
ALTER LOGIN [SA] WITH PASSWORD = N’YOURPASSWORD’
GO
Step 2 : Restart SQL server service.
