Solved

Alias name for SQL server

Posted on 2010-08-23
6
420 Views
Last Modified: 2013-12-05
We have an old WIndows 2000/SQL2000 server that runs one custom program we still need. The frontend installed on our XP/WIn7 boxes points to this SQL server to make the program work. I can export the db and import it into SQL 2008 but the clients will not be looking for this new server since it has a different name. There is no ODBC connection to change and I do not have the source code for the frontend to tweak where it is looking.

Is there some way in AD/DNS to have the old server name aliased to the new server so the frontend still works. I am assuming that the code looks at the server name and not the IP address.
0
Comment
Question by:LarryDAH
  • 3
  • 2
6 Comments
 
LVL 3

Expert Comment

by:shawnmstout
ID: 33505839
couldnt you simply rename the 2 machines, this would be the simplest way under the computer name, it might require you to delete and re-add the machine from active directory.

also you could change the ip addresses as well and switch them around
0
 
LVL 13

Accepted Solution

by:
SagiEDoc earned 500 total points
ID: 33508059
In DNs create a new Alias (CNAME) entry. Put the old server name in and point it to the new SQL 2008 server.
0
 

Author Comment

by:LarryDAH
ID: 33510708
shawnmstout: I thought of that but we changed our server naming convention and the old name style something we are getting away from. We can do that as a last resort, the problem with that is the new SQL 2008 server is up and running with other db on it and I am not sure what a name change would do to it.

saqiedoc: I will try your suggestion and see if that works.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 13

Expert Comment

by:SagiEDoc
ID: 33518317
It's never a good idea to rename a SQL server, but it can be done just follow this:
http://msdn.microsoft.com/en-us/library/ms143799.aspx
Leaving the name unchanged and adding a DNS alias will work, I have done this several times in the past.
0
 

Author Comment

by:LarryDAH
ID: 33562699
I assume that when I make the CNAME and point it to the new SQL server that I need to shut down the old one so DNS does not get confused as to which one is correct...
0
 

Author Closing Comment

by:LarryDAH
ID: 33586988
This sounds like the best solution, will do it this weekend.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

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.
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…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

910 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

21 Experts available now in Live!

Get 1:1 Help Now