A network-related or instance-specific error occurred while establishing a connection to SQL Server
Hej AlleSidder og er ved at opgradere min hjemmeside fra access DB til mssql, kan få skidtet til at virke lokalt.
Men på min server går det galt. :(
Det hele køre på en windows server 2003
Med plesk 8.4.0
Databasen prøvet med en 2000 og 2005 version, og den ligger i App_Data mappen som jeg ikke har ændret på.!
Jeg tester det på et subdomæne.
Connectionsstringen ser sådan her ud
<connectionStrings>
<add name="ConnectionString" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|Databasen.mdf;User Instance=true" providerName="System.Data.SqlClient" />
</connectionStrings>
Jeg får denne fejl.
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)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)