Solved

Connection string using dns name

Posted on 2009-04-08
2
957 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
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

821 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