[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Connection string using dns name

Posted on 2009-04-08
2
Medium Priority
?
973 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 2000 total points
ID: 24103579
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
ID: 31568036
Thank. we will try it out.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

650 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