Knowledgebase: Connection
[QODBC-Desktop] Troubleshooting: Create DCOM Instance Error = 80070005 , Unknown error.. Created qbXMLRP2 OK.
Posted by Rajendra Dewani (QODBC Support) on 25 July 2012 12:48 PM

Troubleshooting: Create DCOM Instance Error = 80070005, Unknown error. Created qbXMLRP2 OK.

Problem Description:

When trying to use SQL Server via QODBC, It reports the error like this:

Create DCOM Instance Error = 80070005, Unknown error. Created qbXMLRP2 OK.

Solution:

Please open your Services list window(services. msc), Search for your SQL Server service, right-click the server you are using, and click the "Property" option to view the server information.

In the "Log On" window, please check that you have set your server like ( NT Services\MSSQLSERVER ):

We believe that this is the reason for your problem. Please change your Server User like the screenshot below: (empty the password and confirm the password if using "Network Service" or Consult with your System/Network Administrator)

If that does not work for you, try using "Local System User":

 

 

Also refer : DCom Option / Server Edition Tab missing in QODBC Setup Tab
(10 vote(s))
Helpful
Not helpful

Comments (3)
Fastech
20 September 2012 08:40 AM
Alirhgt alright alright that's exactly what I needed!
Paul King
27 December 2013 08:40 AM
Ah, hmm. Yes, setting the SQL service account to SYSTEM or an account with membership in Administrators local group gets this DCOM component working for me. Cannot use a non-privileged account for the SQL service apparently. Not ideal from a security point of view.
Jack
08 July 2014 10:13 AM
Hi Paul,

You can use QRemote, QRemote doesn't require any account/security change for use SQL Server. Please refer:
http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/2514
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).