I am having a problem adding user accounts in SBS2008. When the Add User GUI gets to the create mailbox portion, the Console crashes. I have done a bit of snooping around and I have determined a couple of things.
1. It appears that the problem is that nothing can send email to exchange. For example SBS cannot generate a Welcome email.
When I look in the DataServiceComponents.log I see:
"Cannot insert the value NULL into column 'ComputerID', table 'SBSMonitoring.dbo.Alerts'; column does not allow nulls. INSERT fails."
When I look into the Console.log, I see:
An exception of type 'Type: System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' has occurred.
Timestamp: 02/18/2010 07:57:03
Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Stack: at System.Data.SqlClient.SqlConnection.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.ExecuteScalar()
at Microsoft.WindowsServerSolutions.SystemHealth.Monitoring.MonitoringSQLDataStore.GetAlertCountPerType(ComputerType type)
Does anybody have some suggestions as to what could be the issue or how I would fix it? It was suggested to me that this could be a problem with one of the NIC's, the server has 2 NIC's and the second one is empty and disabled.
I have rebooted the server 4 or 5 times since this problem first surfaced.