Error SQL Job output may display:
Executed as user: <username>. Imceda slssqlmaint Utility. Logging on to SQL Server '<servername>' with Windows Authentication EOleException - [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied C:\Program Files\Microsoft SQL Server\MSSQL\Binn\slssqlmaint.exe Process Exit Code: 1 (Failed) [SQLSTATE 010
na
WORKAROUND:
Run the "Extended Stored Procedure installation" via "Instance Configuration. Running the "Extended Stored Procedure installation" deletes the old stored procedures and recreates them.
Verify the following settings:
From Query Analyzer run the following command and note the output xp_sqllitespeed_version
Verify, via the Client Network Utility the protocols in use.
Run a test backup manually (using a script) from the Query Analyzer with @logging = 2.
Run the maintenance plan manually from the command line specifying SA login.
To further the troubleshooting process, Support may request:
1. The output of your MSDB.sysdbmaintplan_history.
2. The script that is being used in the Job Step by the maintenance plan.
na
