PRB: MSMQ ERR "MQIS Database Initialization Error" in Windows NT Event Log (193510)


The information in this article applies to:

  • Microsoft Message Queue Server (MSMQ) 1.0
  • Microsoft ODBC Driver for SQL Server 1.0
  • Microsoft ODBC Driver for SQL Server 2.0
  • Microsoft ODBC Driver for SQL Server 3.0
  • Microsoft ODBC Driver for SQL Server 3.5
  • Microsoft ODBC Driver for SQL Server 3.6
This article was previously published under Q193510

SUMMARY

When a Microsoft Message Queue (MSMQ) Server is installed, an ODBC Datasource System data source name (DSN) is created to allow connectivity between the MSMQ Service and the MQIS database that exists on SQL Server. Occasionally this System DSN fails to get created or the SQL service is not configured properly and one or more errors are returned when you attempt to use the MSMQ Explorer.
  • The following error can occur:
    Error: 0xc00e0013 No connection with the Site's controller.
    -or-
  • The following entry may occur in the Windows NT EventLog:
    MQIS Database Initialization Error.
This may be caused by the lack of or the misplacement of the ODBC System DSN used to connect SQL and the MQIS Database.

MORE INFORMATION

You can use the following steps to build a new, usable System DSN manually.

  1. Verify that the SQL service is running and that the service is running under the proper account. Initially the SQL service and Microsoft Message Queue service should run under the local System Account and both services start automatically.
  2. Verify that the MQIS database was created using the SQL Enterprise Manager. If you have not registered the local server, you will have to do so to verify the existence of databases. Under the Databases folder, if no MQIS database exists then verify that the SQL service is running and re-install MSMQ. If any errors occur, make note of them.
  3. Verify the ODBC System DSN for the MQIS Database. Double-click the ODBC icon in Control Panel. Next, click the System DSN tab. If there is not a MQIS System Data Source, click Add. In the "Create New Data Source" dialog box, double-click SQL Server. The "Create a New Data Source to SQL Server" dialog box should display. Type MQIS in the Name text box, type "MSMQ Information Server Database" in the Description text box (without the quotes), and select Local from the Server list box, then click Next.
  4. In the next dialog box, under "How should SQL Server verify the authenticity of the login ID?" select "With SQL Server authentication using a login ID and password entered by the user". Enter the Login ID and password (if any) and then click Next. (If SQL runs under a different account, enter that account user name and password). Click Next, and on this screen, make sure that the check box for "Change default database to:" is selected, and that the default database is MQIS. For the next dialog boxes, leave all selections at their default, and then click Finish. In the final dialog box that states that the ODBC Datasource has been created, click OK. You can test the data source if necessary. A System DSN has now been created for the MQIS database. Re-start the MSMQ and SQL services, and verify the MSMQ functionality with MSMQ Explorer.

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Modification Type:MajorLast Reviewed:11/24/2003
Keywords:kbprb KB193510
©2003 Microsoft Corporation. All rights reserved.