Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting : MS Access as middleware is not working with MS SQL Server
Posted by Jack - QODBC Support on 10 November 2014 02:51 PM

Troubleshooting: MS Access as middleware is not working with MS SQL Server

Problem Description:

I am trying to use MS Access as a middleware with MS SQL Server. I have created MS Access database & linked all QODBC tables through QRemote DSN, After that, I have created MS Access DSN which is pointing to newly created database. After that, I have created the linked server which pointing MS Access DSN. Linked Server is created but when I run the query on the linked server, I am getting below error: 

http://support.flexquarters.com/esupport/newimages/middlewarenotworking/step1.png

Please help me to resolve this error.

 

Solutions:

This error is not related to QODBC. You are facing this issue because MS SQL Server is log on as "Network Service".

You need to change this setting to "Local System".

You can change it by following below steps:

Start >> Run >> type "services.msc" click on "OK"

Find SQL Server (MSSQLSERVER), Open SQL Server (MSSQLSERVER) by double click on it & navigate Log On tab & choose log on as "Local System Account" and apply the changes by click on ok button & test again.

http://support.flexquarters.com/esupport/newimages/middlewarenotworking/step2.png

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