• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 978
  • Last Modified:

Connection string using dns name

I read an article about how to use dns alias instead of server names in teh connection strings. but in the article the use a name like instead of SERVERA you could use SQLPROD.

http://www.databasejournal.com/features/mssql/article.php/3742136/Connection-Strategy-for-Multiple-Database-Environments.htm


My question is that will a connection string use a full FQDN DNS name like sqlprod.contoso.com  ?

In the article they specified another name which is not neccessary a dns alias,  it would probably still use wins first.

Thanks.
0
quippee
Asked:
quippee
1 Solution
 
Daniel WilsonCommented:
You can certainly use an FQDN.  You just want to use a name that your client can readily resolve to the server -- by one means or another.  Actually, if there's any ambiguity on your network, an FQDN is probably the safest & smartest option.
0
 
quippeeAuthor Commented:
Thank. we will try it out.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Tackle projects and never again get stuck behind a technical roadblock.
Join Now