From comments to ngocyu_vietnam

Coordinator
Jul 12, 2008 at 12:34 PM
Hi ngocyu_vietnam,

  Well, you did not edit the SQL connection string in the web.config to make it point to your local database, you have to :

1. Create a new database or use an existing 2000 or 2005
2. Run the SQL scripts provided with the beta package
3. Edit the web.config to choose between Memory (no SQL required) or SQL providers
4. Make sure to edit the connection string to use the created or used database in the step 1.

You should be OK

Hope this help.

From the home page comments :

ngocvu_vietnam wrote  Wed at 5:02 AM

Help me!!!!
------------------------------------
Error in localhost
------------------------------------
Server Error in '/LiveChat' Application.
Cannot open database "Modulus" requested by the login. The login failed.
Login failed for user 'CUOC\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database "Modulus" requested by the login. The login failed.
Login failed for user 'CUOC\ASPNET'.

Source Error:

Line 138: catch
Line 139: {
Line 140: throw;
Line 141: }
Line 142: finally


Source File: c:\Documents and Settings\Dai 10804\Desktop\LiveChatStartKit\website\App_Code\SqlProviders\SqlOperatorProvider.cs Line: 140

Stack Trace:

[SqlException (0x80131904): Cannot open database "Modulus" requested by the login. The login failed.
Login failed for user 'CUOC\ASPNET'.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735091
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
SqlOperatorProvider.GetOperatorStatus() in c:\Documents and Settings\Dai 10804\Desktop\LiveChatStartKit\website\App_Code\SqlProviders\SqlOperatorProvider.cs:140
OperatorService.GetOperatorStatus() in c:\Documents and Settings\Dai 10804\Desktop\LiveChatStartKit\website\App_Code\Services\OperatorService.cs:44
Chat.Page_Load(Object sender, EventArgs e) in c:\Documents and Settings\Dai 10804\Desktop\LiveChatStartKit\website\Chat.aspx.cs:81
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

------------------------------------
and Error in OperatorConsole
------------------------------------
An unhandle has occured. If you got regularly an error, please report it on the

Discussion board at: http://www.codeplex.com/LiveChatStarterKit/



Details:



System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Cannot open database "Modulus" requested by the login. The login failed.
Login failed for user 'CUOC\ASPNET'.
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.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 SqlOperatorProvider.LogIn(String userName, String password) in c:\Documents and Settings\Dai 10804\Desktop\LiveChatStartKit\website\App_Code\SqlProviders\SqlOperatorProvider.cs:line 73
at OperatorService.LogIn(String userName, String password) in c:\Documents and Settings\Dai 10804\Desktop\LiveChatStartKit\website\App_Code\Services\OperatorService.cs:line 52
at Operator.LogIn(String userName, String password) in c:\Documents and Settings\Dai 10804\Desktop\LiveChatStartKit\website\App_Code\WebServices\Operator.cs:line 46
--- End of inner exception stack trace ---

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at LiveChatStarterKit.OperatorConsole.LiveChatWS.Operator.LogIn(String userName, String password)

at LiveChatStarterKit.OperatorConsole.Login.btnOK_Click(Object sender, EventArgs e)

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ButtonBase.WndProc(Message& m)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
---------------------------
OK