Solved

Connection string using dns name

Posted on 2009-04-08
2
948 Views
Last Modified: 2012-05-06
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
Comment
Question by:quippee
2 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:quippee
Comment Utility
Thank. we will try it out.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now