How to Set Up Windows Authentication

[Jim Moon]

Hello,

Since Microsoft generally advises its customers to use Windows
Authentication to access SQL Server, I find it disturbing that the Project
Server 2003 requires that you select SQL Server Authentication--or else it
gives the error:
"Error 25621. Failed to create SQL database. (-2147217843 Project Server)"
as is described in the file "README.HTM" on the install DVD.

I did try to install telling it to use Windows Authentication and I got the
above error. Now I want to convert Project Server to Windows
Authentication.

Can anyone tell me how to do that?

Thanks!

Jim

 

[Gary L. Chefetz \(MVP\)]

Jim:

During the installation the system prompts you to use Windows Auth or SQL
authentication to create the Project Server database. This in no way has
anything to do with what type of authentication the system will support in
production. Apparently the Windows account you were logged in with or
specified, did not have the correct database creation privileges in SQL
Server.

--

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

-

 

[Jim Moon]

Thanks for the reply, Gary.

Currently, when I try to access the Project Server web,
http://<server_name>/projectserver , I get
http://<server_name>/projectserver/lgnps.asp?err=5001 with the following
error message:
"Project was unable to log you on at this time because the Project Server
database cannot be accessed. Please try again later or check with your
Project Server administrator. (5001)"

Then, if I change the SQL Server instance authentication from "Windows only"
to "SQL Server and Windows", and refresh the browser, then that error goes
away.

My goal is to leave the setting on "Windows only".

Have any advice? Thanks!

Jim

 

[Gary L. Chefetz \(MVP\)]

Your SQL server must support both Windows and SQL auth. You configure
Project Server from within Project Server application.

--

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

-