Knowledgebase
[QODBC-Desktop] Troubleshooting - Getting Error Invalid authorization specification in SQL Server.
Posted by Jack - QODBC Support on 26 December 2016 01:58 PM

Troubleshooting - Getting Error Invalid authorization specification in SQL Server.

Problem Description:

I am trying to create Linked Server on SQL Server.

VB DEMO connects successfully to QREMOTE on QuickBooks Server.

Setting up the Linked server - I get this error:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The OLE DB provider "SQLNCLI10" for linked server "QREMOTELINK" reported an error. Authentication failed.

Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "QREMOTELINK".

OLE DB provider "SQLNCLI10" for linked server "QREMOTELINK" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399)

So, I'm out of ideas.

Please tell me how to get rid of this issue. 

Solution:

The message “Invalid authorization specification” means that linked server settings to connect to the server are not correct.

Please verify below listed linked server property & test again.

1. Please make sure that you have selected correct provider Microsoft OLE DB Provider for ODBC Drivers instead of any other providers.

2. In security tab please make sure that you have selected Be made without using a security context option.

Also, Refer:
How to create Link Server with MS SQL 2005/2008/2012 32-bit Using QODBC/QRemote

How to create Link Server with MS SQL 2005/2008/2012 64-bit Using QODBC/QRemote

 

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