I installed a default SQL server instance to try out Microsoft Office Project Server 2003. Unfortunately it is now telling me I need the server to be in mixed authentication mode. Is there an easy way to change the authentication mode without reinstalling the entire SQL server?

 

Shane

Hi Shane,

 

No, you have to format all your workstation, the server and you need to purchase new routers to do this No kidding, just open SQL Manager and right click the instance you want to change. See the screenshot.

 

 

SQL Server and Windows is called Mixed Mode.

Thanks,

I found it just after I posted. Appreciate all your help.

Shane