Knowledgebase: Tutorials
[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 an MS Access database & linked all QODBC tables through QRemote DSN. After that, I created MS Access DSN, which points to the newly created database. After that, I created the linked server pointing to MS Access DSN. The linked server is created, but when I run the query on the linked server, I get the 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 logged on as a "Network Service."

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

You can change it by below steps:

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

Find SQL Server (MSSQLSERVER), Open SQL Server (MSSQLSERVER) by double clicking on it & navigate log On tab & choose log-on as "Local System Account," and apply the changes by clicking on the 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).