Tony,我安装了一台SqlServer服务器,发现无法用Sa用户和集成登录用户,去启动Agent,错误信息提示我权限不够,我不知道怎么弄才可以,有空帮我看看,谢谢了!
---------------------------------
日志信息如下:
2010-10-13 16:32:09 - ! [298] SQLServer Error: 229, The INSERT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2010-10-13 16:32:09 - ! [000] Error creating a new session
2010-10-13 16:32:10 - ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
2010-10-13 16:32:10 - ? [098] SQLServerAgent terminated (normally)
---------------------------------
日志信息如下:
2010-10-13 16:32:09 - ! [298] SQLServer Error: 229, The INSERT permission was denied on the object 'syssessions', database 'msdb', schema 'dbo'. [SQLSTATE 42000]
2010-10-13 16:32:09 - ! [000] Error creating a new session
2010-10-13 16:32:10 - ! [298] SQLServer Error: 15247, User does not have permission to perform this action. [SQLSTATE 42000] (DisableAgentXPs)
2010-10-13 16:32:10 - ? [098] SQLServerAgent terminated (normally)
我是sql server 2005呀,右键点击实例名,只有属性,属性里面的Security,没有你说的设置呀。
1 操作系统及补丁信息
2 安装帐号权限
3 注册帐号权限
4 默认启动sqlserver的帐号(可以在服务里找mssqlserver)
5 没想到