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
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