Knowledgebase
[QODBC-Desktop] How to Setup QODBC in Window Server 2003 SP2 System
Posted by Juliet (QODBC Support) on 17 August 2010 09:20 AM

How to Setup QODBC in Window Server 2003 SP2 System

Note: QuickBooks is running on the server console.

QODBC DCOM Setting

     Make sure Server Edition Use DCOM Servers is checked

W2003SP2-1.jpg 

 

Also refer : DCom Option / Server Edition Tab missing in QODBC Setup Tab

Give Rights to Network Service

     Add this folder and give full rights to the NETWORK SERVICE account. This is where trace files and optimizer will go.

W2003SP2-2.jpg 

Enable DCOM

     In DCOMCNFG, make sure DCOM is enabled

W2003SP2-3.jpg 

COM Security Configuration

Note: In DCOMCNFG  add NETWORK SERVICE to all four choices on the COM Security Tab

Access Permissions

W2003SP2-4.jpg 

     Edit Access Permission -> Edit limits.  Give full permissions for NETWORK SERVICE.

W2003SP2-5.jpg 

     Edit Access Permissions -> Edit Defaults. Give permission for NETWORK SERVICE Local Access.

W2003SP2-6.jpg 

Launch and Activation Permissions

     Edit Launch and Activation Permissions -> Edit Limits. Give permission for NETWORK SERVICE Local Launch and Local Activation.

W2003SP2-7.jpg 

     Edit Launch and Activation Permissions -> Edit Defaults. Give full permissions for NETWORK SERVICE.

W2003SP2-8.jpg 

 

DCOM Config for qbXMLRP2eQODBCInteractive Properties

Authentication Level

     In the General Tab of qbXMLRP2eQODBCInteractive Properties, setup Authentication Level as "Default".

W2003SP2-9.jpg 

Security Configuration

W2003SP2-10.jpg

Launch and Activation Permissions 

     Select Customize option in Launch and Activation Permissions -> Edit, give full permissions for NETWORK SERVICE.

W2003SP2-11.jpg

Access Permission

     Select Customize option in Access Permissions -> Edit, give full permissions for NETWORK SERVICE. 

W2003SP2-12.jpg 

Make sure Identity is set to Interactive user

     In Identity Tab, select the "The Interactive User" option.

W2003SP2-13.jpg 

 

IIS Manager Configuration

     In IIS Manager All I turned on was classic web pages:

W2003SP2-14.jpg 

Default Web Site Properties

     Scripts only still worked:

W2003SP2-15.jpg

     Under Directory Security, left as anonymous:

W2003SP2-16.jpg 

(112 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).