November Happy Hour will be moved to Thursday December 5th.

DNS entry for database connection?

Vote:
 

Is there any potential issues with using DNS entry for database connection in connectionStrings.config instead of hostname?

We are not using the following format:

and are planning to use:

Thanks!

#119155
Mar 23, 2015 8:44
Vote:
 

Connecting to machine names directly can also be seen as bad practice so connecting via DNS is always a good idea. I've connected to SQL instances using DNS in the past without any issues. Given its a standard SQLConnection under the hood I cannot see any problems. There certainly isn't anything specific in an EPiServer install that would mean it isn't possible.

So my advice would be that there should be no issues (subject to reliable DNS of course) but its always worth checking. 

#119637
Mar 31, 2015 22:11
This thread is locked and should be used for reference only.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.