Home Forums SQL Server 2005 Administering How do I Change The DB\Instance name RE: How do I Change The DB\Instance name

  • October 3, 2007 at 5:53 am

    #738555

    you cannot rename an instance, it has to be uninstalled and a new instance with the correct name needs to be created. that means backing up non-system databases, and then restoring them in the new instance.

    I haven't seen a registry hack or anything that successfully changed an instance name yet.

    for example, if you had SERVER\SQL2005 as an instance, and you wanted to rename the \SQL2005 for any reason, you have to uninstall the instance, and add the new one (ie SERVER\DEVELOPER

    if you rename the server, it will automatically change to NEWSERVERNAME\SQL2005

    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!