What is the difference in using IP address and DNS name in the connection string while connecting to SQL database?

When we are making connection string always use Server's IP address not the DNS name if we use IP address it will reduce the time taken for connection to establish.

Because server IP address is used to get a default or named instance of Sql Server that ls running. if we are running the cluster we have to use the Virtual SQL Server IP address.

No comments:

Post a Comment