Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pengasus
Starting Member
1 Post |
 Posted - 2014-05-05 : 23:10:48
|
| Hi, I am having a problem with our SQL Server. We have a SQL Server, SQL Server 2008 R2 x64; a Database Engine Provider, Microsoft Office 12.0 Access Database Engine; and a Link Server.The problem is, every time I test a connection to our Link Server or create a new Link Server, this Error pops up:"The test connection to the linked server failed/Additional InforamtionAn exception occurred while executing a Transact-SQL statement or batch.(Microsoft.Sql.Server.ConnectionInfo)Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "SynergeeExport".OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "SynergeeExport" returned message"\\mapsvr\PDR_GIS\SFELAPCO_GIS\MODULES\REPORTS\SYNERGEE\SYNERGEE_EXPORT\-JANUARY-2014.MBD' is not a valid path. Make sure that the pathname is spelled correctly and that you are connected to the server on which the file resides." (Microsoft SQL Server, Error: 7303)"**Note, every part is installed in one machine only.Thank You |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2014-05-06 : 14:13:02
|
| If everything is correctly installed - then your issue is probably the fact that the service account does not have access to that share. |
 |
|
|
|
|
|
Link Server Test Connection Error