Easify Forums

Unhandled exception xp_cmdshell error

Unhandled Exception has occurred in your application following by SQL Server blocked access to procedure 'sys.xp_cmdshell'...

This error is caused when the Easify SQL Database Server permissions have been changed to disallow calls to xp_cmdshell. This error can be caused by many things, the chief of which are:

• Third party software
• Windows updates

We recommend getting in contact with either a local IT professional or one of our partners if you're not confident performing the manual fix we have provided below.

To resolve this issue, close Easify, then follow these steps on the Easify database computer (usually the first computer to be install with Easify).

1. Bring up the Windows Run Command by pressing Windows Key + R

2. Type into the Run Command cmd and press the Enter key to get this window appear:

NOTE: If your command prompt window does not say c:\windows\system32 do the following:

Type C: and press ENTER.

Type cd %systemroot%\system32 and press ENTER.

3. Now type the following into the command line and press the Enter key:

sqlcmd -S .\Easify -U sa -P Eas1fyPeas1fyLemonSqueaz1fy

4. Next right click on the Easify icon on your desktop and click Open file location

5. In the window that appears find the folder with the same name as your company.

I called my company Test Co Ltd, the folder is named TestCoLtd (without spaces)

6. Now back in the command line window type in USE TestCoLtd and press the Enter key (where TestCoLtd is the folder name discussed in step 5 above).

7. Finally you need to enter the following commands, line for line, into the command window:

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

EXEC sp_configure 'xp_cmdshell', 1

GO

RECONFIGURE

GO

If you enter these commands correctly, your command window should look like this:

Now open Easify and the error message should not appear.

We recommend taking a fresh backup of the database at this point.