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

MORE INFORMATION

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.