August 1, 2013 at 8:16 am
Heres my scenario.
I have an access table called Innovative in an access database.
While on the server i can query this
SELECT *
FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'\\vq1\Efile Document Storage\HR\HR\Employee File Notes\Employeefilenote.accdb'; 'admin';'',innovative);
so i have made that into a view called bk_Innovative. When i want to query that from SSMS loaded on my machine not the server i get this error.
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "The Microsoft Access database engine cannot open or write to the file '\\vq1\Efile Document Storage\HR\HR\Employee File Notes\Employeefilenote.accdb'. It is already opened exclusively by another user, or you need permission to view and write its data.".
Msg 7303, Level 16, State 1, Procedure bk_Innovative, Line 6
Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".
im a network admistrator, i have access to that path, so why if i make that into a view on the server, cant i query that out on my pc. it only works to query on this server. I want to use this query in Reporting services.
Any IDEAS?
August 2, 2013 at 10:05 am
If there's a user listed under SERVER PROPERTIES > SECURITY in the proxy account section, that user may need access to the directory as well.
August 2, 2013 at 10:23 am
where do I find this at?
August 2, 2013 at 10:24 am
Right click on your server instance in SSMS and select properties.
August 2, 2013 at 10:26 am
under my proxy account I don't have the check box checked, any other ideas?
August 2, 2013 at 11:38 am
Maybe check the account used under the Log On tab in the SQL Server service properties.
Start > Administrative Tools > Services
Scroll down to the SQL Server instance, right click, properties. Then the Log On Tab.
August 5, 2013 at 6:49 am
Still no luck on this. any other suggestions.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply