Invalid SKU Error when Adding a Node to a SQL 2008 Cluster

  • Ysaias Portes-QUI Group

    SSCrazy

    Points: 2127

    Comments posted to this topic are about the item Invalid SKU Error when Adding a Node to a SQL 2008 Cluster

    QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809

  • carol.boersema

    Old Hand

    Points: 330

    How can I tell if the node added correctly?

  • Ysaias Portes-QUI Group

    SSCrazy

    Points: 2127

    Hi Carol,

    Once you have completed the script you can go to the Cluster Administrator by going to Start Menu -> Run

    and paste this cluadmin.exe or by going into the control Panel -> administrative Tools -> Cluster Administrator.

    Then Under Groups find the name of the SQL Server Group. Right Click on SQL Server -> Properties:

    Under Properties [General] tab check that you have the name of your Clusters node on the Posible Owners section. That means that SQL Server can run on all the nodes listed in there. You can also try to fail SQL from the active node to another node and make sure that it successfully runs.

    Take a look at the attached image.

    if you have more questions, please feel free to reply to this posting.

    QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809

  • ipekkak

    Grasshopper

    Points: 19

    Hi,

    You should also add the /PID flag to the commad, otherwise the SQL Server Evaluation edition is installed to the second node!

    PK

  • Avijeet

    Old Hand

    Points: 381

    You can also try by commenting out the Product key by Adding a ; in front of

    ;PID= "XXXX-XXXX-XXX..."

    The file can be found in setup folder \x64\DefaultSetup.ini

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply