Install Project Server with "Windows Only" authentication on SQL

[PottsNet2]

I'm trying to install Project 2003 Server with PS and SharePoint on the
front-end IIS server and put the back-end databases on another server. The
rub is that the security configuration requirements for out organization
prohibit using SQL authentication on the SQL 2000 servers. I was able to get
SharePoint to install and create its databases using Windows Authentication
by creating a temporary SQL login for the computer account of the
IIS/PS/SharePoint server. No such luck with any variation of the Project
Server installation. It will not even complete the install if not pointed at
a SQL server with mixed-mode authentication. I have installed SQL server, in
mixed-mode, on the front end, to complete the installation and allow
simplified troubleshooting. I switched this SQL back to Windows Only mode
and used CONNINFO.exe to assign a couple of local Windows accounts for the
ProjectServer and ProjectServerUser roles but still could not get it to work.
Any ideas?

 

[John Sitka]

Running SQL service under a dedicated MSSQLService domain account can often
solve a lot of ills.
I haven't done the exact config you mention yet, will be in the fututre.

This counts as an Any idea.

 

[PottsNet2]

Thanks for the quick response. I suspect that you are right about the SQL
service domain account. However, we had no choice in that selection either.
It is required to be a domain account

 

[John Sitka]

Well I'd say that domain account would need current Administrative privlages
on the local
machine. For the osql, shell etc that may be part of the the installation.
Hopefully the server does
not have a role defined as domain controller.

 

[Gary L. Chefetz \(MVP\)]

PottsNet:

I don't believe it's possible to run this with SQL set to Windows
Authentication only. You would have to replace the two SQL service accounts
with Windows accounts to accomplish this, so you need to use Site Editor and
Conninfo if you were goint to get it to work. I haven't tried this myself,
let us know how it goes.

--

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

-

 

[PottsNet2]

Gary,
I have used Conninfo to replaced the two PS logins to SQL with no joy. Even
on the same box, it only works (so far) when the two accounts are SQL
accounts and SQL is set to allow SQL logins. I am not familiar with
SiteEditor. How would I use it here?