System.Exception: Problema de acesso aos dados. ---> System.Exception: [APP]Problema de acesso aos dados. [SQL origem] SELECT indTipoPessoa, tipoFrete, idRevenda, idSistema, Nome, ISNULL(CNPJ,'') AS CNPJ, ISNULL(Inscricao,'') AS Inscricao, ISNULL(RazaoSocial, '') AS RazaoSocial, ISNULL(Endereco,'') AS Endereco, Numero, Complemento, ISNULL(CEP,'') AS CEP, ISNULL(Bairro,'') AS Bairro, ISNULL(Cidade, '') AS Cidade, idCidade, codCidade, Estado, ISNULL((SELECT Nome FROM GEN_Estado WHERE Estado = R.Estado),'') AS nomEstado, Pais, idVendedor, ISNULL((SELECT gc.dscEmpresa FROM GEN_Custom as gc WHERE gc.idRevenda = R.idRevenda),'') AS sobre, DDD, ISNULL(Telefone,'') AS Telefone, DDDCelular, ISNULL(Telefone2,'') AS Telefone2, Operadora, indWhatsApp, ISNULL(Telefone3,'') AS Telefone3 , ISNULL(Contatos,'') AS Contatos, ISNULL(Email,'') AS Email, emailCelular, ISNULL(finEmail, Email) AS finEmail, ISNULL(Website,'') AS Website, indVendoCompro, indLogo, indAtivo, indAlteraDados, indSuspenso, indExcluido, indAnunciante, indAnuncioFixo, indBanner, indTimbrado, indServico, ISNULL(indForcaAgricola,0) AS indTEC, ISNULL(indCaminhoesCarretas,0) AS indCEC, idRamoAtividade, nomCobranca, ISNULL(Facebook, '') AS Facebook, ISNULL(Twitter, '') AS Twitter, ISNULL(Google, '') AS Google, ISNULL(Youtube, '') AS Youtube, ISNULL(Linkedin, '') AS Linkedin, indRevenda, seqBanner, urlBanner, indBannerFixo, indBannerPosicao, datContrato, idTipoWebSite, datCriacao, datUltimoAcesso, indDestaque, nroBoleto, ISNULL(idMatriz,0) AS idMatriz, isnull(geoLocation.Lat,0) AS geoLatitude, ISNULL(geoLocation.Long,0) AS geoLongitude, ISNULL(geoZoom,0) AS geoZoom, indCaminhoesCarretas, indForcaAgricola, indTipoPessoa, indBannerCEC, indBannerTEC, isnull(idCategoria,0) AS idCategoria, R.idMarca, idOrigem , idRamoAtividade, indExisteLogotipo, ISNULL(indImportaVeiculo,0) AS indImportaVeiculo, (SELECT COUNT(RC.idRevenda) FROM GEN_RevendaContrato AS RC INNER JOIN GEN_PlanoPgto AS PP ON RC.idPlano = PP.idPlano WHERE RC.idRevenda = R.idRevenda AND (PP.indLogotipo = 1) AND (RC.datInicioCobranca < GETDATE()) AND (RC.datCancelamento IS NULL OR RC.datCancelamento + 1 > GETDATE())) AS indLogotipo, (SELECT COUNT(RC.idRevenda) FROM GEN_RevendaContrato AS RC INNER JOIN GEN_PlanoPgto AS PP ON RC.idPlano = PP.idPlano WHERE RC.idRevenda = R.idRevenda AND (PP.indWebSite = 1) AND (RC.datInicioCobranca < GETDATE()) AND (RC.datCancelamento IS NULL OR RC.datCancelamento + 1 > GETDATE())) AS indWebSite, (SELECT COUNT(RC.idRevenda) FROM GEN_RevendaContrato AS RC INNER JOIN GEN_PlanoPgto AS PP ON RC.idPlano = PP.idPlano WHERE RC.idRevenda = R.idRevenda AND (PP.indLinkSite = 1) AND (RC.datInicioCobranca < GETDATE()) AND (RC.datCancelamento IS NULL OR RC.datCancelamento + 1 > GETDATE())) AS indLinkSite, ISNULL((SELECT TOP 1 idPlano FROM GEN_RevendaContrato AS RC WHERE RC.idRevenda=R.idRevenda AND RC.datInicioCobranca <= GETDATE() AND Rc.datCancelamento+1 > GETDATE() ORDER BY (CASE WHEN idPlano=79 then 0 ELSE 1 END)),0) AS planoContrato, finNome, finTelefone, finEmail, ISNULL(tipoEnvioBoleto, 'BNC') as tipoEnvioBoleto, ISNULL(idAgenciaConta, 0) as idAgenciaConta , ISNULL((select top 1 indPortal from gen_revendacontrato as rc inner join GEN_PlanoPgto as pp on rc.idPlano=pp.idplano where idrevenda=r.idRevenda and datInicioCobranca < getdate() and datCancelamento+1 >= getdate() and indBonus=0 and indPatrocinado=0 and indCortesia=0 order by pp.indEstoque DESC, pp.indServico DESC, valor DESC),'') AS indSitePrincipal , indIgnorarBloqueioAutomatico, ISNULL(nomMarca,'') as nomMarca, Abertura, Fechamento, AberturaSabado, FechamentoSabado, DiasSemana, indForaHorario, indAnunciarHorario, token_MLB, datToken , indGotaDagua, indGotaDaguaPosicao, indMarcaPortal, planoML, token_FB, datToken_FB, tokenPage_FB, idPage_FB, indMarcaIntegracao from GEN_Revenda R LEFT JOIN CLI_Marca AS M on R.idMarca=M.idMarca WHERE idRevenda = 874 ---> System.Data.SqlClient.SqlException: 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) ---> System.ComponentModel.Win32Exception: The network path was not found --- End of inner exception stack trace --- at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at GrupoPLA._Matrix.Matrix.RecuperarDataset(String SQL) --- End of inner exception stack trace --- at GrupoPLA._Matrix.Matrix.RecuperarDataset(String SQL) at GrupoPLA.Cliente.Cliente..ctor(Int32 id) in C:\TRABALHO\GRUPOPLA\GrupoPLA.Cliente\GrupoPLA.Cliente\Cliente.cs:line 229 --- End of inner exception stack trace --- at GrupoPLA.Cliente.Cliente..ctor(Int32 id) in C:\TRABALHO\GRUPOPLA\GrupoPLA.Cliente\GrupoPLA.Cliente\Cliente.cs:line 315 at MasterPage.CarregarPagina() in c:\inetpub\wwwroot\autogerenciador.com.br\Templates\Template Sport\MasterPage.master.cs:line 68