guys
i can not find a post that says how you do this... i just get an error about connecting to the node name.... i can see people have done it on here but no one states how you do it..
help!!!! pleeease.... sorry for being dumb
Does this help?
http://support.solarwinds.com/kbase/ProblemDetail.cfm?ID=1153
hit here
thanks for the reply, but thats the way you do it on noral SQL server, i need to do it on a cluster... if u try and follow this, you get an error stating
"you cannot configure surface area of clustered services by connecting to a computername. connect to the virtual server to configure clustered services. (SQLSAC)"
Do you have a DBA on site? If so, the DBA will usually know how to do this. Microsoft can assist also.
i sorted it...
when you are in "SQL Server Surface Area Configuration" you have to click the link called change node. in there you have to manually enter the cluster node name, and it will work a treat!!
yet to test the database nmove from its current 32bit server on VMware to the new physical sql cluster, but suspect it will work a treat...