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>