This is a little post that i got from another web www.JustGeeking.net.

You can jump here.

During the configuration of a new SharePoint 2007 farm I experienced two separate errors:

1. When access the User Profile Properties page I got “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.” at the top of the page.

2. When accessing the Search Settings under the SSP administration, I got a page unavailable.

The following steps resolved the issue for me.

1. Go to Central Admin > Operations > Services on server and stop the Office SharePoint Search service on whatever server it is running on.
2. Restart the service on the same server.
3. Do an iisreset /restart from the command prompt on the server that is running the search service.
4. Go to Central Admin > Application Management > Create or Configure this farm’s shared service. Edit the SSP and make sure an Indexer Server is selected.
5. That should resolve both issues.

Thanks for the article, it help me for solving the problem that i got.