SQL Server 2005 Change Server Instance Name

[dgillz]

I setup SQL server 2005 on my machine which already has SQL Server 2000 on it. I was realy silly and used the same server name for both installs. How do I rename my server or instance in SQL 2005?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[mrdenny]

You will need to uninstall SQL 2005, then reinstall SQL 2000, then install SQL 2005 as a different instance name.

If you used the same instance name for the SQL 2005 instance then the SQL 2000 instance was actually upgraded to SQL 2005.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com