Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

User Profiles and Error 7888

  Asked By: Caleb    Date: Jan 23    Category: Sharepoint    Views: 1242

In a brand new three server farm, I'm opening up the User Profiles
and Properties page from the SSP Admin site.

I get the red "X" with this error:

An error has occurred while accessing the SQL Server database or the
Office SharePoint Server Search service. If this is the first time
you have seen this message, try again later. If this problem
persists, contact your administrator.

The only log entry I can attribute to this action is in the WFE's
Application log and I've copied the error below.



3 Answers Found

Answer #1    Answered By: Chanel Gaines     Answered On: Jan 23

Service Unavailable errors in SharePoint usually happen because the App
Pool Identity account has a password that has expired. When you setup
the app pool for the SSP did you use a Service Account or did you use
one of the pre-defined accounts like network Service?

Answer #2    Answered By: Timmy Whitney     Answered On: Jan 23

I have three app pools, PORTAL, MySite and SSP.

They all map back to domain accounts:


And they all have valid passwords.

can I tell if they have adequate access to the DB server by trying to
log into the database with their ID?

Does the same hold true for active directory.

Answer #3    Answered By: Harihar Sonnad     Answered On: Jan 23

Several points, just to try to cover all the possibilities...

1) Have the passwords to any of the accounts ever been changed? If
so, did you change them using Central Admin. If not, that is a problem
since these passwords need to be in the Configuration Database for

2) Make sure that the accounts each are DBO of the content database
for their respective Web applications.

3) For AD, they should be a member of the Local administrator's
group on the WFE servers. Other than local admin they should also be a
member of the WSS_WPG group on the WFE.

Didn't find what you were looking for? Find more on User Profiles and Error 7888 Or get search suggestion and latest updates.