an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > Problem with deployment on Windows Server 2003 ...
Last Post 10/30/2008 6:49:40 PM By vicsd. 2 replies.
10/30/2008 3:41:59 PM
vicsd
Posts: 3
Joined: 10/4/2008
Problem with deployment on Windows Server 2003 Web Edition
After installation of DSC v 2.0 (free version) could not load home page on the web server. I am using two separate servers (MS SQL 2005 and Windows Server 2003 Web Edition). This is error description from the event log on the web server. Not sure how to correct it? 
 
Event Type: Error
 
Event Source: DotShoppingCart
Event Category: None
Event ID: 100
Date: 10/30/2008
Time: 5:35:49 PM
User: N/A
Computer: WEBSERVER
Description:
Timestamp: 10/30/2008 10:35:49 PM
Message: HandlingInstanceID: 7de7608e-0e42-458a-bb89-175c7b4a7b28
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
10/30/2008 17:35:49
Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 14
LineNumber : 65536
Number : 18456
Procedure :
Server : DAS-DB01
State : 1
ErrorCode : -2146232060
Data : System.Collections.ListDictionaryInternal
TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
Stack Trace :
Server 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.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
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 SqlDependencyProcessDispatcher.SqlConnectionContainer..ctor(SqlConnectionContainerHashHelper hashHelper, String appDomainKey, Boolean useDefaults)
at SqlDependencyProcessDispatcher.Start(String connectionString, String& server, DbConnectionPoolIdentity& identity, String& user, String& database, String& queueService, String appDomainKey, SqlDependencyPerAppDomainDispatcher dispatcher, Boolean& errorOccurred, Boolean& appDomainStart, Boolean useDefaults)
at SqlDependencyProcessDispatcher.StartWithDefault(String connectionString, String& server, DbConnectionPoolIdentity& identity, String& user, String& database, String& service, String appDomainKey, SqlDependencyPerAppDomainDispatcher dispatcher, Boolean& errorOccurred, Boolean& appDomainStart)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
 
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at SqlDependencyProcessDispatcher.StartWithDefault(String connectionString, String& server, DbConnectionPoolIdentity& identity, String& user, String& database, String& service, String appDomainKey, SqlDependencyPerAppDomainDispatcher dispatcher, Boolean& errorOccurred, Boolean& appDomainStart)
at System.Data.SqlClient.SqlDependency.Start(String connectionString, String queue, Boolean useDefaults)
at System.Data.SqlClient.SqlDependency.Start(String connectionString)
at DotShoppingCart.OpenSource.Core.DBController.GetSqlCacheDependency(String host, SqlCommand cmd)
at DotShoppingCart.OpenSource.Core.OrderPipelineProcessor.GetAll(String host)
at DotShoppingCart.OpenSource.Core.OrderPipelineProcessor.GetConfiguredProcessors(String host, String orderPipeline)
at DotShoppingCart.OpenSource.Core.OrderPipelineProcessor.GetAllConfiguredProcessors(String host)
at DotShoppingCart.OpenSource.OrderPipeline.OrderProcessorProvider.Proccess(String host, IConfigurationSource cfgSrc)
at DotShoppingCart.OpenSource.OrderPipeline.ProcessorProvider.Run()
at DotShoppingCart.OpenSource.OrderPipeline.RunnableProvider.StartRun()
 
Additional Info:
 
MachineName : WEBSERVER
TimeStamp : 10/30/2008 10:35:49 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null
AppDomainName : /LM/W3SVC/1/Root/DemoStore-1-128698797482500000
ThreadIdentity :
WindowsIdentity : NT AUTHORITY\NETWORK SERVICE
 
Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: DAS-WS01
Application Domain: /LM/W3SVC/1/Root/DemoStore-1-128698797482500000
Process Id: 2268
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 2196
Thread Name:
Extended Properties: HelpLink.ProdName - Microsoft SQL Server
HelpLink.EvtSrc - MSSQLServer
HelpLink.EvtID - 18456
HelpLink.BaseHelpUrl - http://go.microsoft.com/fwlink
HelpLink.LinkId - 20476
host - dsc
 
 
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
 
10/30/2008 4:30:39 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Problem with deployment on Windows Server 2003 Web Edition
It's a permission issue.
 
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
 
It seems that you are using NT authentication between web server and SQL server. But SQL server doesn't grant any access to the anonymous account. There are two ways to fix this.
1) Switch to use SQL login 
It's simple. Just create a SQL login on the SQL server and grant permissions to the SQL login by assigning the DSC_Public role. And then change the web.config connectionString to use the SQL login.
 
2) Still use Windows login
It's more complicated. There are plenty of articles on the internet teaching you how to do this. Bascially you create a Windows account, make app pool running under that account and grant SQL permission to that account.
DotShoppingCart Staff
10/30/2008 6:49:40 PM
vicsd
Posts: 3
Joined: 10/4/2008
Re: Problem with deployment on Windows Server 2003 Web Edition
Thank you.