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 . .
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?