SQL authentication mode issue

J

Jim

going throught the Project Server 2003 installation, I
get to the screen where I choose to create a new
database, specify my server and connect using Windows
Authentication. I'm installing on SBS2003. When I click
next I get the following error:

Microsoft Office Project Server 2003 requires the
Microsoft SQL Server to be in mixed authentication mode.
Choose a different server.

When I open the SQL Enterprise Manager and try to change
authentication to mixed mode, it never takes. I choose
SQL Server and Windows Authentication, click ok, reopen
the properties dialog and it is back to Windows Only
Authentication.

Any ideas? All help would be appreciated.
 
G

Gary L. Chefetz \(MVP\)

Jim:

The SQL server must be set to recognize both SQL and Windows Accounts. It
can't be set to Windows only, which the error is saying that your server is.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change of authentication 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Proj server 2007 Client integration 1
Forms Authentication - setting up with Windows 2008 Ent Server x64 0
Forms Authentication (2007) versus Project Server Authentication ( 1
Authentication Issues 2
Credentials Prompt 9
Windows authentication or Project Server authentication? 2

Top