• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1262
  • Last Modified:

MSDE Instance Renaming?

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...).
0
PeterMauger
Asked:
PeterMauger
  • 2
  • 2
1 Solution
 
monvelasquezCommented:
0
 
PeterMaugerAuthor 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?
0
 
monvelasquezCommented:
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).
0
 
PeterMaugerAuthor 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.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now