Network-related or instance-specific errors occur when you establish a connection with SQL server.
An error occurred while running the JOB after MSSQL 2005 database backup JOB is configured today:
After some searches, it may be related to the mssql protocol and checked with the local configuration. It is found that the named pipes protocol is not enabled locally. The following method is used:
Enable remote connection on an SQLServer instance
1. Point to "start-> Program-> Microsoft SQL Server 2005-> Configuration tool-> SQL Server peripheral application configurator"
2. on the "SQL Server 2005 peripheral application configurator" page, click "service and connected peripheral application configurator"
3. Click expand database engine, select remote connection, and select local connection and remote connection on the right ",
Select the Protocol to use (TCP/IP and named pipe service should be enabled here !) Click "application" and you will see the following message:
"The changes made to the connection settings will not take effect until the Database Engine service is restarted .", Click OK to return
4. Expand "Database Engine", select "service", click "stop" on the right side, and wait until the MSSQLSERVER service is stopped,
Click Start to restart the MSSQLSERVER service.
Finally, run the JOB again and you can back up the JOB normally.
Refer:
Http://www.cnblogs.com/aiyp1314/archive/2011/07/19/2110950.html