Hello,
This may or may not help you, but here is a script I wrote to create
the new proj server sites.
You won't be able to use it as is, so the things you will have to
change are.
- copy the database dir from the support folder on projserv CD to
local drive - i have used c:\dbtemp\database
- find out what sharepoint admin port is and replace the 13580 value
I have used below.
- install the KB835736 hotfix, and rename and copy the 2 sql files to
database dir since these files may already exist
- check all paths (where editsite and project server installed)
- I use a MSProj..User_projsitename format for account names. Feel
free to change.
- use sql account privs (this script only tested with sql accounts
not nt auth accounts)
- change email account for admin to something meaningful for you.
Please note - this script comes with no warranties or support. I
supply in good faith but do not guarantee it works, nor from damage
resulting from misuse (please test thoroughly before using on prod
equip), or any damage for that matter. Use at own risk. Works for me
tho.
Let me know if it helps, or want the file explained. I have used this
file to create 20+ sites in a single script.
Enomagic
***start of creatsite.cmd file*******
@echo off
SETLOCAL
IF [%1]==[] GOTO NOARGS
IF [%2]==[] GOTO NOARGS
IF [%3]==[] GOTO NOARGS
IF [%4]==[] GOTO NOARGS
IF [%5]==[] GOTO NOARGS
IF [%6]==[] GOTO NOARGS
c:
cd c:\dbtemp\database
REM %1 is name of new project server site
REM %2 is name of project server
REM %3 is sql db account to use
REM %4 is sql db password to use
REM %5 is password to use for MSProjectUser_%1 sql account
REM %6 is password to use for MSProjectServerUser_%1 sql account
ECHO --------------------------------------------------------------------------------
ECHO Creating Project Server Instance %1
ECHO.
ECHO.
ECHO Creating database %1
osql -U %3 -P %4 -Q "CREATE DATABASE %1"
ECHO.
ECHO Configuring Project Server database for %1
call setupdb.cmd %2 %1 %3 %4 NoPause
ECHO.
ECHO Configuring Project Server roles for %1
osql -U %3 -P %4 -d %1 -i PSROLES.sql
ECHO.
ECHO Creating Project Server database accounts for %1
osql -U %3 -P %4 -Q "sp_addlogin @loginame = 'MSProjectUser_%1',
@passwd = '%5', @defdb = '%1' "
osql -U %3 -P %4 -Q "sp_addlogin @loginame = 'MSProjectServerUser_%1',
@passwd = '%6', @defdb = '%1' "
ECHO.
ECHO Granting access for Project Server database accounts for %1
osql -U %3 -P %4 -d %1 -Q "sp_grantdbaccess @loginame =
'MSProjectUser_%1'"
osql -U %3 -P %4 -d %1 -Q "sp_grantdbaccess @loginame =
'MSProjectServerUser_%1'"
osql -U %3 -P %4 -d %1 -Q "sp_addrolemember @rolename =
'MSProjectRole' , @membername = 'MSProjectUser_%1'
osql -U %3 -P %4 -d %1 -Q "sp_addrolemember @rolename =
'MSProjectServerRole' , @membername = 'MSProjectServerUser_%1'
echo.
echo Applying service pack AD sync hotfix db scripts.
echo executing- "osql -U %3 -P %4 -S %2 -d %1 -i HFPS110-patch.sql"
osql -U %3 -P %4 -S %2 -d %1 -i HFPS110-patch.sql
pause
echo executing- "osql -U %3 -P %4 -S %2 -d %1 -i WEBSPS-patch.sql"
osql -U %3 -P %4 -S %2 -d %1 -i WEBSPS-patch.sql
pause
ECHO.
ECHO Creating Project Server Web Site for %1
c:
cd "C:\Program Files\Microsoft Office Project Server 2003 Resource
Kit\Toolbox\EditSite"
EditSite -S "%2" -D "%1" -U "MSProjectServerUser_%1" -P "%6" -E
"MSProjectUser_%1" -A "%5" -V "%1" -W "1" -L "e:\Microsoft Office
Project Server 2003" -G "%2" -H "MSProjServAppPool" -O
"
http://%2:13580" -Y "
http://%2:80/sites" -C "%2\sharepointadmin" -M
"(e-mail address removed)" -Q
ECHO.
ECHO Restarting Project Server Views Notification Service
net stop "Project Server Views Notification Service"
net start "Project Server Views Notification Service"
ECHO.
ECHO Creation Complete.
ECHO --------------------------------------------------------------------------
GOTO :EOF
:NOARGS
ECHO.
ECHO Incorrect Arguments Specified
ECHO Usage : createps arg1 arg2 arg3 arg4
ECHO Arg1 is name of new project server site
ECHO Arg2 is name of project server
ECHO Arg3 is sql db account to use
ECHO Arg4 is sql db password to use
ECHO Arg5 is password to use for MSProjectUse_sitename sql account
ECHO Arg6 is password to use for MSProjectServerUser_sitename sql
account
******end of createsite.cmd file***************
