I have same problem in another environment where I have Windows Server 2008 R2 and SQL 2008 R2 SP2. I am confused becouse it works from SQL server but from any SQL client domain member computer/server it does not work. I am trying to use in security mode - "For a login not defined in the list above, connections will be made without using a security context", i have also tried all four options.
#Microsoft access database engine full#
I do not have any other program using my access database, and user has full control. User, or you need permission to view and write its data.". It is already opened exclusively by another OLE DB provider ".12.0" for linked server "MyLinkedServer" returned message "The Microsoft Access database engine cannot open or write to the file '\\\files\mydatabase.mdb'. When I try to place simlpe Select SQL query I got error: ()Ĭannot initialize the data source object of OLE DB provider ".12.0" for linked server "Synesis_3PRO2013". (.Sfc)Īn exception occurred while executing a Transact-SQL statement or batch. TITLE: Microsoft SQL Server Management Studioįailed to retrieve data for this request. The problem is, if I open SQL management studio (as domain admin with UAC elevated permissions) on my File server or any other computer, when trying to browse my linked server i got error: When I open (as domain admin with UAC elevated permissions) on my DB server SQL Management studio, I can browse tables and everything works. I am using linked server, and Access Database Engine 2010 Redistributable to access my database file made in Microsoft Access (.mdb) from network file server.ĮXEC _addlinkedserver = N'MyLinkedServer', SQL service is running with domain service account MYDOMAIN\SQL1$, i have added Full control for file share and NTFS permission on my file server folder (C:\Files). I have Windows Server 2012 with SQL 2012 Standard SP1.
0 kommentar(er)
