We're getting an error message ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message 258) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.
when running an agent job which updates from one Database to another but still on the same server. If we run the job from T-SQL it works fine. Eventually though the service degenerates and we can't run the job as either an agent or a T-SQL script and we have to re-build the server.
Any ideas what would cause this problem and how we can rectify it?Please check your Server network utilities. Make sure that TCP/IP and Named
pipes values are not blank by clicking on the Properties.
thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment