Tuesday, November 16, 2010

The credentials you provided for the sql server service are invalid & The current SKU is invalid

Summary: The credentials you provided for the sql server service are invalid & The current SKU is invalid
Details:

Ok, disk problems resolved, resuming the install (not doing advanced prepare this time!)
Successfully installed first single node cluster, hoooooray!!!!
When attempting to add node to the cluster, it failed stating “the credentials you provided for the sql server service are invalid”. It Failed on SQL Server / SQL Server Agent. I attempted to change the password to no avail, failed every time.
Found this article: http://support.microsoft.com/default.aspx/kb/955948/ which states “To work around this issue, type the domain account manually in the Account Name text box.” This is not true, as the boxes are grayed out and do not allow you to change the account.
Unsure to as where I got the information from, but I had read somewhere that CU1 would resolve this specific issue (trying to find link).
Ok, installed SP1 on the node which has the single node cluster setup.
Attempted to add node, “Failed: SQL 2008 Cluster – The current SKU is invalid.”
Found these articles: http://support.microsoft.com/kb/957459/ & https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=363036&wa=wsignin1.0M
Install SP1 on a node that doesn’t have SQL installed huh? Interesting. The 2008 cluster install doesn’t use the task scheduler any more, and the nodes have to be manually installed, so why do I need to patch a server that doesn’t have any trace of SQL on it yet?
Low and behold, when I went to install SP1 on each of the other nodes, it patched the “shared features” successfully.
Tried to add node to cluster, successful on each node!
Had to install SP1 again on each node after I completed the install.
What did I learn?
You need to install SP1 (or at least CU1) after installing your first single cluster node. After that, you have to install SP1 (or CU1) prior and post to adding any other nodes on the cluster. Crazy, but at least I know now.


--------------------------------------------------------------------------------

GREAT POST FROM SQLSLAYER

No comments: