Category: SQL 2012
-
Enable and start SQL Server Agent (Agent XPs disabled)
After installing Microsoft SQL Server 2012 I tried to start SQL Server Agent (Agent XPs disabled) in SQL Server Management Studio. Didn’t work and I got a message to enable the agent with sp_configure. 1. Create a new query in SQL Server Management Studio. 2. Execute the following: sp_configure ‘show advanced options’, 1; GO RECONFIGURE;…