RE: Rename SQL Server not working

SSC Guru

Points: 323504

December 17, 2013 at 9:55 am

you cannot rename an instance.

that means, for example, if you installed machinename\SQLEXPRESS, and you want to rename it to be machinename\SQL2008R2 that is not possible. you have to backup whatever was on the instance, remove the instance, and reinstall.

that can get pretty involved, depending on the instance...SSIS packages, linked servers, certificates, logins, mail settings, and a lot of other items might need to be migrated.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!