I have done the following steps to install DotNetNuke v4.8.2 on Windows Server 2003 R2 SP2 with IIS v6.0 and Microsoft SQL Server 2005.
However I have been unsuccessful.
- Uncompressed DotNetNuke to C:\Inetpub\wwwroot\dotnetnuke\.
- Modified file system permissions on C:\Inetpub\wwwroot\dotnetnuke\ granting access to "NETWORK SERVICE" and "ASP.NET Machine Account" to all access excluding full control.
- Edited the two connectionString vaules in C:\Inetpub\wwwroot\dotnetnuke\web.config.
<add name="SiteSqlServer" connectionString="Server=10.10.16.1;Database=DotNetNukeDev;uid=username-here;pwd=password-here;" providerName="System.Data.SqlClient" />
<add key="SiteSqlServer" value="Server=10.10.16.1;Database=DotNetNukeDev;uid=username-here;pwd=password-here;"/>
- Created a new web site in IIS with a home directory of C:\Inetpub\wwwroot\dotnetnuke.
- Created a new MS SQL Server database for DotNetNuke.
- Set permissions on the new database to grant the user being used DBO.
Then I attempted to load the web site in my browser, I see a DotNetNuke web page stating the web site has not been setup yet. I try to reload the page again and this time it goes ot the DotNetNuke installation web page. I follow the instructions step by step with everything working fine, then I get to the database configuration page. I enter the required information and then click "Test Database Settings". I receive "Connection Success" message.
However I seem to randomly reiece an error message after this stage or sometimes righ at the a first attempt at connecting to the server. It appears some how I loose connection or some form of communication to the SQL Server. On the same web page I'll get this now.
Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 16
Number: 2714
Message: There is already an object named 'web_access_RWVersion' in the database.
I have done SQL Server traces to monitor traffic and when this error occurs below there is no connection made to the SQL server. I have double and tripple checked all settings and have had two other people look over them. I can not see for the life of me what is wrong and what is causing this error. I've done tons of searching on Google and on the forums here for help but nothing that matches my situation or a solution that works.
Any help would be greatly appreciated!
This error message was taken from the Event Viewer under Application.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 5/13/2008 11:37:04 AM
Event time (UTC): 5/13/2008 5:37:04 PM
Event ID: be3aa522994441119833c6f9c21fa79c
Event sequence: 4
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/643039121/Root-3-128551738398618016
Trust level: Full
Application Virtual Path: /
Application Path: C:\Inetpub\wwwroot\dotnetnuke\
Machine name: VENMAR-WEBDEV
Process information:
Process ID: 2724
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
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 AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 5
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
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.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues)
at DotNetNuke.Data.SqlDataProvider.GetHostSettings()
at DotNetNuke.Entities.Host.HostSettings.GetHostSettings()
at DotNetNuke.Services.Scheduling.SchedulingProvider.get_SchedulerMode()
at DotNetNuke.Services.Scheduling.DNNScheduling.Scheduler.CoreScheduler.Halt(String SourceOfHalt)
at DotNetNuke.Services.Scheduling.DNNScheduling.DNNScheduler.Halt(String SourceOfHalt)
at DotNetNuke.Common.Initialize.StopScheduler()
at DotNetNuke.Common.Global.Application_End(Object sender, EventArgs e)
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.