Dynamics Community Forum Thread Details

Management Reporter 2012 RU3 / Dynamics GP 2010 v 11.00.2106

Management Reporter Installed and working with GP Legacy.

I'd rather use the Data Mart, however when I try to configure this with my connectivity information and requesting that it creat the DDM database nothing happens when I click Next.

If flashes quickly. Sits there for about 30 seconds, then crashes the program.

When I check the event log, I get a security error for SQL server (2008 R2) indicating that the SA account was unable to open the explicitly requested database. Further digging indicates that it appears to be trying to connect to the master database. Not that that matters. SA should have access to everything anyway.

Windows Authentication yields the same result.

Text from the eventlog below:

- System

- Provider

[ Name] MSSQLSERVER

- EventID 18456

   [ Qualifiers] 49152

   Level 0

   Task 4

   Keywords 0x90000000000000

- TimeCreated

   [ SystemTime] 2012-12-20T21:18:58.000000000Z

   EventRecordID 151659

   Channel Application

   Computer xxxxx.xxxxxx.com

   Security

- EventData

   sa
   Reason: Failed to open the explicitly specified database.
   [CLIENT: <local machine>]
   184800000E0000000F000000470050004C00410042004300550052005200530052005600300031000000070000006D00610073007400650072000000

--------------------------------------------------------------------------------

Binary data:

In Words

0000: 00004818 0000000E 0000000F 00500047
0008: 0041004C 00430042 00520055 00530052
0010: 00560052 00310030 00070000 006D0000
0018: 00730061 00650074 00000072

In Bytes

0000: 18 48 00 00 0E 00 00 00   .H......
0008: 0F 00 00 00 47 00 50 00   ....xxxx
0010: 4C 00 41 00 42 00 43 00   xxxxxxx
0018: 55 00 52 00 52 00 53 00   xxxxxxx
0020: 52 00 56 00 30 00 31 00   xxxxxxx
0028: 00 00 07 00 00 00 6D 00   ......m.
0030: 61 00 73 00 74 00 65 00   a.s.t.e.
0038: 72 00 00 00               r...

xxxxxxx in place of server name and domain to protect the innocent.

Quick Links

Leaderboard