Getting Error Invalid authorization specification in SQL Server.
OLE DB provider “”MSDASQL”” for linked server “”QBDT”” returned message “”[Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed””.
OLE DB provider “”MSDASQL”” for linked server “”QBDT”” returned message “”[QODBC] Evaluation Expired. QRemote requires QODBC license, Please purchase QODBC or QRemote License””.
Msg 7303, Level 16, State 1, Line 2
Cannot initialize the data source object of OLE DB provider “”MSDASQL”” for linked server “”QBDT””.”
QuickBooks accounting software holds the top position in the list of accounting software that has been favoring the small and medium business sector by simplifying the regular accounting and financial operations. Automation of the functions helps to save time and improve accuracy of the output. There are times when the software goes out of track and encounters some errors. These errors can be functional or technical. The errors may relate to software installation, data migration, network connectivity, database errors etc. OLE DB can be categorized under one of the technical error. It is a critical error and must be reported immediately to the QuickBooks customer service support number.
The error indicates that the problem occurs when the user create Linked Server in SQL Server. VB DEMO connects properly to the QREMOTE on QuickBooks Server. While configuring the Linked Server the user encounters this error. A separate thing occurs 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. It fails to 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)
How to Resolve QuickBooks OLE DB Error?
The message “Invalid authorization specification” means that linked server settings to connect to the server are not correct.
Please ensure the below listed linked server property and check again.
- Ensure that you have chosen correct provider Microsoft OLE DB Provider for ODBC Drivers instead of any other providers.
- Make sure that the security tab have selected is designed without using a security context option.
For further queries you can contact QuickBooks customer support. They are easily approachable through different modes of contact. Choose toll free phone number, email or live chat support to garner immediate services for the QuickBooks errors reported by the users.
Read More: What to do when QuickBooks database server manager is not available?
Also you can choose to connect with fastfix247.com that is a reliable QuickBooks support agency. It hires experienced and knowledgeable QB experts who are highly capable of according quick and genuine services for all the QuickBooks problems. Call to the toll free support number and fetch instant and feasible solution in a very short wait time.