none
Ajuda com SQL server 2008 e aplicativo ASPNET RRS feed

  • Pergunta

  • Oi gente mais uma vez recorro a vcs. Sou novo em ASP Fiz um aplicativo e esta funcionando beleza no VS2010 mas quando tento implementar na maquina que tem o  IIS e o SQL SERVER 2008 recebo o seguinte erro.

     

    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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    E se o acesso for remoto este outro:

    Runtime Error

    Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

    Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

    <!-- Web.Config Configuration File -->
    
    <configuration>
      <system.web>
        <customErrors mode="Off"/>
      </system.web>
    </configuration>

    Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.

    <!-- Web.Config Configuration File -->
    
    <configuration>
      <system.web>
        <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
      </system.web>
    </configuration>

    OBS: A maquina de nome "Desktop" é servidor de WEB e servidor SQL tambem tudo na mesma maquina  a connectionstrings é a seguinte:

    <connectionStrings>

    <

     

     

    add name="ApplicationServices" connectionString="data source=Desktop\SQLEXPRESS;Initial Catalog=ASPNETDB;Integrated Security=True"

     

     

     

    providerName="System.Data.SqlClient" />

    <

     

     

    add name="ConnectionString" connectionString="Data Source=Desktop\SQLEXPRESS;Initial Catalog=giga;Integrated Security=True"

    providerName="System.Data.SqlClient" />

    <

     

     

    add name="GigaConnectionString" connectionString="Data Source=Desktop\SQLEXPRESS;Initial Catalog=giga;Integrated Security=True"

     

     

     

    providerName="System.Data.SqlClient" />

    </

     

     

    connectionStrings>

     

    quarta-feira, 14 de julho de 2010 04:39

Respostas

  • Fala Ghissoni,

    Menu Iniciar > Programas > Sql Server 2008 > Configuration Tools > Sql Server Configuration Manager

    Em Sql Server Network Configuration, habilite os protocolos TCP/IP e Named Pipes

     


    Forte abraço,

    André Borges Medeiros
    MCT, MCPD, MCTS

    >> Se a resposta solucionar sua dúvida, favor Votar como Útil
    quinta-feira, 15 de julho de 2010 12:35
    Moderador