Rename SQL 2005 Instance

Hi,

I have a SQL Server 2005 installation, running under the instance of MyServer\SQL2005. So I have 1 instance called 'SQL 2005'.

I would like to rename the instance back to the default instance. So afterwards, the server instance should just be called 'MyServer'. Does anyone know if this is possible without loosing any data?

Thank you

Jeremy

I don't think it's doable

I searched around when I tried to change my default instance install to named instance - can't do it

had to uninstall, and re-install again

as long as you don't delete your MDF/LDF files, you shouldn't lose much (backup first anyway)

|||

Thanks for your reply,

This is what I was fearing.....although it is strange that Microsoft specificly ship the AS instance rename tool. Yet there's no indication of how you can do this for the database engine.

If anyone does know of a method it would be appreciated,

Thanks

Jeremy

|||

Jeremy,

You can rename a default instance of the database engine just by renaming the computer. See the topic "How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server 2005" in BOL. You cannot rename the instance part of a named instance.

Ron

|||http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/544c4eaf43ddfaf3/e9065e05718e984e