Logger processes crashes after upgrade to SQL Server 2008 R2

From DocWiki

Jump to: navigation, search

Logger processes crashes after upgrade to SQL Server 2008 R2

Problem Summary After you upgrade from SQL Server 2005 to SQL Server 2008 R2, the logger processes crashes.
Error Message from the clgr log:
SQL Server User Error: 229, State 5, Severity: 14, Message: The SELECT permission was denied ... dbsqlexec failed.
Possible Cause Missing BUILTIN\Administrators users or missing server role "sysadmin" for BUILTIN\Administrators
Recommended Action Manually add BUILTIN\Administrators:
  1. Open SQL Server Managerment Studio.
  2. Go to Security > Logins.
  3. Add New Login for BUILTIN\Administrators.
  4. Select "sysadmin' for Server Roles for BUILTIN\Administrators.
Release   9.0(1)
Associated CDETS #

Rating: 0.0/5 (0 votes cast)

Personal tools