Hi,
I’m attempting to add an application server to an exisiting farm. However when I run the configuration wizard to connect to the exisiting farm an error is thrown “The database name is not a valid configuration database”…but it is because thats tha database the main WFE connects to!
The ULS logs point to an ‘Unknown SQL error 53…named pipes etc etc’.
- I’m using a SQL alias with a non standard port…the same SQL alias as my SP servers
- Named pipes are enabled on the SQL server
- I’m running the wizard using my SP_Admin, the same account as I’ve always done
- I’ve checked the SP_Admin permissions on SQL…they are correct
- I’ve updated and checked that my SP servers are all running the same version of SP
- I’ve disabled the SQL firewall just in case…no luck.
I’ve spent a silly amount of time trying to figure this one out! If anybody could point me the in the right direction it would hugely appreciated.
Many thanks
Marc
On the application server try PowerShell cmdlet: Get-SPProduct -local
Then retry adding the server to farm.
Just to expand on this after further investigation, Central admin shows version 15.0.4763.1000 and the PowerShell script returns 15.0.4569.1506…how can that be?
Drew,
This one I’d thought of quite early on, both are running 15.0.4569.1506
Thanks
Marc
Can you confirm that that all servers have the same SP CU’s and updates installed on them?Â
Hi Aniket,
- The UDL file connects fine
- SQL Alias is set in both 32 and 64bit in SQL config manager
- When I run the config wizard it picks up the only (correctly) config database
- Which logs do you need to see
- I’ve disabled Firewalls at both ends just to test, no joy
I’m at a loss to explain why this is happening…thanks for your help by the way
