I went through the upgrade process from SQL 2000 to 2005 and got an error during the database services portion so the upgrade supposedly rolled back. Once we fixed the error we were not allowed to re-run the setup (which the instructions told us to do) because the instance was already installed. We could not go back to the old version either as it in essence wasn't there. The only option we could come up with was to create a new instance. Now we have two instances and would like our new one to change to the default one. We have mission critical data that has to be accessed by Monday morning so any help is greatly appreciated.