SQL Server authentication mode

  • Thread starter Thread starter vivek
  • Start date Start date
V

vivek

Hi,

Can anyone help me in setting the SQL Server
authentication mode to Mixed mode?

From where can I change these settings?

Thanks
 
In Enterprise Manager, right click on the Server Instance name and you can
set it from the dialog box.

HTH,

Bill
 
Hi, you can make a .vbs file like this, so if you haven't SQL console
manager but only MSDE it works:

dim oMSDEserver
set oMSDEserver = CreateObject("SQLDMO.SQLServer")
oMSDEserver.LoginSecure = True
oMSDEserver.connect "SERVER\INSTANCE"
oMSDEserver.integratedSecurity.SecurityMode = 2
oMSDEserver.disconnect

p.s. I think you have to restart SQL server after.
 
Back
Top