Post reply

SQL Server 2008 R2 Multiple Instance Cluster

  • March 6, 2012 at 8:23 pm

    #252715

    Hello ,

    i have problem with my SQL server Cluster 2008 R2

    1. I have installed multiple instance in SQL server 2008 R2 on Primary Server , thats OK

    2. after we have new Server than we configure my secondary Server and add node on SQL server installation cluster , its work.

    3. than i need to add new instance , than i install instance but i have problem with error 0X80071736

    4. we check on Cluster manager and service ad Application on server name properties it said karberos Status Access is denied

    and my second problem is when we try to simulate fail over , with shutingdown my primary server why we have to start manually on all service on my secondary server, could we change the automatic startup on my secondary server

    could anyone help me with this problem, its pain full 🙂

    Thank all

  • March 7, 2012 at 12:23 am

    #1455767

    You have just 2 nodes in the cluster is that correct?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 7, 2012 at 1:58 am

    #1455801

    dear

    yes now we have 2 node , thanks

  • March 8, 2012 at 12:37 pm

    #1456757

    Have you run the cluster validation tool to check for any setup issues on the Windows side? Those can frequently be the root of any SQL issues.


    Shamless self promotion - read my blog http://sirsql.net

  • March 8, 2012 at 12:48 pm

    #1456766

    nvsqlserver (3/6/2012)

    3. than i need to add new instance , than i install instance but i have problem with error 0X80071736

    can you post a screenshot of the error?

    nvsqlserver (3/6/2012)

    and my second problem is when we try to simulate fail over , with shutingdown my primary server why we have to start manually on all service on my secondary server, could we change the automatic startup on my secondary server

    go into failover cluster manager and expand services and applications. Right click the clustered sql server group\application and select properties, what is the status of the autostart checkbox?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 8, 2012 at 8:04 pm

    #1456929

    Dear Perry

    Thank for your answer

    the autho start is closed , i did test again , its already authomatic , i am not sure what the problem with my first test.

    the question number 3 and 4 its look related to Karberos Authentication. i read many forum and articels and try to configure just like they said, but still not working and Karberos Authentication its look hard to configure and maintenance.

    My question is why my previous Instance using NTLM Authentication (its work fine) and the new instance using Karberos Authentication and its "error 0X80071736" ? , is it posible someone was changed Authentication type on our domain ? and how to switch Authentication type back to NTLM not Karberos.

    Thanks Allot

  • March 9, 2012 at 12:14 am

    #1456984

    What account are the services for each insurance running under?

    Have you checked the SPNs for each instance?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 9, 2012 at 12:51 am

    #1456997

    What account are the services for each insurance running under ?

    i am confused with "What account" ?

    is domain Account , it was domain user, and i am using same account for all instance.

    actualy i already follow some intruction from forum ,but all still not working , it's like

    create DisableLoopbackCheck on LSA Register with value 1;

    create SPN manualy with setSPN

    i have check using setspn -l myaccount , i can see list SPN for my previuse instance, and then i create new SPN for my fail instance and i can see new spn from the list , but i stiil could not brought SQL Server online. is there missing on my step ?

    and for the last . i try to install and configure new instance with domain admin user and still got error 0X80071736,what is happen here ?

  • March 15, 2012 at 3:08 am

    #1459689

    Hai all

    anyone know where the cluster identity , my problem it look "my cluster identity$" can create computer objects on my Active Directory.

    i search on my ADUC , i could not find "my cluster identity$"

    Thanks.

  • March 15, 2012 at 10:33 am

    #1459991

    That will be your cluster name. When you created your cluster you would have given it a name. This then becomes a computer object in AD. You can then grant permissions for that computer object by adding the $ afterwards (when searching AD you'll need to change your search criteria to include computers).

    Example: your cluster is ProdCluster. You can grant permissions for the cluster account to do things using the account ProdCluster$.


    Shamless self promotion - read my blog http://sirsql.net

  • March 15, 2012 at 7:18 pm

    #1460280

    Dear All

    thanks alot for ur help. the problem solved

    Root Couse : the Custer Identity$ "can not" create computer object on my active directory.

    Solve : delegate control create/delete computer object to the Custer Identity$ usind ADUC

    cluster identity is just computer name for Custer on AD, the "$" is identity for Logon Name (pre windows 2000)

    Thanks

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

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