November 5, 2011 at 12:51 am
Iam not able to bring the MSDTC resorce online. This is on windows 2008 R2 (SP1). I have create computer objects permission and manually also I have created the resource name in the AD computers. But it still fail.
Please do help.
Error
==========
Cluster network name resource 'mssqldtc' failed to create its associated computer object in domain 'sapient.com' for the following reason: Unable to create computer account.
The text for the associated error code is: Access is denied.
Please work with your domain administrator to ensure that:
- The cluster identity 'sql2008WIN$' can create computer objects. By default all computer objects are created in the 'Computers' container; consult the domain administrator if this location has been changed.
- The quota for computer objects has not been reached.
- If there is an existing computer object, verify the Cluster Identity 'PSSTWIN$' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool.
"More Green More Oxygen !! Plant a tree today"
November 6, 2011 at 6:42 am
You should try what follows:
Create manually the object named "mssqldtc"of type "computer" in your AD Domain through Active Directory Users & Computers. Disable it and then try again to bring your ressource online.
Let me know if you achieved your goal.
Kind regards
November 6, 2011 at 3:29 pm
Minaz Amin (11/5/2011)
Iam not able to bring the MSDTC resorce online. This is on windows 2008 R2 (SP1). I have create computer objects permission and manually also I have created the resource name in the AD computers. But it still fail.Please do help.
Error
==========
Cluster network name resource 'mssqldtc' failed to create its associated computer object in domain 'sapient.com' for the following reason: Unable to create computer account.
The text for the associated error code is: Access is denied.
Please work with your domain administrator to ensure that:
- The cluster identity 'sql2008WIN$' can create computer objects. By default all computer objects are created in the 'Computers' container; consult the domain administrator if this location has been changed.
- The quota for computer objects has not been reached.
- If there is an existing computer object, verify the Cluster Identity 'PSSTWIN$' has 'Full Control' permission to that computer object using the Active Directory Users and Computers tool.
Check in AD whether the computer account already exists
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 6, 2011 at 10:15 pm
Thanks Perry manually creating the computer objects in AD for MSDTC and restarting the service had helped me, but Iam once again receiving the same type of error for SQL Serevr installation. In input on this.
2011-11-06 11:44:54 Slp: Exception: Microsoft.SqlServer.Configuration.Cluster.ClusterException.
2011-11-06 11:44:54 Slp: Source: Microsoft.SqlServer.Configuration.Cluster.
2011-11-06 11:44:54 Slp: Message: The cluster resource 'SQL Server (SQLCLUST)' could not be brought online. Error: The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736).
2011-11-06 11:44:54 Slp: Inner exception:
2011-11-06 11:44:54 Slp: Exception: System.Runtime.InteropServices.COMException.
2011-11-06 11:44:54 Slp: Source: Microsoft.SqlServer.Interop.MSClusterLib.
2011-11-06 11:44:54 Slp: Message: The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736).
"More Green More Oxygen !! Plant a tree today"
November 6, 2011 at 10:47 pm
I had a similar thing happen just this last week. I had to delete the cluster resource and then recreate it.
The other note that seems interesting is that you got it working for a bit and then it seems that AD went hinky on you again. Have you checked with the Domain Admin to see if there are Domain issues or DC issues?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 7, 2011 at 10:45 am
Windows 2003 or Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 7, 2011 at 11:07 am
Perry Whittle (11/7/2011)
Windows 2003 or Windows 2008 cluster?
Me? 2003
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply