Exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Controller: CompResult
Action: CompResultCity 
                   at SalarySEOMVC.Gadgets.DataLayer.InvokeStoreProcedure(String storeProcedureName, String connName, String storeProInputParamVarName, Object[] storeProParamValue) in F:\SalaryCool\WebSites\SalarySEOMVC\SalarySEOMVC-Stg\SalarySEOMVC\Gadgets\DataLayer.cs:line 426
   at SalarySEOMVC.Models.LocationModel.GetLocationInfoByZipCityStateJob(String jobCode, String zipCode, String city, String stateCode) in F:\SalaryCool\WebSites\SalarySEOMVC\SalarySEOMVC-Stg\SalarySEOMVC\Models\LocationModel.cs:line 499
   at SalarySEOMVC.Controllers.CloudCompResultController.SetLocationInfoToJobModel(JobModel job, String payType, LocationModel location) in F:\SalaryCool\WebSites\SalarySEOMVC\SalarySEOMVC-Stg\SalarySEOMVC\Controllers\Cloud\CloudCompResultController.cs:line 135
   at SalarySEOMVC.Controllers.CloudCompResultController.Index(String Keyword, String SearchType, ControllerContext controllerContext, String StateCode, String City) in F:\SalaryCool\WebSites\SalarySEOMVC\SalarySEOMVC-Stg\SalarySEOMVC\Controllers\Cloud\CloudCompResultController.cs:line 73
   at SalarySEOMVC.Controllers.CompResultController.CompResultCity(String Keyword, String State, String City, String SearchType) in F:\SalaryCool\WebSites\SalarySEOMVC\SalarySEOMVC-Stg\SalarySEOMVC\Controllers\Cloud\CompResultController.cs:line 73
   at lambda_method(Closure , ControllerBase , Object[] )
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass42.<BeginInvokeSynchronousActionMethod>b__41()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass37.<>c__DisplayClass39.<BeginInvokeActionMethodWithFilters>b__33()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b__49()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.<>c__DisplayClass2a.<BeginInvokeAction>b__20()
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass25.<BeginInvokeAction>b__22(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult)
   at System.Web.Mvc.Controller.<>c__DisplayClass1d.<BeginExecuteCore>b__18(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar)
   at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar)
   at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)
   at System.Web.Mvc.MvcHandler.<>c__DisplayClass8.<BeginProcessRequest>b__3(IAsyncResult asyncResult)
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass4.<MakeVoidDelegate>b__3(IAsyncResult ar)
   at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)