.NET Questions and Solutions

Symptoms
Although the MSSQLServer service does not stop, the Microsoft Operations Manager (MOM) 2005 Operator Console contains a Critical Error severity alert that is similar to the following alert:

Name: The MSSQLServer service terminated unexpectedlySeverity: Critical ErrorResolution State: NewDomain: WORKGROUPComputer: ComputerNameTime of First Event: TimeTime of Last Event: TimeAlert latency: 1 secProblem State: InvestigateRepeat Count: 3Age:Source: MSSQLSERVERAlert Id: 390da845-d0c7-4570-b895-cb265d13addaRule (enabled): Microsoft SQL Server\SQL Server 2000\SQL Server 2000 Event Collection\SQL Server General\The MSSQLServer service terminated unexpectedlyDescription: SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Resolution
This issue occurs when the following conditions are true: You enable the The MSSQLServer service terminated unexpectedly event rule. This event rule has the following criteria in the MOM 2005 Administrator Console: The Event Number event property matches the following code:

regex ^(17052|17055)$The Source Name event property matches the following code:

wildcard MSSQL*The Description event property matches the following code:

substring Error: 0, Severity: 19, State: 0You receive an error message that has a severity level 19 in Microsoft SQL Server 2000 that is similar to the following error message:

ODBC: Msg 0. Level 19, State 1SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.Connection Broken

Symptoms
You may find that you cannot create a portal site in Microsoft Office SharePoint Portal Server 2003.When you try to create a portal site, you may experience one or more of the following symptoms: You receive an error message that is similar to the following:

System.NullReferenceException: Object reference not set to an instance of an objectEntries that are similar to the following are logged to the log file:

Time Start- Add custom roles to fine-grained lists
Time End- Add custom roles to fine-grained lists
Time Exit InitCategories()
Time Failed to create portal successfully
Time cmd.CommandText set as: Update dbo.orgle_errormsg set LocalizedMsg = N’User’ where ErrorID=’-1′ Update dbo.orgle_errormsg set LocalizedMsg = N’Target Audiences’ where ErrorID=’-2′ Update dbo.orgle_errormsg set LocalizedMsg = N’Select Audience’ where ErrorID=’-3′ Update dbo.orgle_errormsg set LocalizedMsg = N’Select’ where ErrorID=’-4′ Update dbo.orgle_errormsg set LocalizedMsg = N’Compilation failed to start due to an error connecting to the database. Please check the AudienceJob log file for details.’ where ErrorID=’1′ Update dbo.orgle_errormsg s
Resolution
This issue may occur in situations when there arenetwork connectivity problems that prevent you from connecting to the server that is running Microsoft SQL Server 2000, and the server that is running SQL Server 2000 uses the following configuration:The server is configured to use named pipes.The server is not configured to use TCP/IP.