OS Bug: SQL 2005 cluster on Server 2008 -
10-18-2009
, 10:21 PM
I ran into a strange windows server bug where if you're running sql 2005
cluster on windows server 2008 cluster and node names are in lower case in
computer properties, SQL 2005 service pack or patch setup will not update
resource/system databses and won't give any error either. Service pack
installation will show success. But soon after I started running into issues
such as unable to save maintenance plans and looking around I found that my
sql version is 9.0.4229 but my resource databse is still at RTM level
9.0.1399. Here is link to the issue I have and suggested workaround:
http://blogs.msdn.com/sqlserverfaq/a...8-cluster.aspx
I would like to know if any one had this issue or tried workaround? Do I
need to make any changes to sql installation before evicting node or after
re-adding node to cluster? All I want to do is to change my node name to
upper case.
Thanks in advance. |