problem adding web frontend server to sharepoint server farm
- i have already setpup a medium farm that that contains : sgarepoint Application server , Active directory server , SQL Backend server, from images we have taken previously, now and after i make sure that everything is working properly on this farm, i started to add web front end server, and when the configuration wizard run error comes up on step 2 saying :
"Faild to connect to configuration database,
An exception of type syste,InvalidOperationexceptuon was thrown. additional exception information: Operation is not vaild due to current state object,
to diagnose the problems, review the log file .....".
the end result is the Webfront end is appear within the farm servers , but "Not configured" ..
........................................
later i run through psconfig –cmd configdb –connect –server <database_server> -database <database_name> -user usernaem -password *****
and it generate another error says:
The server parameter specified with the configdb command is invalid.
Failed to connect to the database server or the database name does not exist. E
nsure the database server exists, is a Sql server, and that you have the appropr
iate permissions to access the database server.
anyone have idea how to solve this issue ,,
Sharepoint Specialist
Sharepoint Specialist- Edited byMike Walsh MVPMVP, ModeratorWednesday, October 28, 2009 6:22 PMDo NOT say you want something asap. or that it's critical. If it is critical you should not be using forums. You should be ringing MS Customer Support Services. Text deleted
Answers
Please make sure the account you used to run the PSConfig has appropriate permission on the database server. For detail, please refer to the following excerpts from http://technet.microsoft.com/en-us/library/cc263445.aspx
Server farm-level accounts
Account
Purpose
Setup user account
The user account that is used to run:
· Setup on each server computer
· The SharePoint Products and Technologies Configuration Wizard
· The Psconfig command-line tool
· The Stsadm command-line tool
Least-privilege administration requirements when connecting to pre-created databases
Server farm-level accounts
Account
Server farm standard requirement
Least-privilege when connecting to pre-created databases requirements
Setup user account
· Domain user account.
· Member of the Administrators group on each server on which Setup is run.
· SQL Server login on the computer running SQL Server.
· Member of the following SQL Server security roles:
· securityadmin fixed server role
· dbcreator fixed server role
If you run Stsadm commands that affect a database, this account must be a member of the db_owner fixed database role for the database.
Server farm standard requirements with the following additions or exceptions:
· Use a separate domain user account.
· NOT a member of the Administrators group on the computer running SQL Server.
This account is used to configure databases. After each database has been created, change the database owner (dbo or db_owner) to the Setup User account.
- Marked As Answer byGuYumingMSFT, ModeratorThursday, November 05, 2009 1:14 AM
- the proplem has solved , and it was due to conflict in wss vesrion , since there was sp_sp1 running on the application server , so i should have to install wss_sp1 then SP_sp1 on the web front end , then run the configuration wizard again to add the web front end.
Sharepoint Specialist- Marked As Answer bybaso Thursday, November 05, 2009 9:21 AM
All Replies
Please make sure the account you used to run the PSConfig has appropriate permission on the database server. For detail, please refer to the following excerpts from http://technet.microsoft.com/en-us/library/cc263445.aspx
Server farm-level accounts
Account
Purpose
Setup user account
The user account that is used to run:
· Setup on each server computer
· The SharePoint Products and Technologies Configuration Wizard
· The Psconfig command-line tool
· The Stsadm command-line tool
Least-privilege administration requirements when connecting to pre-created databases
Server farm-level accounts
Account
Server farm standard requirement
Least-privilege when connecting to pre-created databases requirements
Setup user account
· Domain user account.
· Member of the Administrators group on each server on which Setup is run.
· SQL Server login on the computer running SQL Server.
· Member of the following SQL Server security roles:
· securityadmin fixed server role
· dbcreator fixed server role
If you run Stsadm commands that affect a database, this account must be a member of the db_owner fixed database role for the database.
Server farm standard requirements with the following additions or exceptions:
· Use a separate domain user account.
· NOT a member of the Administrators group on the computer running SQL Server.
This account is used to configure databases. After each database has been created, change the database owner (dbo or db_owner) to the Setup User account.
- Marked As Answer byGuYumingMSFT, ModeratorThursday, November 05, 2009 1:14 AM
- the proplem has solved , and it was due to conflict in wss vesrion , since there was sp_sp1 running on the application server , so i should have to install wss_sp1 then SP_sp1 on the web front end , then run the configuration wizard again to add the web front end.
Sharepoint Specialist- Marked As Answer bybaso Thursday, November 05, 2009 9:21 AM
