Bonjour,
Je tente en vain d'installer DotNetNuke 04.05.00, j'obtiens l'erreur:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Mon serveur Web:
- Windows 2003 Server:
- IIS 6
- ASP.NET 2.0.50727
Ma base UPI_DNN est sur un autre serveur:
- Windows 2003 Server
- SQL 2000
Le compte local : NETWORK SERVICE à les droit de modification sur mon répertoire
Mon compte SQL: "upi_dnn" ansi que "dbo" ont les droits sur ma base:
extrait du web.config:
extrait du <connectionStrings>:
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express <add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" /> -->
<!-- Connection String for SQL Server 2000/2005 -->
<add
name="SiteSqlServer"
connectionString="Server=Mon_Serveur_SQL\Mon_Instance_SQL;Database=UPI_DNN;uid=upi_dnn;pwd=MonMotDePass;"
providerName="System.Data.SqlClient" />
</connectionStrings>
extrait du <appSettings>:
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules <add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/> -->
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Server=Mon_Serveur_SQL\Mon_Instance_SQL;Database=UPI_DNN;uid=upi_dnn;pwd=MonMotDePass;"/>
<add key="InstallTemplate" value="DotNetNuke.install.config" />
<add key="AutoUpgrade" value="true" />
<add key="UseInstallWizard" value="true"/>
<add key="InstallMemberRole" value="true" />
<add key="ShowMissingKeys" value="false" />
<add key="EnableWebFarmSupport" value="false" />
<add key="EnableCachePersistence" value="false"/>
<add key="HostHeader" value="ASTI.dj.sncf.fr/UPI2/Default.aspx" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
<add key="RemoveAngleBrackets" value="false" /><!--optionally strip angle brackets on public login and registration screens-->
<add key="PersistentCookieTimeout" value="0" /><!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure-->
</appSettings>
extrait du <Providers>:
<providers>
<clear/>
<add name="AspNetSqlMembershipProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="SiteSqlServer"
enablePasswordRetrieval="true"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
minRequiredPasswordLength="7"
minRequiredNonalphanumericCharacters="0"
requiresUniqueEmail="false"
passwordFormat="Encrypted"
applicationName="UPI_DNN"
description="Stores and retrieves membership data from the local Microsoft SQL Server database" />
</providers>