Solved

Alias name for SQL server

Posted on 2010-08-23
6
419 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Want to promote your upcoming event?

Is your company attending an event or exhibiting at a trade show soon? Are you speaking at a conference? Spread the word by using a promotional banner in your email signature. This will ensure your organization’s most important contacts are in the know.

 
LVL 13

Expert Comment

by:SagiEDoc
Comment Utility
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
Comment Utility
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
Comment Utility
This sounds like the best solution, will do it this weekend.
0

Featured Post

Free book by J.Peter Bruzzese, Microsoft MVP

Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

Join & Write a Comment

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found here: http://www.experts-exchang…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

771 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

12 Experts available now in Live!

Get 1:1 Help Now