April 22, 2015 at 4:53 am
Hi Folks,
In our environment, we have installed Microsoft.ACE.OLEDB.12.0 (64-bits) provider on Windows Server 2008 R2 SP1 64-bits box. Linked server has been cried based on the provider, to use the Excel Data's where it was in shared location. We are facing errors while doing Test Connecction, error is as follows,
TITLE: Microsoft SQL Server Management Studio
------------------------------
The test connection to the linked server failed.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelServer1xlsx".
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "ExcelServer1xlsx" returned message "Unspecified error". (Microsoft SQL Server, Error: 7303)
FYI, On Provider both Dynamic Parameter and Allowprocess were enabled.
Please help me on this how to over come from this error. Thanks in advance !!
April 27, 2015 at 11:18 am
Thanks friends, one who viewed my forum !!
I got solution for it.
Need to provide permission to TEMP folder of Service account thru which we have installed SQL Server.
Path:
C:\user\useraccount\TEMP (Grand full access to your admin account).
Linked server created based on provider will works as expected.
Will meet you guys in next issue. Bye, have a nice day.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply