We have been trying to migrate our whd database to our new SQL 2014 server. We are doing a basic sql backup and restore to the new server. I have tested the connection string from our WHD web front end server using Microsoft Universal Data Link files (*.UDL) and it works fine.
However when we change the connection string within the WHD console we get an error saying it can't connect to the database.
Has anyone else upgraded to a SQL 2014 server with multiple instances on it?
You connect to the TCP port that the instance is running on (default 1433 when configured), but you have to configure
TCP connectivity on the exchange instances first with different ports