SQL 2008 R2 的SQL代理用 本地系统账户 (SYSTEM)执行,启动时,提示:
SQLServerAgent could not be started (reason: 创建新会话时出错).
SQLServerAgent could not be started (reason: Error creating a new session).
SQL 2012 则提示:
OpenSQLServerInstanceRegKey:GetRegKeyAccessMask failed (reason: 2).
后面发现把操作系统的 SYSTEM 加入SQL的用户列表,并且设为 sysadmin ,然后 SQL代理就可以正常启动了。