I was trying to connect Index server to Sharepoint Farm where i had faced a lot of issues, but could resolve them finally and hence i would like to share a few details.
1. One important point is the server that is being added to the farm must have equivalent status of all the patches and installables as on the other servers in the farm else it will show files in "missing locally" status.
2. I installed few hotfixes and installables that were missing locally ( Project Server and WebApps in my Case and a few hotfixes were missing). After installing the patches i found that my central admin was not working .
3. It gave an error saying Central Administration website is not created and you need to run product configuration wizard. and the product configuration wizard was failing with the error Cannot connect to the Configuration database and throwing "system.argumentexception" addition parameter error type: Service.
4. I then tried creating a new Server farm through product wizard and was able to create a new Configuration Database in the database server .so there was no permission issue for the User and i checked if the user i was using had " Farm Admin Access"
5. Then Checked the event viewer where there was event logged with DB source Event ID 5586
saying that SQL server was not found
The Resolution was to Set the SQL Server alias for that Index Server which i was missing
This can be done/checked via the tool ‘cliconfg.exe’ . We have to Set three parameter in the SQL Server Client Network Utility.
2. Network Library : TCP/IP
3. Connection Parameter: The SQL Server instance where the farm Config DB is present
Once you add the SQL Server alias both your configuration DB failure issue as well as the central admin issue was resolved and the server was successfully added to the Farm.
Cheers !!!
