Changing settings on a virtual SQL Server

How to change IP Address on a SQL 2000 cluster:


How to rename a Virtual SQL Server:

DO NOT try to change these setting in Cluster Administrator. Just because you can do it does not mean it will work. It won't.



Got a new ride this week...a Specialized Roubaix comp, double...sweeeeettt :D
Customer sez:
I can't register SQL Server in Enterprise manager...I get "Cannot generate SSPI Context" error...

Kevin3NF Sez:
Log onto the domain the SQL Server is in, not the local machine...(after much other troubleshooting was done).


Hey kids, if you are going to change the Service account passwords on your SQL Server 2000 cluster, please use Enterprise Manager :-)

Oh...and make sure you don't lock the accounts in AD...that will cause major issues as well.