In this Issue:
TOP SUPPORT ISSUES
NEW & UPDATED KB ARTICLES
NEW & TOP DOWNLOADS
NEW WEBCASTS
RECENT SUPPORT ISSUES
===================
Issue
———-
After you added a SQL Server 2008 to 2005 cluster, you encountered the following errors:
1. The SQL 2008 agent couldn’t be started
2. The SQL 2008 didn’t Failover its working only on the node that installed on it.
Analysis
——–
From SQL Agent error log we found the following information:
2008-11-24 13:09:46 – ! [298] SQLServer Error: 22022, CryptUnprotectData() returned error -2146892987, ‘The requested operation cannot be completed.
The computer must be trusted for delegation and the current user account must be configured to allow delegation.’ [SQLSTATE 42000]
It indicates that the SQL Agent account can’t be delegated. Based on the error, we suspect that SQL Agent account is one of the following: (Could you please double check the credentials )
1. Domain administrator member.
2. The account isn’t configured to be trusted for delegation.
Resolution
————–
1. Change the SQL Server Agent startup account to a non-domain administrator user account.
Note: The user account must have the appropriate rights to start service.
2. In the Active Directory Users and Computers snap-in, enable the SQL Server service account to be trusted for delegation.
For more information, please refer to:
Re: SQL Server 2005 SQL Agent Startup Issue -SQLServer Error: 22022,
CryptUnprotectData()
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3737615&SiteID=1
You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server is 3179 or a later build
http://support.microsoft.com/kb/943525
NEW & UPDATED KB ARTICLES
=========================
Access
——
957690 Description of the Access 2007 hotfix package (Access.msp): October 28, 2008
http://support.microsoft.com/default.aspx?scid=kb;EN-US;957690
SQL
—-
957826 Where you can find more information about the SQL Server 2008 builds that were released after SQL Server 2008 and the SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2
http://support.microsoft.com/default.aspx?scid=kb;EN-US;957826
957807 FIX: A new node is not added to a SQL Server 2008 Analysis Services cluster or a SQL Server 2008 Reporting Services cluster if the SQL Server 2008 Database Engine is not installed
http://support.microsoft.com/default.aspx?scid=kb;EN-US;957807
NEW & TOP DOWNLOADS
====================
SQL Server 2005: for Administrators Datasheet
SQL Server 2005: Performance Tuning and Optimization Datasheet
SQL Server 2000: Performance Tuning and Optimization Datasheet
Risk and Health Assessment for Microsoft SQL Server Datasheet
SQL Server 2005 SP3
Feature Pack for SQL Server 2005 December 2008
NEW WEBCASTS
============
MSDN Webcast: BenkoTips Live and On Demand DemoFest: SQL Server 2008, Spatial Data, and the Virtual Earth SDK (Level 300)
SQL Server 2008 Governance – January 15, 2009