Configuring connections to the Database for MessageStats Reports on Windows Server 2008, and Wind (4346503)

When MessageStats Reports are installed Windows 2008, or Windows Vista, editing theQMSREports.udl file has no apparent effect.

In Windows Vista, and Windows Server 2008, changes made to files in the C:\Program Files directory are saved on a per-user basis, rather on a system-wide basis, unless the users is running with elevate User Access Control (UAC).Any changes made, without elevated UAC are stored in a separate per-user area of the file system. Services, however, use the original file, the C:\Program Files directory. Since MessageStats reports are generated by code running in the IIS service, changes to the QMSREports.udl file must be saved with elevated UAC.

To make changes to the MessageStats reports database connection, use the following procedure.

Start CMD.EXE with elevated UAC: Click on the Start menu; type CMD (without pressing return), and wait for CMD.EXE to appear in the list of matching programs; once it appears, right click on the program name, and select Run as Administrator

Launch the QMSReports.udl from the resulting CMD prompt. Issue the following commands,at the CMD prompt:

CD /D "%ProgramFile%\Quest Software\MessageStats"
Start QMSReports.udl

Now, when you save changes to QMSREports.udl, the contents of the file will be shared in the system-wide location, used by the MessageStats reports service code.