I have notice that our dev and prod SQL Server has SQL Server name and SQL Server group name that is different to the machine name.
We are planning to change it to match the machine name. To do this, from what we have read, you change the SQL Server name using the sp stored procedures to drop then re-add server with the machine name, then you change the Windows SQL Server group name replacing any reference to the old machine name with the current machine name, then you drop the SQL Server group and re-add the group. Do I need to do anything else? And most importantly is a common or risky thing to do?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: