1. Find out if portal only user or portal and precert

2. If physician is portal and precert, they can have 1 aspnetuser account that they user to access both (same email address and password) OR they can have 2 different aspnetuser accounts (different email and address for each system) 

   a. All of our precert PD users are also ABPN diplomates who probably also have a portal account. They can use a different          email address/aspnetuserid for each (so they'd have 2 aspnetuserIDs, or the same for both (1 aspnetuserID)).  The email         address on the physician page is what's on the person table, and what is used for portal (the aspnetuserid is kept on                Person).  In the training program component, you can look up the program there to see the list of users.  Here you ca see        that they are using a different email address for precert.  This email address has it's own aspnetuserID, which is kept on          PreCertUser.  Sometimes the physician is unaware that they have 2 different logins; sometimes they know they have two        different ones and prefer it that way.


3. Verify that the user does in fact have a portal account created (qucik ehck on physician page - if View in Portal link is not there then they do not have an account.  Or if they don't have an aspnetuser row they do not have an account.  The staff member can create it for the physician in BC, or the physician should go through first-time user

4. Run queries to check that person.UserID and aspnetuser.id match and are unique. If you need to confirm on your end that the login process works, use Incognito browser, update the users aspnetuser.password hash to the default and login with P@ssw0rd1.  That rules out anything wrong on our end.

5. The staff may need to be reminded to make sure the physician is not using bookmarks to go to portal login; they should go to abpn.org and use portal link there.  The physicians should also not be using any browser password keeper that auto-populates.  They need to type in their user name and password themselves.

6. You can confirm that an email is sending when they select forgot password by doing it yourself for them and confirming it sends in the BoardCert email box.

7. Write update statements as needed



select * from person where person_key = 137890

select * from person where Email_Address = 'jessalyn.wshen@gmail.com'

select * from person where userid = 'c8101598-a4a7-450e-9f15-352e0ee54560'

select * from AspNetUsers where UserName = 'jessalyn.wshen@gmail.com'

select * from AspNetUsers where id = 'c8101598-a4a7-450e-9f15-352e0ee54560'

select * from precertuser where emailaddress = 'javollmer1228@gmail.com'

select * from precertuser where AspNetUserId = 'c8101598-a4a7-450e-9f15-352e0ee54560'




8. Sometimes the system is trying to use an aspnetuserid that is defective.  Run the query below.  Change the WIndowsUser to the email address login of the person you are working with (this can be used with physicians and ABPN staff).  If it pulls back (last row) an aspnetuserid (SubjectId) that is different that the one you are seeing for the email address in question, look at all of the aspnetuser columns for that id.  Sometimes, the username column  is messed up.  Update UserName to the correct email address, delete the old aspnetuserid row in aspnetusers table, and update person.userid with the new one.


SELECT * FROM [Log] WHERE RawMessage = '{@event}' AND WindowsUser = 'jessalyn.wshen@gmail.com'

{"SubjectId":"19962315-18eb-4e84-9109-4bedc12a9213", "DisplayName":"jessalyn.wshen@gmail.com", "Category":"Authentication", "Name":"User Logout Success", "EventType":"Success", "Id":1002, "ActivityId":"8000398d-0000-e200-b63f-84710c7967bb", "TimeStamp":"2024-03-20T15:36:20Z", "ProcessId":11052, "LocalIpAddress":"192.168.2.19:443", "RemoteIpAddress":"162.158.154.246"}


9.  If the user has an active DANS case they will not have access to their portal by design.


10. To test password reset link as user in production:

    a. Send Password resert link from portal login in production using physician login eamil address

    b. Intercept the password reset email from the BoardCert email Inbox (dr will also receive the email so you are acting swiftly to use the link before they do)

    c. Copy/paste the password reset link from email into browser to reset password and login to confirm it works OR if asked, to create a new password for the physician.

   d. To access BoardCert email

    1. Access MS Office portal in browser, OR go right to web outlook email

   2. Access abpn Outlook email (https://outlook.office.com/mail/)

   3. Under your initials (avatar) in upper right corner

   4. Click 'open another email box'

   5. Search for boardcertmail@abpn.com

        a. NOTE: You must have permissions to open this email box

   6. Select it and it will open 

   7. After you Send Password Reset Link from portal login, monitor the Inbox in order to intercept the password reset link email