Mixed Mode Authentication

Hi folks,
I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
am trying to install project server 2003. Project server tells me that my
SQL server must be in Mixed mode to complete the installation.
The problem is that the server which was installed with "Windows Only" will
not switch to "Windows and SQL". I have restarted the services and still no
joy, what else can I do to change to mixed mode?
thanks
DaveWhat do you mean it wont switch? Do you get an error
message? If so, would you like to share it with the rest
of the class?
>--Original Message--
>Hi folks,
>I have a microsoft SQL server 2000 on a Windows 2003
Server on my network, I
>am trying to install project server 2003. Project server
tells me that my
>SQL server must be in Mixed mode to complete the
installation.
>The problem is that the server which was installed
with "Windows Only" will
>not switch to "Windows and SQL". I have restarted the
services and still no
>joy, what else can I do to change to mixed mode?
>thanks
>Dave
>
>.
>|||David,
Is SQL Server a local administrator on the machine? Does it have access
to the registry? This state is stored in the registry, and if SQL Server
doesn't have write permission to the registry it could fail.
The registry key is
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQLServer\<instance_name>\MSSQLServer\LoginMode
The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
may still see 0 for SQL Server only (servers upgraded from 6.5).
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Hi folks,
> I have a microsoft SQL server 2000 on a Windows 2003 Server on my network, I
> am trying to install project server 2003. Project server tells me that my
> SQL server must be in Mixed mode to complete the installation.
> The problem is that the server which was installed with "Windows Only" will
> not switch to "Windows and SQL". I have restarted the services and still no
> joy, what else can I do to change to mixed mode?
> thanks
> Dave
>|||No error.
I select mixed mode on the server properties then once I've restarted the
services I go back in to server properties and "Windows Only" is still
selected, it won't switch!
I'm new to SQL so be gentle :)
Dave
"ChrisR" <anonymous@.discussions.microsoft.com> wrote in message
news:2bcbf01c46824$3b95a230$a301280a@.phx.gbl...
> What do you mean it wont switch? Do you get an error
> message? If so, would you like to share it with the rest
> of the class?
>
> >--Original Message--
> >Hi folks,
> >
> >I have a microsoft SQL server 2000 on a Windows 2003
> Server on my network, I
> >am trying to install project server 2003. Project server
> tells me that my
> >SQL server must be in Mixed mode to complete the
> installation.
> >
> >The problem is that the server which was installed
> with "Windows Only" will
> >not switch to "Windows and SQL". I have restarted the
> services and still no
> >joy, what else can I do to change to mixed mode?
> >
> >thanks
> >Dave
> >
> >
> >.
> >|||Hi Mark,
thanks for that, your correct, the currently logged on user which I thought
was part of the local administrators group isn't.
oh the joys
thanks
Dave
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||Just thought of something there, what do you mean is the "SQL Server" a
local administrator on the machine?
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> David,
> Is SQL Server a local administrator on the machine? Does it have access
> to the registry? This state is stored in the registry, and if SQL Server
> doesn't have write permission to the registry it could fail.
> The registry key is
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> SQLServer\<instance_name>\MSSQLServer\LoginMode
> The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> may still see 0 for SQL Server only (servers upgraded from 6.5).
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Hi folks,
> >
> > I have a microsoft SQL server 2000 on a Windows 2003 Server on my
network, I
> > am trying to install project server 2003. Project server tells me that
my
> > SQL server must be in Mixed mode to complete the installation.
> >
> > The problem is that the server which was installed with "Windows Only"
will
> > not switch to "Windows and SQL". I have restarted the services and still
no
> > joy, what else can I do to change to mixed mode?
> >
> > thanks
> > Dave
> >
> >|||David,
What I meant was, is the Windows Domain Account that the MSSQLServer
service logs on under, a member of the Local Administrators group on the
server.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
David Hodgson wrote:
> Just thought of something there, what do you mean is the "SQL Server" a
> local administrator on the machine?
>
> "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
>>David,
>>Is SQL Server a local administrator on the machine? Does it have access
>>to the registry? This state is stored in the registry, and if SQL Server
>>doesn't have write permission to the registry it could fail.
>>The registry key is
>>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
>>SQLServer\<instance_name>\MSSQLServer\LoginMode
>>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
>>may still see 0 for SQL Server only (servers upgraded from 6.5).
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602.html
>>
>>David Hodgson wrote:
>>Hi folks,
>>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> network, I
>>am trying to install project server 2003. Project server tells me that
> my
>>SQL server must be in Mixed mode to complete the installation.
>>The problem is that the server which was installed with "Windows Only"
> will
>>not switch to "Windows and SQL". I have restarted the services and still
> no
>>joy, what else can I do to change to mixed mode?
>>thanks
>>Dave
>>
>
>|||No but it is part of the "domain admins" group which is part of the "local
admins" group so permissions look ok.
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:%23gMxADDaEHA.2892@.TK2MSFTNGP10.phx.gbl...
> David,
> What I meant was, is the Windows Domain Account that the MSSQLServer
> service logs on under, a member of the Local Administrators group on the
> server.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> David Hodgson wrote:
> > Just thought of something there, what do you mean is the "SQL Server" a
> > local administrator on the machine?
> >
> >
> > "Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
> > news:ugJluVCaEHA.3692@.TK2MSFTNGP09.phx.gbl...
> >
> >>David,
> >>
> >>Is SQL Server a local administrator on the machine? Does it have access
> >>to the registry? This state is stored in the registry, and if SQL Server
> >>doesn't have write permission to the registry it could fail.
> >>
> >>The registry key is
> >>HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
> >>SQLServer\<instance_name>\MSSQLServer\LoginMode
> >>
> >>The value of LoginMode is 1 for Windows Only, 2 for Mixed mode and you
> >>may still see 0 for SQL Server only (servers upgraded from 6.5).
> >>
> >>--
> >>Mark Allison, SQL Server MVP
> >>http://www.markallison.co.uk
> >>
> >>Looking for a SQL Server replication book?
> >>http://www.nwsu.com/0974973602.html
> >>
> >>
> >>
> >>David Hodgson wrote:
> >>
> >>Hi folks,
> >>
> >>I have a microsoft SQL server 2000 on a Windows 2003 Server on my
> >
> > network, I
> >
> >>am trying to install project server 2003. Project server tells me that
> >
> > my
> >
> >>SQL server must be in Mixed mode to complete the installation.
> >>
> >>The problem is that the server which was installed with "Windows Only"
> >
> > will
> >
> >>not switch to "Windows and SQL". I have restarted the services and
still
> >
> > no
> >
> >>joy, what else can I do to change to mixed mode?
> >>
> >>thanks
> >>Dave
> >>
> >>
> >
> >
> >sql