web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Error installing MS SQ...
Microsoft Dynamics GP (Archived)

Error installing MS SQL Server Reporting Services Wizard for GP

(0) ShareShare
ReportReport
Posted on by Jerome Landreneau 160

I am trying to run the MS SQL Server Reporting Services Wizard and am receiving an error as soon as I select my database. (See Error Below)

PLEASE HELP!

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

SQL Server Specs (This is where I'm running the wizard)
Windows Server 2003 SP2 - 32 BIT
.NET Framework 3.5 SP1

Dynamics GP Server Specs
Windows Server 2008 R2 Standard - 64 BIT
.NET Framework 4

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

See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text **************System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {58737586-7149-11D4-9BB0-00A0CC359411} failed due to the following error: 80040154.   at Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment.GPReg.GetKeyHash(SqlConnection sqlConnection)   at Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment.GPReg.GetRegisteredModules(SqlConnection sqlConnection)   at Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment.FormSrsDeployment.cmbxDatabase_SelectedIndexChanged(Object sender, EventArgs e)   at System.Windows.Forms.ComboBox.OnSelectedIndexChanged(EventArgs e)   at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)   at System.Windows.Forms.ComboBox.WndProc(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)  ************** Loaded Assemblies **************mscorlib    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3082 (QFE.050727-3000)    CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll----------------------------------------Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment    Assembly Version: 10.0.0.0    Win32 Version: 10.00.836.0    CodeBase: file:///C:/Program%20Files/Microsoft%20Dynamics/SQL%20Reporting/Microsoft.Dynamics.GP.BusinessIntelligence.SRSDeployment.exe----------------------------------------System.Windows.Forms    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------System.Drawing    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------System.Web.Services    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll----------------------------------------System.Xml    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3082 (QFE.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll----------------------------------------System.Configuration    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll----------------------------------------oinplca9    Assembly Version: 10.0.0.0    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------System.Data    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll----------------------------------------System.Transactions    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll----------------------------------------System.EnterpriseServices    Assembly Version: 2.0.0.0    Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)    CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll----------------------------------------Interop.GPRegistration    Assembly Version: 10.0.0.0    Win32 Version: 10.0.0.0    CodeBase: file:///C:/Program%20Files/Microsoft%20Dynamics/SQL%20Reporting/Interop.GPRegistration.DLL---------------------------------------- ************** JIT Debugging **************To enable just-in-time (JIT) debugging, the .config file for thisapplication or computer (machine.config) must have thejitDebugging value set in the system.windows.forms section.The application must also be compiled with debuggingenabled. For example: <configuration>    <system.windows.forms jitDebugging="true" /></configuration> When JIT debugging is enabled, any unhandled exceptionwill be sent to the JIT debugger registered on the computerrather than be handled by this dialog box.

 

*This post is locked for comments

I have the same question (0)
  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at

    Jerome,

    It looks like the Wizard is trying to use a shared component to query your GP registration info.  You need to either install GP client (max) or DexSharedComponents(min).  Either should work. 

    Thanks

    Rob

  • Jerome Landreneau Profile Picture
    Jerome Landreneau 160 on at

    Rob,

    First of all, you are brilliant!  I installed the DexSharedComponents 10 and it worked perfect!  Now I'm at the point where I enter in the target URL and I'm getting this error. (See URL below for image)

    Sorry for the link... I was having trouble inserting the image in this reply.
    http://img265.imageshack.us/img265/7552/errorfv.jpg

    Thanks so much for your help!

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at

    Jerome,

    I'm glad to hear you're making progress.  From the stack trace, I'm guessing it's trying to update the web.config so it doesn't time out while deploying reports.  It needs to update "<httpRuntime executionTimeout.......>" to "<httpRuntime executionTimeout="9000" maxRequestLength="20960">".

    What URL are you entering?  It may be that it can't find the correct web.config.  Are you deplying locally or remotely?

    Thanks

    Rob

  • Perry Smith - CRi Profile Picture
    Perry Smith - CRi 1,692 on at

    Jerome,

     

    The 1st time you run the SSRS Report Wizard it updates your We.config file.  You will need to reset IIS for the new timeout to take affect.

     Run IISRESET

    Perry Smith

  • Jerome Landreneau Profile Picture
    Jerome Landreneau 160 on at

    Rob & Perry,

    Thank you both for you help with this.  I've rebooted the server and that didn't seem to do the trick.  I'm entering in http://localhost/ReportServer and I'm on the our Report Server, which is a SQL 2008 machine running SSRS.  Our GP Server is another server all together, so I'm installing it locally to the SSRS server and remotely to the GP server.  Is there a standard location for the correct web.config file?  If so, I can update it to the values you mentioned above.

     Thanks again,

    Jerome

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at

    Jerome,

    Here's an example:  <SystemDrive>\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\web.config

    I assume you have reporting services configured in native mode?  Make sure your report manager and web service url's are working as well. 

    Do you have UAC on or off?

    Thanks

    Rob

  • Jerome Landreneau Profile Picture
    Jerome Landreneau 160 on at

    Rob,

    I found the web.config file and updated it accordingly; however it's still throwing that error.  I'm running SQL Server 2008 in Native Mode.  I am able to pull up Report Manager without problems.  I'm running this on a Windows Server 2003 machine and I'm not sure if UAC is a part of this version.  Any additional suggestions are greatly appreciated.

     Thanks,

    Jerome

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at

    Jerome,

    What web site are you running on?  Is it the default web site (port 80).  I believe that is a requirement for this version of the SRS wizard.  Also, is there anything else running on the web site?  Can you browse the URL that you're entering in the wizard?

    Thanks

    Rob

  • Jerome Landreneau Profile Picture
    Jerome Landreneau 160 on at

    Hummm... You might be on to something.  With SQL Server 2008, SSRS doesnt' require IIS be installed.  I am able to browse http://localhost/ReportServer just fine, and I can call it remotely from other machines without problems.  I'm assuming that it's on the default port 80 because I dont' have to specify a port when calling it through a URL.  Do you think it could be that IIS is not installed?

  • Rob Bernhardt Profile Picture
    Rob Bernhardt on at

    It's hard to say.  I wish I could debug locally...  I'd probably try adding the web server roles to see if that helps.  I'd also try entering the machine name rather than localhost to see if that makes a difference.

    Thanks

    Rob

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans