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.