When you start the SQL Agent Service you will see that the service start up successfully. Assign this account to the SQL Agent Service via SQL Server Configuration Manager. My preferred approach is to create a dedicated domain account for example: sql_agent_service. The easy solution is to use the SQL Server Configuration Manager to change the SQL Agent Service account to Local Service and then the SQL Agent Service will start up successfully. The problem is that the default account that is created by the SQL Server installation that is used by the SQL Server Agent Service does not have the correct permissions. OpenSQLServerInstanceRegKey:GetRegKeyAccessMask failed (reason 2). In Windows Application Event Viewer the following error message is logged: My first step was to look at trusty old Windows Application Event Viewer to see what messages get logged when I try to start the SQL Server Agent Service. I had a issue with SQL Server Agent Service that cannot start up after creating a new clean installation of SQL Server 2012 with the latest cumulative update (Build.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |