Several months back, I had implemented a active/passive two node cluster with SQL 2008 Standard. Following several documents, everything was tested and worked flawlessly. Now that everything has been in production for a few months, I now need to add a second instance to the cluster.
I know that I've read that it's probably smarter just to add the databases to the existing instance, but I need to create another instance to please the software vendor.
In all my wisdom, I chose to name the first instance I installed: SQL2008Cluster\Instance1 - now I see that the SQL Server Network Name must be unique during the install of the second instance. If I had an opportunity to go back and modify that name, I'd like to - are there any ways (other than rebuilding the cluster)?
I guess going into this, I thought for sure I would be able to have an instance named SQL2008Cluster\Instance2.
Thoughts?