SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to add another front end server to my wss server farm. For some reason, the 'SP product and technologies configuration wizard' is failing at step 2 - throwing an access denied error.

In my setup I have a web server which hosts the central admin site and a single sp application. I also have a database server which hosts the sp databases.

I'm trying to join database server as another front end so I can integrate ssrs with sharepoint.

I've reset the farm account's password (to be sure it's correct) and have made sure that it has db_owner rights to the wss config database. I'm a little confused about all the moving parts regarding user accounts, which is makes this difficult, but I think things are setup correctly. Regardless, I'm having this issue.

Anyone have any steps to help me resolve this problem?

share|improve this question
up vote 2 down vote accepted

If you haven't already done so, you may also need to add the dbcreator and securityadmin server roles to your user in SQL Server. Have you looked at the SharePoint logs (in the "12 hive") and the Windows Event Viewer on both servers already? They are helpful in diagnosing configuration issues.

share|improve this answer
Got a similar problem here now. Maybe it's related?… – Dane O'Connor Nov 29 '10 at 18:49

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.