Why is using proper ANSI settings important
by Jiri Dolezalek on 20/05/2021You might have been wondering what all those ANSI settings are and how they can affect you work.
Read moreHello again !
recently i have observed some problems with cluster installation in one of my clients. In server logs were those messages:
Message 1:
"Cluster network name resource SQL Network Name 'XXX' failed to create its associated computer object in domain 'XXX' for the following reason:Unable to update password for computer account.
The text for the associated error code is :Access is denied."
Message 2:
'Cluster network name resource 'XXX' failed to register DNS name 'XXX' over adapter 'XXX' for the following reason: DNS operation refused.'
Cause:
Message 1:
Your Windows Cluster machine account has no permission to update SQL Cluster machine account in AD for password change and etc.
Message 2:
The SQL cluster name resource which has been added to the DNS prior to setup need to be updated by the physical nodes on behalf of the resource record itself.
When the active node owns the resources it want to update the A record in the DNS.
Solution:
Hope it helps.
Michal Tinthofer is the face of the Woodler company which (as he does), is fully committed to complete support of Microsoft SQL Server products to its customers. He often acts as a database architect, performance tuner, administrator, SQL Server monitoring developer (Woodler SMT) and, last but not least, a trainer of people who are developing their skills in this area. His current "Quest" is to help admins and developers to quickly and accurately identify issues related to their work and SQL Server runtime.
You might have been wondering what all those ANSI settings are and how they can affect you work.
Read moreAnyway this post should focus on some different distressing news about SQL 2012. If you have current software assurance (SA) for SQL Server 2008 R2, this allows you to slide into SQL Server 2012 while maintaining CAL licensing (by the way this is not pos
Read moreAfter some time, we have finally released big set of changes and fixes for currently known issues. Most visible is new Waiting Task report for operational analysis, added timeline button for Index Usage & recommendation, new functionality to search for an
Read more