Change Password

[Basel Nimer]

Hi All,

I am integrating Project Server into my web site, I use
PDS besides linking to the webAccess from inside my web
site.

I have 2 problems,

1- My web site has it's own username and password for each
user, I want to keep ProjectServer's password in sync with
My site's password, which means that i want to change the
password in ProjectServer whenever my user changes his
password on my application, I tried to track the WebAccess
site to know what COM's to use, but with no luck, can
anyone passme a small VB program that uses those COM's to
change a password.
I am not sure if this is allowed or now, But i think it
will need the administrator password which grants
authority, no problem, I am not intending to change the
administrator's password, it is always static, unless it
is changed the hard way (manually) from the application.

2- The other problem has to do with ASP, but maybe some
one ran to the same problem before.
I open WebAccess inside a frame in my website, the problem
appears when the user opens it the first time, and when
WebAccess tries to install it's components, it stucks on
the agreement page, every time you press "I Agree" it
refreshes without installing anything.

Is there a way to install it in another way, that's if we
couldn't leave it to work the normal way.


Thanks all

 

[Vinh Tran]

PROBLEM 1:

The easiest way to track down what Methods need to be
called is to isolate the system and run Profiler on your
SQL box.

The Password change requires you to run the Stored
Procedure MSP_WEB_SP_QRY_UpdateResourcePwdForEOrDResID.

Easiest way to do this is to run the Profiler and copy
the calls in your website. The instructions are far too
long to go into here.


PROBLEM 2:

You're trying to download a slightly different ActiveX
component.

Go into your C:\WINNT\Downloaded Internet files (or
something like that) directory and delete ALL
applications that start with "PJ".

Then go back into Web Access....This will allow a fresh
download.



Vinh Tran

 

[Vinh Tran]

PROBLEM 1:

I ran the Profiler again and looked at the SP call.

MSP_WEB_SP_QRY_UpdateResourcePwdForEOrDResID 1050,
N'password', N'sIHb6F4ew//D1OfQInQAzQ=='

The first parameter is the UserID, second is the password
and I believe the third is the hashed version of that
password.

Here's a quick link to a script that will hash your
password for you....I'm not an expert at it, but at first
glance, it looks workable.

http://www.pscode.com/URLSEO/vb/scripts/ShowCode!
asp/txtCodeId!735/lngWid!5/anyname.htm


PROBLEM 2:

Haven't tried opening Project Server within a frame thus,
I can't help you....Make sure your session is being
created properly after you login....and that your username
is being passed. Check it by throwing a
quick "onload=javascript:window.alert('<%=Session
("PjSessionID")%>')" in your EULA page.

It should return a long string with various values....



Vinh Tran

 

[Basel Nimer]

Sir,

As for problem one, This code is great, it generates an
encryption for the password, but not for project server.

for the other problem,
All i need is to install the ActiveX from my application.