PRB: MSMQ ERR "MQIS Database Initialization Error" in Win NT

ID: Q193510

The information in this article applies to:

Microsoft Message Queue Server version 1.0
Microsoft ODBC Driver for SQL Server, versions 1.0, 2.0, 3.0, 3.5, 3.6

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.

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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). In the
   next two dialog boxes leave all selections at their default 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.

Additional query words: kbmsmq100

Technology        : internet
Version           : WINDOWS:1.0,2.0,3.0,3.5,3.6; WINNT:1.0
Platform          : WINDOWS winnt
Issue type        : kbinfo

Last Reviewed: October 6, 1998