Summary

Publising a repository may generate the following error:

Could not start MSSQL$LFPLUS service. GetLastError() returned 2.

Cause

A registry key used by Plus in conjunction with the MSSQL$LFPLUS service may not be correct. This registry key should be updated, in order to allow Plus to publish.

Resolution

This issue can be resolved by modifying the SQLPath registry value, so that it points to the appropriate Windows folder.

To update the SQLPath registry value

1. From the Start menu, select Run.
2. Type the following and the press ENTER to start the Windows Registry Editor.

   regedt32

3. Expand My Computer.
4. Expand HKEY_LOCAL_MACHINE.
5. Expand SOFTWARE.
6. Expand Microsoft.
7. Expand Microsoft SQL Server.
8. Expand 80.
9. Expand Tools.
10. Select ClientSetup.
11. Double-click the SQLPath string value.
12. In the Value data option, type the following:

    C:\Program Files\Microsoft SQL Server\80\Tools

    Note: You may need to adjust the path if you installed Microsoft SQL Server to a different drive or on a non-English operating system.

13. Restart the computer.