To prevent from issues when/if the SQL server fails is it a good idea to create a DNS entry to point to the SQL server instead of using the actual server name when configuring SharePoint 2013?

In the past, I've always created SQLDNSENTRY to point to SQLSERVER01 and then used SQLDNSENTRY in all farm configuration steps.

Is this still a good practice?

1 Answer 1


We are using the same way, we have DNS entry which points to SQL server. We prefer the DNS entry upon SQL alias. For DNS entry, in case of failover down timer is higher then sql alias.

You can go either SQL Alias or DNS entry. You can read the below blog for nice comparison: https://junfengzhang.com/2014/08/16/dns-alias-vs-sql-server-alias/

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.