SP 2013 SQL migration with AO

Question

Hi,

We have migrated to SQL 2014 from SQL 2008 with AO, it has multisubnetfailover also.
I have set multisubnetfailover to true using PowerShell for all the dbs.
but after changing the connection string using cliconfg.exe, it was timing out, not connecting to the listener.

Am I missing anything?

Thanks

Answer 1

Hi anonymous user，

What is the specific error you received?

here is a related issue:
https://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=255
the Server alias is what the application will attemp to connect to, you can specify where that alias points to by specifying the network library, the real server name, and any additional configuration parameters
https://learn.microsoft.com/en-us/sharepoint/administration/move-all-databases

Make sure thatTCP\IP is enabled as a client protocol on the application server
check the connection string to make sure it is configured correctly:https://learn.microsoft.com/en-us/answers/questions/491568/connection-timeout-expired-the-timeout-period-elap.html
test the connectivity useing SSMS, telnet and so on.

also note that for example the firewall on the server may not allow accsee on port 1433
https://learn.microsoft.com/en-us/troubleshoot/sql/connect/resolving-connectivity-errors

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.