Hi all,
i have problems installing DNN when using the default connection strings:
<!-- 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" />
and
<!-- 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;"/>
I got the the following error.
Error Installing DotNetNuke
Current Assembly Version: 04.03.07
ERROR: Could not connect to database specified in connectionString for SqlDataProvider
In the windows event log there is the following error message.
Ereignistyp: Warnung
Ereignisquelle: ASP.NET 2.0.50727.0
Ereigniskategorie: Web Event
Ereigniskennung: 1309
Datum: 19.02.2007
Zeit: 17:40:11
Benutzer: Nicht zutreffend
Computer: DEAH-LIIS03
Beschreibung:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2/19/2007 5:40:11 PM
Event time (UTC): 2/19/2007 4:40:11 PM
Event ID: 0bcbc47e4e14445e9d1c45a9ead573a1
Event sequence: 6
Event occurrence: 2
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1856257781/Root-1-128163755345179920
Trust level: Full
Application Virtual Path: /
Application Path: D:\DotNetNuke\Philipp\
Machine name: DEAH-LIIS03
Process information:
Process ID: 3412
Process name: w3wp.exe
Account name: NT-AUTORITÄT\NETZWERKDIENST
Exception information:
Exception type: SqlException
Exception message: 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)
Request information:
Request URL:
Request path:
User host address:
User:
Is authenticated: False
Authentication Type:
Thread account name: NT-AUTORITÄT\NETZWERKDIENST
Thread information:
Thread ID: 1
Thread account name: NT-AUTORITÄT\NETZWERKDIENST
Is impersonating: False
Stack trace: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.PurgeLog()
at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.PurgeLogBuffer()
at DotNetNuke.Common.Global.LogEnd()
at DotNetNuke.Common.Global.Application_End(Object Sender, EventArgs E)
Custom event details:
Weitere Informationen über die Hilfe- und Supportdienste erhalten Sie unter http://go.microsoft.com/fwlink/events.asp.
I am sure that have allowed remote connections and my DNN directory has all rights.
My environment is :
Windows 2003 Server
MSSQL 2005 Express
Any suggestions ?
Thanks in advance