Once, I had two separate SharePoint 2007 farms having its own server. I needed to change that to one farm with two servers. So I had to remove one farm from one server machine and connect it as a WFE to the existing farm in the other server. The first step was to remove one SharePoint farm.
1) You can use the following command to disconnect the database from SharePoint:
PSCONFIG.EXE -cmd configDB -disconnect
2) Then remove the SharePoint related DB's from SQL Server
3) Run the SharePoint configuration wizard. You get a message as below. Select "Yes".
4) In the configuration wizard, choose connect to existing server farm.
5) Select the database of the server which you need to connect and specify the DB access account to be used. Let the configuration happen.
Now go to the Central Admin. Select Operations. Select Servers in Farm. The new addition to the farm will be listed down.
1) You can use the following command to disconnect the database from SharePoint:
PSCONFIG.EXE -cmd configDB -disconnect
2) Then remove the SharePoint related DB's from SQL Server
3) Run the SharePoint configuration wizard. You get a message as below. Select "Yes".
4) In the configuration wizard, choose connect to existing server farm.
5) Select the database of the server which you need to connect and specify the DB access account to be used. Let the configuration happen.
Now go to the Central Admin. Select Operations. Select Servers in Farm. The new addition to the farm will be listed down.
