Small Business Susan

Top SQL issues this month

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

http://www.microsoft.com/downloads/info.aspx?na=22&p=13&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3dae7387c3-348c-4faa-8ae5-949fdfbe59c4%26DisplayLang%3den

 

Feature Pack for SQL Server 2005 December 2008

http://www.microsoft.com/downloads/info.aspx?na=22&p=14&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d536fd7d5-013f-49bc-9fc7-77dede4bb075%26DisplayLang%3den

 

 

NEW WEBCASTS

============                

 

MSDN Webcast: BenkoTips Live and On Demand DemoFest: SQL Server 2008, Spatial Data, and the Virtual Earth SDK (Level 300)

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032399812&EventCategory=4&culture=en-US&CountryCode=US

 

SQL Server 2008 Governance – January 15, 2009

http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032396918&EventCategory=2&culture=en-US&CountryCode=US