In the Configuration Distribution Wizard, the “Configure SQL Server Agent Auto-Start” step has the following text error:
TITLE: Configure Distribution Wizard ------------------------------ An error occurred configuring SQL Server Agent. ------------------------------ ADDITIONAL INFORMATION: RegCreateKeyEx() returned error 5, 'Access is denied.' (Microsoft SQL Server, Error: 22002)
This is a very minor error that is not difficult to fix. The wizard is trying to change the “startup mode” of the SQL Server proxy service to “automatic”. You can do this with the SQL Server Configuration Manager
In the Sysinternals process monitor, you may see: Operation:RegCreateKeyResult:AccessDeniedPath: “HKLM\System\CurrentControlSet\Services\SQLAgent$SQL2012 “If you encounter this error, please refer to the Configuration Distribution Wizard’s “Select “No” on the SQL Server Agent Startup page (shown below) and set your agent service to auto-start mode through SQL Server Configuration Manager.
Read More:
- SQL Server import MDF and LDF files appear: unable to open physical file “D:\ XX.mdf “。 Operating system error 5: “5 (access denied. ）”Solutions
- ER_ACCESS_DENIED_ERROR: Access denied for user ‘root‘@‘localhost‘ (using password: NO)
- 【docker】 denied: requested access to the resource is denied
- Error code 1045, state 28000, Java sql.SQLException :Access denied for user ‘root’@’localhost’
- Unable to install SQL Server (setup.exe), VS Shell installation has failed with exit code 1638.
- An error is reported when the laptop is turned on: image failed to verify with * access denied* press any key to continue
- Win32 Disk Imager Error 5: Access is Denied solution
- HTTP Error 401.1 – Unauthorized:Access is denied due to invalid credentials
- Unable to open the physical file “d:\***.mdf”. Operating system error 5: “5(Access is denied.)”.
- SQL 2005 remote connection error (provider: SQL network interface, error: 28 – the server does not support the requested protocol
- Net start mongodb failed to start: system error 5 has occurred. Access is denied
- About installing SQL server 0 in Windows 10 20h2 × 84bb0001 is one of the solutions
- Failed to create agent because there is no valid NavMesh
- Failed: error connecting to db server: server returned error on SASL authentication step: Authentica
- openservice ERROR_ACCESS_DENIED
- Install sql2012 prompt setup account privileges failed solution
- SQL Server 2008 18456 error and SA unable to login solution
- Error 1045 (28000) access denied for user ‘root’ @’localhost ‘appears in MySQL under Windows system
- Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: no)
- Error 1045 (28000): solution to access denied for user ‘root’ @’localhost ‘(using password: no)