INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Rename SQL server / instance

Rename SQL server / instance

(OP)
I have a SQL server with the computer and SQL instance name SQLSVRx that is becoming obsolete because of it's age, resources etc. I have a new SQL server to replace it with a computer and SQL instance name AZSSQLz. My dilemma is that I have multiple RDP servers with about 150 user desktops and the software used is tied to multiple icons with the paths including the original SQL server name along with 100's of Crystal reports tied to the old SQL server name to access the SQL data. Is it possible to take the original server SQLSVRx off line and wipe out all records in DNS and AD so that it no longer exists on the network and then rename both the new SQL server and instance name from AZSSQLz to AZSSQLx and then attach it to the domain to make the transition seamless without having to modify 100's of icons and reports? Everything else like the database names etc on the new server would be identical to the old one. If this is possible please let me know the process and steps. Thank you in advance for your assistance.

RE: Rename SQL server / instance

This should solve your problem:

https://www.mssqltips.com/sqlservertip/1620/how-to...

Obvious plan: Have a not yet used alias as test case and see, whether it connects to the new server. Then at time t0 you just have to redefine the alias right after removing the old server.

Bye, Olaf.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close