c# - No process on the other end of the pipe. Error after restoring DB -

c# - No process on the other end of the pipe. Error after restoring DB -

i restoring db stored procedure web app. accomplish set db single user mode restore replace overwrites current db. after restore set multi_user mode. appears work fine until navigate page runs query producting error. have tried this blog post linking error. after click page , page 1 time again error goes away. ideas what's going on here?

a transport-level error has occurred when sending request server. (provider: shared memory provider, error: 0 - no process on other end of pipe.) type: system.data.sqlclient.sqlexception source: .net sqlclient info provider stack: @ system.data.sqlclient.sqlconnection.onerror(sqlexception exception, boolean breakconnection) @ system.data.sqlclient.tdsparser.throwexceptionandwarning(tdsparserstateobject stateobj) @ system.data.sqlclient.tdsparserstateobject.writesni() @ system.data.sqlclient.tdsparserstateobject.executeflush() @ system.data.sqlclient.tdsparser.tdsexecuterpc(_sqlrpc[] rpcarray, int32 timeout, boolean inschema, sqlnotificationrequest notificationrequest, tdsparserstateobject stateobj, boolean iscommandproc) @ system.data.sqlclient.sqlcommand.runexecutereadertds(commandbehavior cmdbehavior, runbehavior runbehavior, boolean returnstream, boolean async) @ system.data.sqlclient.sqlcommand.runexecutereader

i suspect issue pooled connection got killed , error returned when effort made reuse broken one. seek invoking sqlconnection.clearpool after restore.

c# sql sql-server