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.

My question is that will a connection string use a full FQDN DNS name like  ?

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

Who is Participating?
Daniel WilsonConnect With a Mentor Commented:
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.
quippeeAuthor Commented:
Thank. we will try it out.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.