>My personal opinion would be to uninstall the instance and reinstall. I've done that a few times (where I didn't specify the instance name the way I wanted it...usually when I was creating a VM).
>
>Now, there are system stored procs sp_dropserver and sp_addserver. They are discussed in these two links:
>
>http://stackoverflow.com/questions/907851/change-sql-server-instance-name
>http://stackoverflow.com/questions/12676627/renaming-a-sql-server-with-installed-named-instances
>
>I have not tried these, so I can't vouch for whether they work. Maybe someone who has done this can jump in with their experiences.
>
>But where I've had it happen to me, I just uninstalled and reinstalled.

I tried those in the last hour. They have no effect on the instance but only inside SQL Server. I will reinstall that part. Thanks