October 8, 2013 at 1:54 pm
I'm copying our SQL Jobs from the old SQL 2005 server to our new SQL 2012 server. Every one that I've copied and run, so far, is generating the following error:
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) (Microsoft SQL Server, Error: 121)
This error occurs in just trying to get the SQL Job started - it doesn't even make it to step 1.
I've looked this error up and see that there's a lot of potential causes for it, so yet, I get that it won't be easy to get resolved, but I've got to start somewhere. Especially since now that someone else is managing our server, I've got to know where to begin pointing them to get it resolved.
Kindest Regards, Rod Connect with me on LinkedIn.
October 8, 2013 at 2:50 pm
matter of fact, your answer may be on here,,,
http://www.sqlservercentral.com/Forums/Topic1101492-146-1.aspx#bm1103005
MCSE SQL Server 2012\2014\2016
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply