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:
- How to Fix RTL8188 “Set Mode” (8B06) Error
- Some problems about startup
- Windows_ Win7 broadband connection prompt remote access connection manager error
- Server Tomcat v7.0 server at localhost failed to start
- win10 unable to start ssh-agent service, error :1058 solution
- Question: cannot create windows service for mysql.error : 0 (install MySQL)
- Under Linux, git cannot be used, prompt sign_and_send_pubkey: signing failed: agent refused operation
- SQL Server 2008 18456 error and SA unable to login solution
- Oracle 12C installation process related errors and Solutions
- Solve the problem of shell script “syntax error near unexpected token `fi’”.
- JDBC connect to Sql Server to connect to the database–The TCP/IP connection to the host localhost, port 1433 has failed
- [flash] error: “necessary system components are not working properly, please repair Adobe Flash Player” and error ා 2046
- CDH opens Kerberos and reports an error: ticket expired
- One of the configured repositories failed (Unknown), and yum doesn’t have enough cached data to cont
- Android ADB command adb devices error: protocol fault (no status)
- Ubuntu starts or restarts SSH service
- Debian using networking to restart the network can not start the solution of network card
- linux docker Error Failed to get D-Bus connection: Operation not permitted
- Ms- settings:personalization-background terms of settlement
- SQL Server “login failed for user ‘domain account”. [sqlstate 28000] (error 18456). “Problem solving