Can't Log in: Deleted All Users From Project Server Resource Table

P

Pat

My enterpirse resource pool was completely corrupted and so I manually removed all users, including my admin account, from the MSP_RESOURCES table using the code that is available on the newsgroups...The problem is I can't even log in now...

What do I do? Can I manually add myself into the tables so that I can get into project and open the global file. I can't even open the global file to add resources to the pool because I can't authenticate due to the fact that I deleted my admin account. Please help! :) Good Grief.. Thank you all.
 
S

scottw

I believe you will need to reinstall the Project Sever Front End Web, that is the only way I know.
 
G

Gary L. Chefetz \(MVP\)

Pat:

You should be able to add yourself manually to the MSP_WEB_RESOURCES table
to get back in. I'd add the Project Server Admin Account back in, if I were
you, then add the resources normally. If you don't have a lot of data in the
system yet, you might also consider simply regenerating the database by
running the setupdb.cmd file from the sql.scripts subdirectory of your
Project Server installation directory.

--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts

-
Pat said:
My enterpirse resource pool was completely corrupted and so I manually
Click to expand...
removed all users, including my admin account, from the MSP_RESOURCES table
using the code that is available on the newsgroups...The problem is I can't
even log in now...
What do I do? Can I manually add myself into the tables so that I can get
Click to expand...
into project and open the global file. I can't even open the global file to
add resources to the pool because I can't authenticate due to the fact that
I deleted my admin account. Please help! :) Good Grief.. Thank you all.
 
Top