EPM, Project Server 2003, Project Server 2007, MOSS 2007, Portfolio Server2007
I am often asked, how to control the name of the admin content databases when you install and configure Project Server 2007 or MOSS.
The databases are not automatically created when you install the product. The installation just install the binaries. You then need to configure the product using the SharePoint Products and Technologies Configuration Wizard, and this is when the first 2 databases in a SharePoint farm are created by default:
You can specifiy the configuration database name in the GUI, but not the name of the Admin content database.
In order to choose the Admin content database name, you need to use the PSCONFIG command line utility before starting the SharePoint Products and Technologies Configuration Wizard (psconfigui.exe)
psconfig.exe is located in C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
Here are the parameters to use with psconfig.exe
psconfig -cmd configdb -create -server %DB_INSTANCE_NAME% -database SharePoint_Config -user %ACCOUNT% -password %PASSWORD% -admincontentdatabase SharePoint_AdminContent
SharePoint_Config and SharePoint_AdminContent are the 2 databases we created.
%DB_INSTANCE_NAME% is the SQL instance name where you created your 2 databases
%ACCOUNT% is the windows account (using the syntax DOMAIN\USER) used as the SharePoint farm administrator
%PASSWORD% is the password of %ACCOUNT%