The error 1067 typically occurs with the SQL service or some other similar service. That said, it can also be related with other services. It occurs when you attempt to execute an action that requires a service to run.
Thankfully, there are many ways to solve this error. In this post, I’ve listed some of the more common ones, all of which have worked for other users in the past.
I recommend you to start with the first solution, and if that doesn’t work, then to move on to the second one and so on.
Manage the Service
More often than not, the error 1067 is associated with various permissions. That’s why, giving the access of the service controls to your profile works for so many people to fix the problem.
You should try this solution before attempting any other. This is because it works regardless of the service that’s causing the error. Also taking control of a service is easy and quick.
Here are the steps to follow:
- Press the Windows key + R to launch the Run box
- Type services.msc and press the Enter key. This will launch the Services tool
- Browse through the list of services in the right pane, locate the one that is associated with the error, right-click it and choose Properties
- Check whether the service is running. If yes, click the Stop button to stop it. In case the service is already stopped, leave it is as it is. Now click the second tab in the list—Log On. Then click the Browse button
- Type the name of your account in the “Enter the object name to select” section, and click Check Names
- Once your name shows up in the list, click the OK button and type the password (if you have set up one, that is).
The service should start now and the error 1067 should stop appearing.
Reinstall the Service That’s Giving the Error
If the previous solution didn’t work, you can try this one. However, mind you, this is a little more advanced than the previous one. You can use this method to restart a problematic service in case you aren’t able to launch it using the Services tool.
Important – This steps involve deleting a registry key. You should proceed only if you are confident about tweaking the Windows registry. You should always make a registry backup before making any sort of changes to it. This will help you restore Windows registry to its prior state in case any problem occurs due to the changes made by you.
First, let’s see how to back up Windows registry.
- Click the Windows key + R to launch the Run box
- Type regedit and press the Enter key to launch the Registry Editor
- In the Registry Editor window, click the File menu and then click Export
- Select a suitable location for backup, give the backup file a name and then finally click the Save button.
Now that we have made a registry backup, let’s see how to restart a service using the Registry Editor tool.
- Click the Windows key + R to launch the Run box
- Type regedit and press the Enter key to launch the Registry Editor
- In the Registry Editor window, browse to the following key in left pane: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
- Now once you have opened the Services key, locate the key that’s causing the problem. Right-click it and select the Delete option. If any dialog box pops up, confirm your action.
- Reboot Windows
In case you couldn’t remove this key, it means you need more permission. You can add extra access without leaving Registry Editor.
Here’s what you need to do:
- Right-click the service key that’s giving you the error, click the permission option
- Locate the computer’s username under user names or Group names option. In case you are unable to find it, click Add | Advanced | Find Now. Now your user account will show up in the search results, select it and then click the OK button two times
- Select your account and tick the Full Control checkbox below Permissions for (Your user name). Now apply the new changes
- Now try to delete the problematic service key again. Don’t forget to reboot Windows once you are done
- After Windows has restarted, run a SFC scan (instructions for this are given ahead) to help you find the deleted service and bring it back.
Now check whether the problem is resolved or not.
Delete Specific Files
This is the easiest method to fix the error 1067 if it’s associated with the MYSQL Service. All that it requires is you stop the service and remove a few log files.
Here are the steps to follow:
- Click the Start menu and select Control Panel
- In the Control Panel window, set the View by option to Large Icons. Now scroll down to locate Administrative Tools, click it, locate Services shortcut in the list, and then finally click it
- Now browse the list until you see the MYSQL service, right-click it, choose Properties. Now click Stop and then click OK
- Now browse to the folder where MYSQL is installed. This is usually the C>> Program Files folder. Alternately MYSQL might be installed in the C>> Program Files (x86) folder. Open the folder that has MYSQL and then double-click “data” folder
- Look for these two files—ib_logfile0 and ib_logfile1, right-click them one by one and click the Delete button
- Now go back to the Service window. Right-click MYSQL service and select Properties and click Start
- Now check if the issue is fixed
Tweak MYSQL Configuration Files
If the problem persists, try this solution. There’s an option inside the “my.ini” file, the MYSQL configuration file, that can cause error 1067. Disabling or deleting this option can help fix the issue.
Here are the steps to follow:
- Go to the folder where MYSQL is installed. As said earlier, it will be either of these two folders: C>> Program Files folder or C>> Program Files (x86)
- Open the folder with MYSQL and locate the my.ini file
- Right-click it and open it with Notepad
- Click the Ctrl key + F, type innodb_flush_method and check if you get any search result. If you do, set the entry to innodb_flush_method=normal
- In case there’s no innodb_flush_method command, add innodb_flush_method=normal to the file, and then click Ctrl key + S to save the changes
- Now check if the problem is resolved
In case the issue still persists, you’ll need to edit “my-default.ini” file. Here are the steps to follow:
- Locate “my-default.ini” file in the root folder (that is, the folder which has MYSQL) and open this file
- Right click it and open it with Notepad
- Make sure everything below the mysqld line is as shown below
- Now save the changes by clicking Ctrl key + S
Reinstall SQL Server
Performing a clean install of the program will fix the problem once and for all. The thing about clean install is that removes all files, including temporary files that can also at times trigger the error 1067.
Here are the steps to follow:
- You will need to log in with the admin account; otherwise you can’t uninstall SQL server
- Are there some databases you would rather like to preserve? If yes, take their backups before you proceed further. This is important because, as said earlier, a clean install will remove all old files, down to the last one.
- Click Start menu and then select Control Panel
- In the Control Panel window, set the View by to Category and then click Uninstall a Program (in Programs section)
- Click Apps in case you use Settings app. All the installed apps, as well as programs, will show up on your screen
- Browse through the list to locate SQL Server, and click on this entry. Now click Uninstall (you will see it above the displayed list), and then follow on-screen instructions to complete the uninstallation of SQL Server
- Restart Windows
Once this is done, don’t forget to remove data in the registry related to Spotify.
Here are the steps to follow.
Important – Don’t forget to make a registry backup before completing these steps. If you have made a backup, you will be able to easily restore Registry in case a problem occurs because of the changes made by you.
- Click the Windows key + R to launch the Run box
- Type regedit and press the Enter key
- In the Registry Editor window, locate and delete these two keys
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQL Server
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
- Now delete these keys (both of them are associated with the SQL Server)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
- Search your computer for folders referencing SQL. Next. rename all such folders.
- Restart Windows
- Go here and download SQL tool. Save the downloaded file in a suitable location and double-click. Follow on-screen instructions to complete installation.
Now check if the error is fixed.
Fix for EAServer Service
The Error 1067 can occur just when EAServer is starting. If that’s what is happening in your case, use this step to fix the issue. Usually what happens is that a registry key associated with the service becomes corrupt, possibly following an update, and that in turn causes the error.
Important – Make a registry backup before attempting these steps.
Here are the steps to follow:
- In the Registry window, navigate to this key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
- Under Services, check if there’s an EAServer entry. If yes, click it to see all the registry keys related to it
- Now locate a key called SERVERNAME, and then right-click it and select Modify. Type EASERVER under Value data bar. Save the changes and then check if the issue is fixed
Leave a Reply