I was using windows authentication which I can't get to work (see below). I'm now using Forms Authentication which works fine. However I really want windows authentication to work so that I can use our Active Directory server.
Despite the install page saying everything has installed correctly the Windows Application Event Viewer reveals something else:
It seems to be saying that ASPNET is not Authenticated nor is it Impersonating. I've hilighted the 2 lines in bold (and xxx'd out my IP address, account name, and server name):
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 15/08/2006 16:23:10
Event time (UTC): 15/08/2006 15:23:10
Event ID: ed91e6a2c28a4e8bbfebe88db8181163
Event sequence: 2
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/DotNetNuke-1-128001289855175000
Trust level: Full
Application Virtual Path: /DotNetNuke
Application Path: C:\Inetpub\wwwroot\DotNetNuke4\Website\
Machine name: xxx
Process information:
Process ID: 5508
Process name: aspnet_wp.exe
Account name: xxx\ASPNET
Exception information:
Exception type: SqlException
Exception message: Could not find stored procedure 'dbo.GetPortals'.
Request information:
Request URL: http://xxx/dotnetnuke/Default.aspx
Request path: /dotnetnuke/Default.aspx
User host address: xxx.xx.xxx.xxx
User:
Is authenticated: False
Authentication Type:
Thread account name: xxx\ASPNET
Thread information:
Thread ID: 1
Thread account name: xxx\ASPNET
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership)
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.GetPortals()
at DotNetNuke.Entities.Portals.PortalController.GetPortals()
at DotNetNuke.Common.Global.CacheMappedDirectory() in C:\Inetpub\wwwroot\DotNetNuke4\Website\App_Code\Global.asax.vb:line 145
at DotNetNuke.Common.Global.Application_Start(Object Sender, EventArgs E) in C:\Inetpub\wwwroot\DotNetNuke4\Website\App_Code\Global.asax.vb:line 255
Custom event details:
Hope anyone reading can see where I'm going wrong?
Regards,
Simon Norman