OK, maybe I am dense because nothing is working. I have enabled windows and SQL authentication in the SQL server and restarted the server and no difference. Maybe it will help if I give you the various error messages. In the SQL server logs when I try to go to http://localhost/dotnetnuke
in my browser on the local machine I get a failure to log in. The first messages in theSQL Server log is "Error: 18456, Severity: 14, State: 6" then I get "Login failed for user 'DSD-WIN\dnnuser'. [CLIENT: ]" Then the next two lines in the log are "Login succeeded for user 'DSD-WIN\dnnuser'. Connection: trusted. [CLIENT: ]" and then "Login succeeded for user 'NT AUTHORITY\NETWORK SERVICE'. Connection: trusted. [CLIENT: ]".
What would cause the server to reject the login once and then immediately accept it?
In the browser window, the full error is Error Installing DotNetNuke
Current Assembly Version: 04.00.02
ERROR: Could not connect to database specified in connectionString for SqlDataProviderSystem.Data.SqlClient.SqlException: Login failed for user 'DSD-WIN\dnnuser'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /************************************************************/ /***** Initialization Script *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and dnn_ *****/ /***** *****/ /************************************************************/ if exists (select * from dbo.sysobjects where id = object_id(N'Version') and OBJECTPROPERTY(id, N'IsTable') = 1) begin if 'dnn_' <> '' begin EXECUTE sp_rename N'dbo.Version', N'dnn_Version', 'OBJECT' EXECUTE sp_rename N'PK_Version', N'PK_dnn_Version', 'OBJECT' EXECUTE sp_rename N'IX_Version', N'IX_dnn_Version', 'INDEX' ALTER TABLE dbo.dnn_Version ADD CONSTRAINT IX_dnn_Version UNIQUE NONCLUSTERED ( Major, Minor, Build ) ON [PRIMARY] end end else begin if not exists (select * from dbo.sysobjects where id = object_id(N'dnn_Version') and OBJECTPROPERTY(id, N'IsTable') = 1) begin CREATE TABLE dbo.dnn_Version ( [VersionId] [int] IDENTITY (1, 1) NOT NULL , [Major] [int] NOT NULL , [Minor] [int] NOT NULL , [Build] [int] NOT NULL , [CreatedDate] [datetime] NOT NULL ) ON [PRIMARY] ALTER TABLE dbo.dnn_Version WITH NOCHECK ADD CONSTRAINT [PK_dnn_Version] PRIMARY KEY CLUSTERED ( [VersionId] ) ON [PRIMARY] ALTER TABLE dbo.dnn_Version ADD CONSTRAINT IX_dnn_Version UNIQUE NONCLUSTERED ( Major, Minor, Build ) ON [PRIMARY] end end System.Data.SqlClient.SqlException: Login failed for user 'DSD-WIN\dnnuser'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dnn_GetDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.dnn_GetDatabaseVersion System.Data.SqlClient.SqlException: Login failed for user 'DSD-WIN\dnnuser'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.dnn_GetDatabaseVersion as select Major, Minor, Build from dnn_Version where VersionId = ( select max(VersionId) from dnn_Version ) System.Data.SqlClient.SqlException: Login failed for user 'DSD-WIN\dnnuser'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dnn_FindDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.dnn_FindDatabaseVersion System.Data.SqlClient.SqlException: Login failed for user 'DSD-WIN\dnnuser'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.dnn_FindDatabaseVersion @Major int, @Minor int, @Build int as select 1 from dnn_Version where Major = @Major and Minor = @Minor and Build = @Build System.Data.SqlClient.SqlException: Login failed for user 'DSD-WIN\dnnuser'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dnn_UpdateDatabaseVersion') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.dnn_UpdateDatabaseVersion System.Data.SqlClient.SqlException: Login failed for user 'DSD-WIN\dnnuser'. 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 DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.dnn_UpdateDatabaseVersion @Major int, @Minor int, @Build int as insert into dnn_Version ( Major, Minor, Build, CreatedDate ) values ( @Major, @Minor, @Build, getdate() )
I am guuuessing my problem is that I still have something wrong in my web.config file but I can't for the life of me see what that could be. Any ideas would be appreciated. Believe me, I have been searching for the answers to this question for two days and trying everything I could find before I resorted to asking the forum.
Thanks in advance if you can help!
|