Small Business Susan

Migratin' over from SBSDiva

Home

Top SQL issues this month

On January 15, 2009, in SQL Server, by

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

http://www.microsoft.com/downloads/info.aspx?na=22&p=4&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d1cfb760c-a3fa-4e50-9fc3-0e7c9819d51f%26DisplayLang%3den

SQL Server 2005: Performance Tuning and Optimization Datasheet

http://www.microsoft.com/downloads/info.aspx?na=22&p=6&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d9b180e91-34e7-4274-9a4f-78562b926358%26DisplayLang%3den

SQL Server 2000: Performance Tuning and Optimization Datasheet

http://www.microsoft.com/downloads/info.aspx?na=22&p=7&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d0556317d-66c3-4a6d-a128-4d6f873a28b3%26DisplayLang%3den

Risk and Health Assessment for Microsoft SQL Server Datasheet

http://www.microsoft.com/downloads/info.aspx?na=22&p=8&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d8d54db4d-3232-4cf8-8ba5-e80557835421%26DisplayLang%3den

SQL Server 2005 SP3