We help IT Professionals succeed at work.

MSDE Instance Renaming?

PeterMauger
PeterMauger asked
on
Medium Priority
1,285 Views
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...).
Comment
Watch Question

Author

Commented:
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?
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:

Server Alias: YOURSERVER\NEW_INSTANCE
Server Name: YOURSERVER\OLD_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).

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.