I upgraded MsSQL database version from MsSQL Server 2008 Express Edition to MsSQL Server 2008 Enterprise Edition. After upgrade operation, Agent XPs was disabled and MsSQL Server Agent servis could not start. I reconfigured Agent XPs configuration. The problem resolved.<\/p>\n
Management Studio Object Explorer does not display the contents of the SQL Server Agent node unless these extended stored procedures are enabled regardless of the SQL Server Agent service state. <\/p>\n
Agent XPs Possible Values<\/strong><\/p>\n 0<\/strong>, indicating that SQL Server Agent extended stored procedures are not available (the default). Show Current Value<\/strong><\/p>\n EXEC SP_CONFIGURE ‘Agent XPs’<\/p><\/blockquote>\n Reconfigure Agent XPs<\/strong><\/p>\n \nEXEC SP_CONFIGURE ‘show advanced options’, 1; After these parameter change operations you can restart agent service or sql server service to show Agent XPs enabled.<\/p>\n After all operations, If agent service does not start, you can try that Agent service on services.msc user change to local. That can resolve problem.<\/p>\n <\/p>\n Source : Microsoft Offical Documents<\/p>\n","protected":false},"excerpt":{"rendered":" I upgraded MsSQL database version from MsSQL Server 2008 Express Edition to MsSQL Server 2008 Enterprise Edition. After upgrade operation, Agent XPs was disabled and MsSQL Server Agent servis could not start. I reconfigured Agent XPs configuration. The problem resolved. Management Studio Object Explorer does not display the contents of the SQL Server Agent node…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,57],"tags":[64,14,96,46],"class_list":["post-1118","post","type-post","status-publish","format-standard","hentry","category-administration-mssql-server","category-errors-and-solutions-mssql-server","tag-agent-xps-disabled","tag-database-administration","tag-mssql-server","tag-sql-server-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-i2","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1118"}],"version-history":[{"count":4,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1118\/revisions"}],"predecessor-version":[{"id":1475,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1118\/revisions\/1475"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1118"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n1<\/strong>, indicating that SQL Server Agent extended stored procedures are available.<\/p><\/blockquote>\n
\nGO
\nRECONFIGURE;
\nGO
\nSP_CONFIGURE ‘Agent XPs’, 1;
\nGO
\nRECONFIGURE
\nGO<\/p><\/blockquote>\n