5/23/2006

Changing settings on a virtual SQL Server

How to change IP Address on a SQL 2000 cluster:

KB244980

How to rename a Virtual SQL Server:
KB307336

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.

Kevin3NF

5/19/2006

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).

5/08/2006

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.