Friday, May 2, 2014

SQL serverjob “syspolicy_purge_history” fails with A drive with the name 'D' does not exist.

Going crazy on SQL serverjob “syspolicy_purge_history” I have setup a couple of brand new SQL 2012 clusters with al the laterst servicepack and so on but on all instances we receive the error message below.

Executed as user: DOMAIN\SQLSERVERACCOUNT. A job step received an error at line 1 in a PowerShell script. The corresponding line is 'import-module SQLPS -DisableNameChecking'. Correct the script and reschedule the job. The error information returned by PowerShell is: 'Cannot find drive. A drive with the name 'D' does not exist. '. Process Exit Code -1. The step failed.

After a lot of trouble shooting it seem like the service account for SQL needs to have permission on the root for D:\ I don’t know why, we have SQL binaries on D:\Progrma Files\ Anyway, it´s solved by giving the SQL account read permission to the drive.