echo off

@SET UTILS_ROOT=C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
@SET SERVER_NAME=PROJECTSERVER
@SET DB_NAME=DATABASESERVER
@SET REPORTING_DB_NAME=DATABASESERVER
@SET ACCOUNT=DOMAIN\Administrator
@SET PASSWORD=mypassword
@SET PWA_NAME=PWA

@echo Create SSP Site
@echo ================================================================ 
@echo START TIME:
@echo -----------
time /t
@echo -----------

"%UTILS_ROOT%\stsadm" -o extendvs -url http://%SERVER_NAME%:8181 -ownerlogin %ACCOUNT% -owneremail YourName@company.com -exclusivelyusentlm -ownername YourName -databaseserver %DB_NAME% -databasename WSS_SSPAdmin -donotcreatesite -apidname WSS8181 -apidtype configurableid -apidlogin %ACCOUNT% -apidpwd %PASSWORD%

@echo Create PWA Site
@echo ================================================================ 
@echo START TIME:
@echo -----------
time /t
@echo -----------

"%UTILS_ROOT%\stsadm" -o extendvs -url http://%SERVER_NAME% -ownerlogin %ACCOUNT% -owneremail YourName@company.com -exclusivelyusentlm -ownername YourName -databaseserver %DB_NAME% -databasename WSS_Default -sitetemplate STS -apidname WSS80 -apidtype configurableid -apidlogin %ACCOUNT% -apidpwd %PASSWORD%

@echo Create SSP for PSI
@echo ================================================================ 
@echo START TIME:
@echo -----------
time /t
@echo -----------

"%UTILS_ROOT%\stsadm" -o createssp -title SSP_PSI -url http://%SERVER_NAME%:8181 -ssplogin %ACCOUNT% -ssppassword %PASSWORD%


@echo Create PWA Instance
@echo ================================================================ 
@echo START TIME:
@echo -----------
time /t
@echo -----------

"%UTILS_ROOT%\stsadm" -o projcreatepwainstance -url http://%SERVER_NAME%:80/%PWA_NAME% -adminaccount %ACCOUNT% -primarydbserver %DB_NAME% -publisheddbname "%PWA_NAME%_Published" -draftdbname "%PWA_NAME%_Draft" -archivedbname "%PWA_NAME%_Archive" -reportingdbserver %REPORTING_DB_NAME% -reportingdbname "%PWA_NAME%_Reporting"


@echo END TIME:
@echo -----------
time /t
@echo -----------

pause