rename instance possible?

Hi,
is a rename of a instance possible?

In the registry I found this service:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQL$WIEN
mit
Display Name REG_SZ SQL Server (WIEN)
ImagePath REG_EXPAND_SZ "C:\Program Files\Microsoft SQL
Server\MSSQL.3\MSSQL\Binn\sqlservr.exe" -sWIEN

In Enum, Linkage, Performance I found "WIEN" to.

Is the name "WIEN" burnt in in the database too? Or can I rename the entires "WIEN" only in the service (and restart the service) and the instance had a new name?

Well, officially not, you will have to do a reinstallation. You might try this here, but i guess this i not supported nor recommended.

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

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Definitely not supported.

Mike

|||You cant do this, Since i have tried sp_dropserver and sp_addserver commands but even its not possible to change the name. The only thing is to re-install.