Problem creating multiple sites using the Site Editor Tool

T

teksurf

I was attempting to set up multiple sites using the Site Editor utility.
First I created the additional database using the Enterprise Manager,
installed the accounts and created the tables using the command prompt as
shown on the Project Server 2003 disk. Then I went in and used the site edit
tool to create the new site. Everyting worked just as advertised. The problem
arose when I logged into the new site for the first time. It would not accept
the administrator login or for that matter any other loggin I tried. I have a
site and I have the backend database but can't connect to the project server
all I receive is this error "You have entered an incorrect user name/password
combination. (5005)".
Did I miss something on the installation? It did not require me to set an
administrator password anywhere in the setup. Any help on getting connected
would be greatly appreciated.
teksurf
 
R

Rick Roszko

After creating a new site (or a site you duplicated under a different name):

(a) Launch SQL Enterprise Manager
(b) Delete MSProjectUser and MSProjectServerUser
(c) Recreate MSProjectUser with MSProjectUserRole permission
(d) Recreate MSProjectServerUser with MSProjectServerUserRole permission
(e) Now use edit site to connect to the new database
 
Top