Re: Changing authentication mode
From: Jasper Smith (jasper_smith9_at_hotmail.com)
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
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
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" <firstname.lastname@example.org> wrote in message news:email@example.com... > 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.