How can I change sql server name 2000

How can I change sql server name 2000? It was accidently installed using "local" as name

Thank you

Hi there,

Perhaps this link could be of assistance:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp

Although....By reading your question, it seems that you installed a default instance of SQL Server, which should show up as (local) in the Enterprise Manager console running on your server machine. However, clients who want to connect to your SQL Server will need to use the name (or IP) of the machine the server resides on in order to connect.

If you installed a default instance but want to change the name so that it looks like a named instance, I'm not sure whether you can or not (I've never tried it). Anyway, if you have a default instance and need a named instance, you could always just install another instance on your machine (if that's an option).

Hope that helps a bit, but sorry if it doesn't