Solved

How to switch SQL data connection for .net applications?

Posted on 2007-03-29
1
140 Views
Last Modified: 2010-03-19
I have a server running SQL server 2005, we are about to make a switch to a new server enviroment and that machine will be running the same. All of our .net applications have a data connection to the old server. Once I bring up my new server, what would be the easiest way for me to have my apps recognize the new server name? Can I make a DNS entry to point to that machine?
0
Comment
Question by:Wytech_Wire
1 Comment
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
Comment Utility
If the old server is going away, you can certainly direct a DNS entry by that name to the new server.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I wrote this article to explain some important DNS concepts that should be known to avoid some typical configuration errors I often see in forums. I assume that what is described here is the typical behavior of Microsoft DNS client. I don't know …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

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

11 Experts available now in Live!

Get 1:1 Help Now