New Basic Installation of Project Server 2007

[jsmith]

I'm trying to install Project Server 2007 for evaluation. I've had a
few issues and hopefully someone can help me out. When I attempt to
install after the machine is joined to the domain, setup fails because
of SQL errors. Here's some additional background:

- machine is joined to a domain
- one of our policies renames the local admin account, does this cause
any problems?

When I install Project Server 2007 when the machine is not joined to a
domain, everything installs fine. After I join the server to the
domain, I can't seem to provision sites anymore. After checking the
logs, I have more SQL errors. Any help is appreciated.

 

[James Fraser]

I'm trying to install Project Server 2007 for evaluation. I've had a
few issues and hopefully someone can help me out. When I attempt to
install after the machine is joined to the domain, setup fails because
of SQL errors. Here's some additional background:

- machine is joined to a domain
- one of our policies renames the local admin account, does this cause
any problems?

When I install Project Server 2007 when the machine is not joined to a
domain, everything installs fine. After I join the server to the
domain, I can't seem to provision sites anymore. After checking the
logs, I have more SQL errors. Any help is appreciated.

I strongly suspect this is related to permission problems. First
thing: I would make sure that you remove and reinstall IIS after
joining the server to the domain. This changes some of the service
accounts that IIS uses. Then run the Project Server installer and
configuration using a domain account that has the appropriate
permissions on the SQL server. (I don't remember the list off the top
of my head.)


Hope this helps...
James Fraser

 

[jsmith]

Thanks for your prompt reply James. I'm doing a clean installation of
Windows 2003 now. I'll post my results as soon as I can. Thanks.

 

[jsmith]

Well...the installation failed again. Attached is the last few lines
of the log file.

Successfully installed package: pserver path:Z:\x86\Global\pserver.MSI
Executing command path: 'C:\Program Files\Common Files\Microsoft
Shared\SERVER12\Server Setup Controller\wrapinst.exe', args:
'timeout=2950 MsiPath=msxml\msxml6.msi'
Command 'C:\Program Files\Common Files\Microsoft
Shared\SERVER12\Server Setup Controller\wrapinst.exe' returned: 0
Executing command path: 'C:\Program Files\Common Files\Microsoft
Shared\SERVER12\Server Setup Controller\SqlExpressWrapper.exe', args:
'timeout=2950'
Error: Command: 'C:\Program Files\Common Files\Microsoft
Shared\SERVER12\Server Setup Controller\SqlExpressWrapper.exe' failed
with error code: 15151. Type: CommandFailed.
Error: Command: 'C:\Program Files\Common Files\Microsoft
Shared\SERVER12\Server Setup Controller\SqlExpressWrapper.exe' failed
with error code: 15151. Type: CommandFailed.
Error: Command: 'C:\Program Files\Common Files\Microsoft
Shared\SERVER12\Server Setup Controller\SqlExpressWrapper.exe' failed
with error code: 15151. Type: CommandFailed.
Catalyst execution finished: 09/27/2007 14:51:30. Return code: 30008.
Exception caught: CommandFailed.
PERF: TickCount=567796 Name=RunSetup Description=End function

 

[jsmith]

Additional details attached. Hopefully someone can offer some
insight. Thanks.

Machine : PROJECT01
Product : SQL Server Database Services
Error : SQL Server Setup failed to execute a command for
server configuration. The error was [Microsoft][SQL Native Client][SQL
Server]Cannot alter the login 'sa', because it does not exist or you
do not have permission.. Refer to the server error logs and Setup logs
for detailed error information.
--------------------------------------------------------------------------------
Machine : PROJECT01
Product : SQL Server Database Services
Error : SQL Server Setup failed to execute a command for
server configuration. The error was [Microsoft][SQL Native Client][SQL
Server]Cannot alter the login 'sa', because it does not exist or you
do not have permission.. Refer to the server error logs and Setup logs
for detailed error information.
--------------------------------------------------------------------------------
Machine :ROJECT01
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SITE3PROJECT01_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup failed to execute a command for
server configuration. The error was {Microsoft}{SQL Native Client}{SQL
Server}Cannot alter the login 'sa', because it does not exist or you
do not have permission.. Refer to the server error logs and Setup logs
for detailed error information.
Error Number : 29521

 

[James Fraser]

Well...the installation failed again. Attached is the last few lines
of the log file. ....
Error: Command: 'C:\Program Files\Common Files\Microsoft
Shared\SERVER12\Server Setup Controller\SqlExpressWrapper.exe' failed
with error code: 15151. Type: CommandFailed.
Error: Command: 'C:\Program Files\Common Files\Microsoft
Shared\SERVER12\Server Setup Controller\SqlExpressWrapper.exe' failed
with error code: 15151. Type: CommandFailed.
Error: Command: 'C:\Program Files\Common Files\Microsoft
Shared\SERVER12\Server Setup Controller\SqlExpressWrapper.exe' failed
with error code: 15151. Type: CommandFailed.
Catalyst execution finished: 09/27/2007 14:51:30. Return code: 30008.
Exception caught: CommandFailed.
PERF: TickCount=567796 Name=RunSetup Description=End function

OK, now I'm not so sure about the permissions being the problem. It
looks like the install of MSDE / SQL Express is failing. This is the
included database engine that is installed when you perform a "Basic
Install."

I'm not sure why this is the case. Is it possible that your domain
includes some policies that prevent the installation of certain
software or system services? I would guess that SQL Express installs
and changes a number of system services. Maybe this is causing the
failure.

I don't have much more in the way of ideas on this.


James Fraser

 

[Gary L. Chefetz [MVP]]

jsmith:

May I ask what you want to evaluate? The installation that you are choosing
gives you a very limited installation which omits many enterprise features.
Are you aware of that and is that acceptable to you? If not, there's not
sense in pursuing diagnostics.

--

Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com

 

[James Fraser]

Additional details attached. Hopefully someone can offer some
insight. Thanks.

Machine : PROJECT01
Product : SQL Server Database Services
Error : SQL Server Setup failed to execute a command for
server configuration. The error was [Microsoft][SQL Native Client][SQL
Server]Cannot alter the login 'sa', because it does not exist or you
do not have permission.. Refer to the server error logs and Setup logs
for detailed error information.
--------------------------------------------------------------------------------
Machine : PROJECT01
Product : SQL Server Database Services
Error : SQL Server Setup failed to execute a command for
server configuration. The error was [Microsoft][SQL Native Client][SQL
Server]Cannot alter the login 'sa', because it does not exist or you
do not have permission.. Refer to the server error logs and Setup logs
for detailed error information.
--------------------------------------------------------------------------------
Machine :ROJECT01
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_SITE3PROJECT01_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup failed to execute a command for
server configuration. The error was {Microsoft}{SQL Native Client}{SQL
Server}Cannot alter the login 'sa', because it does not exist or you
do not have permission.. Refer to the server error logs and Setup logs
for detailed error information.
Error Number : 29521

I strongly suspect this is related to permission problems. First
thing: I would make sure that you remove and reinstall IIS after
joining the server to the domain. This changes some of the service
accounts that IIS uses. Then run the Project Server installer and
configuration using a domain account that has the appropriate
permissions on the SQL server. (I don't remember the list off the top
of my head.)

Hope this helps...
James Fraser

I found this that might help:
http://groups.google.com/group/microsoft.public.sqlserver.setup/msg/d7df73c5b40c35a8


James Fraser