Re: Changing authentication mode
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 05/06/03
- Previous message: Richard Walker: "Changing authentication mode"
- In reply to: Richard Walker: "Changing authentication mode"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 6 May 2003 07:47:36 +0100
You need to restart the SQL Service for this to take effect. You
can check the following registry key to make sure it has been changed
Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
to 2 for mixed-mode or 1 for integrated
-- HTH Jasper Smith (SQL Server MVP) I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Richard Walker" <rwalker@custman.com.au> wrote in message news:011401c31398$1a258890$a001280a@phx.gbl... > I want to change the authentication mode for an SQL server > from Windows Only to SQL Server And Windows. When I make > the change then click OK, then go back into the server > properties, it's reverted back to Windows Only. > > Anything I'm missing here?? This is one of two SQL Servers > currently active on our network.
- Previous message: Richard Walker: "Changing authentication mode"
- In reply to: Richard Walker: "Changing authentication mode"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
