"Unable to create computer account on DC" error installing SQL Server 2005 cluster on Windows Server 2008

Windows Server 2008 introduces significant changes to the Windows Cluster Service. The new Windows Cluster security model is one of the most important of these changes and will require seasoned SQL Server administrator to update her/his old-and-trusted knowledge. Some days ago I was facing a problem trying to install a SQL Server 2005 cluster on…

1

Using Windows Cluster log to troubleshoot SQL Server cluster errors

There are times where all the SQL Server knowledge in the world won’t help us to find a solution to our cluster problem. The following post will show you how to use the Microsoft Windows cluster log file to find the root-cause of a common SQL Server issue (it does not matter what SQL Server…

1

Enabling Certificate for SSL on a SQL Server 2005 Clustered Installation

This week I has been working on a case about the installation of a certificate on a SQL Server cluster. My customer wanted to use certificates to encrypt client connections via Secure Sockets Layer (SSL), a method supported by SQL Server 2005 that allows to secure communications between clients and database servers (you can read…

0

Conocer el valor de la Edición Enterprise a través de sencillos ejemplos

This is the Spanish version of this other post. Esta vez sólo deseo anunciar que mi compañero Ignacio Alonso Portillo (Nacho) y yo mismo tenemos planes para comenzar una serie de artículos con ejemplos simples que demuestren, desde un punto de vista práctico, los enormes beneficios proporcionados por aquellas funciones que están sólo disponible en…

0

Understanding the value of the Enterprise Edition with simple examples

This time I just wanted to announce that my colleague Ignacio Alonso Portillo (aka “Nacho”) and myself have plans to start posting some simple examples to demonstrate, from a practical standpoint, the huge benefits provided by all the features which are only available with the Enterprise Edition of SQL Server 2005. Recently, we have been,…

1