Sql-server – The system cannot find the file specified

ola-hallengrensql server

I'm running into a problem when trying to run any of the jobs created by Ola's script:

The process could not be created for step 1 of job
0x19DAD4A7019FB04D9C984027FCA2F4E3 (reason: The system cannot find the
file specified). The step failed.

I've made sure that sqlcmd is in the PATH environment variable, and I've also put the sql agent service account in local administrators to make sure it isn't a permission issue.

When I log into the server locally with an account that has local admin rights and sysadmin on the sql server and try to run sqlcmd.exe I get the following:

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Named Pipes
Provider: Could not open a connection to SQL Server [2]. .

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : Login timeout
expired.

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server : A
network-related or instance-specific error has occurred while
establishing a connection to SQL Server. Server is not found or not
accessible. Check if instance name is correct and i f SQL Server is
configured to allow remote connections. For more information see SQL
Server Books Online..

Has anyone else run into this issue?

Best Answer

This ended up being a permission issue to the path where sqlcmd resides.