I'm running SQL 2012 on my development machine and this morning I started up and ran some tests in Visual Studio, it become apparent that I couldn't connect.
Everything was working fine yesterday and I haven't made any security related changes to my system in my sleep!
In my Error logs I see:
SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to
SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).
I haven't made any configuration changes that would effect this (as least to my knowledge).
I can open Management studio using Windows and Sql authentication and run queries.
SQL Server and SQL Server Agent both run under the default LocalSystem account.
Running:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO
Reported:
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install.
Remote Connections is enabled SQL Server / Windows Authentication is enabled
All the Protocols are enabled:
Shared Memory TCP/IP Named Pipes VIA
I've been reading for a couple of hours on this now and I cannot figure it out. What's the best course of action now?