MSDE Instance Renaming?

Posted on 2007-08-09
Last Modified: 2013-11-05
The likely answer to this is a resounding 'NO' but I was wondering if anyone knew of a way to rename an installed SQL Server instance (in this case installed on numerous clients' servers). It's not technically necessary but I just bought the IP for the commercial system from the company I developed it for where I kind of slathered their branding all over everything to do with the system... Hence the MSDE instance has their company name in it, the installation package has their company name in it, etc.

I'd like to bring it all to my company's branding but the only thing I can think of at the moment is uninstalling the old stuff and installing the new version (which will of course require a nastily complex installation that migrates everything across...).
Question by:PeterMauger
    LVL 3

    Expert Comment


    Author Comment

    Hmmmm... I gave it a try and the sysservers table was updated with the new details but the actual instance itself hasn't changed at all. I think the KB mentioned is designed to align the internal stored value of the server\instance name with that of the external services, etc. I think the suggestions offered would be required in the event that someone did change servers or somehow rename the actual SQL instance (ie the services, files, folders, etc) but it doesn't seem to change the 'external appearance' of the instance (which is all I'm really worried about...).

    Truth be told I'm probably going to migrate the database up to SQL Express in the next release anyway (which will require a new installation and the migration of data anyway) so it's not critical, I was really just interested to see if there was a way to do it.

    Any further thoughts?
    LVL 3

    Accepted Solution

    I have another idea but it's just a bit off the mark. How about using the Client Network Utility to give another alias to the instance:


    Also I read on one page that some guy sucessfully changed the instance name in the registry. But he wouldn't recommend it (I wouldn't too).

    Author Comment

    Definitely a nice effort! Unfortunately it's not really what I was hoping to achieve but I wasn't really expecting to be able to. There'll be some more points available if anyone can come up with a full solution but for now this one is closed.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    I recently came across an interesting Question In EE ( and was puzzled about how to achieve that using SSIS out of the box tasks, which was i…
    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Via a live example, show how to shrink a transaction log file down to a reasonable size.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now