July 13, 2011 at 6:09 am
I selected ‘Windows Authentication’ mode while installation. Can we make it ‘Mixed’ after installation?
July 13, 2011 at 6:16 am
Yes, you just have to connect as sysadmin and change that setting in the server properties dialog, under the "Security" applet.
You can also change it in the registry, but I can't remember how. If you need I can research it.
-- Gianluca Sartori
July 13, 2011 at 6:28 am
rehansql (7/13/2011)
I selected ‘Windows Authentication’ mode while installation. Can we make it ‘Mixed’ after installation?
I did sometime back now i not remember fully.
Go to the server property security -->change it mixed mode restart the sql
right click the sa login-->status enable it.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
July 13, 2011 at 1:36 pm
Here is the T-SQL command to change it to Mixed:
USE [master]
GO
EXEC xp_instance_regwrite
N'HKEY_LOCAL_MACHINE',
N'Software\Microsoft\MSSQLServer\MSSQLServer',
N'LoginMode',
REG_DWORD,
2 -- 1 = Windows Auth only; 2 = Mixed
GO
It will say 0 rows affected when you run the query but it changes the setting. You have to restart the instance after to get the changes to take effect with all methods.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply