Re: change security mode after installation

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/30/03 

Date: Mon, 29 Sep 2003 20:47:37 -0600

The only other way I know of is through the registry -
change the LoginMode value in
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\
-or-
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\
Change it to 2 on SQL 2000. Change it to 0 for SQL 7.

-Sue

On Mon, 29 Sep 2003 12:34:04 -0700, "HH" <asfd@sadf.com>
wrote:

>Hi All,
>
>I am wondering if there is a way to change SQL
>installation security mode from Windows only to Mixed
>without using EM?
>
>Thanks.

Relevant Pages

  • RE: SecurityException for registry access while opening SQL Connection
    ... It seems that it is a permission issue of the ASPNET account. ... 1.Add the account as a SQL Server Login. ... Registry Monitor logs all calls the to registry. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: mailmerge out of Access 2003
    ... I have been playing around with calling the mailmerge templates by using ... If I change the security of Access to 'low' via Tools ... off their no changes to the registry policy for me. ... prompt only exists because executing SQL can have side effects (e.g. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: mailmerge out of Access 2003
    ... think it changes the registry key, which in theory could not be done on ... registry change, it's another thing that you will probably not be allowed to ... If I change the security of Access to 'low' via ... prompt only exists because executing SQL can have side effects (e.g. ...
    (microsoft.public.word.mailmerge.fields)
  • Re:sql browser on active/active cluster
    ... Upon trying to install SP2, Failed Server Engine to update and remained at ... I had this problem for a while and would from time to time poke at the SQL ... because it was looking first in the x32 location of the registry for SQL ... Precise resolution would be to remove the above registry key (assuming there ...
    (microsoft.public.sqlserver.clustering)
  • RE: sql browser on active/active cluster
    ... Upon trying to install SP2, Failed Server Engine to update and remained at SP1 ... I had this problem for a while and would from time to time poke at the SQL ... because it was looking first in the x32 location of the registry for SQL ... Precise resolution would be to remove the above registry key (assuming there ...
    (microsoft.public.sqlserver.clustering)