[QODBC-Desktop] MS SQL Reporting Services and QuickBooks
Posted by brad waddell on 12 March 2009 05:21 PM

Troubleshooting: MS SQL Reporting Services and QuickBooks 

Problem Description

     I am trying to deliver reports via Microsoft's SQL Server 2005 Reporting Services. I have a Windows 2003 server with QuickBooks 6 and the latest QODBC driver using DCOM. I was repeatedly getting this error: "QB Open Connection Failed. DCOM Instance Error= 8000401a" until I set the component services permissions correctly on the QBXML... DCOM config items.

     Now, I no longer get the error. I can run the report in the MS Business Studio with no problems (the report always works fine in the Business Studio), but when I run it through reporting services, it hangs with a generating report message. This seems to hang reporting services and QuickBooks and a reboot will clear everything so I can hang it again. The report is created in the business studio connecting directly to the QODBC driver. It only references one table, InvoiceLine, and works correctly from the business studio. When it is installed in the Reporting Services, and run via a web interface, it used to fail on a DCOM permissions error. Now I get no error, but it hangs waiting for the report to generate. I do not receive any errors.

     I get these same results whether I connect locally or remotely to the IIS server. The server contains all the components, QuickBooks, SQL Server, Reporting Services, QODBC, and IIS.

Solutions

     First try looking at your configuration setup as per: How to create Link Server with MS SQL 2005/2008 to see if the linked tables working correctly with SQL Server 2005.

     Then suggest you debug IIS first using qbcust.asp found in: How to see QuickBooks data in an Internet Explorer Browser using Windows XP

(159 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).