The current user does not have permissions on that object.

emi_sastra
emi_sastra used Ask the Experts™
on
Hi All,

The web application has no right to access folder at its application folder.
I use Stored Procedure to read file from the folder.

How to solve this ?

Thank you.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
What username u are passing from web application?

That one should have access to create the folder and to select the data from the  table.

Can u share the store procedure.

Author

Commented:
Hi Pawan,

Msg 7357, Level 16, State 2, Line 2
Cannot process the object "SELECT * FROM [DATA$]". The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" indicates that either the object has no columns or the current user does not have permissions on that object.

Thank you.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
The SQL Server service account needs to have read and write permissions on the folder. Check if that is true for your case.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Hi Vitor,

- The SQL Server service account needs to have read and write permissions on the folder. Check if that is true for your case.
How could I do it ?

Thank you.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Well, check in that folder who has permissions. If you don't know how to check that, then follow this article.

Author

Commented:
Hi Vitor,

The problem is at Windows Server 2008 R2.
Is the link help for windows server?

Thank you.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Yes. That's for any Windows version.

Author

Commented:
Still same problem.
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
Open the SSMS using the user you are running the application.

Connect to DB

Then execute the select command.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
emi_sastra, is this issue solved?
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
Hi Eme_sastra,
Did you try my last comment?
Hi All,

I have found the solution.
The problem is odbc driver that its bit different form MS SQL bit.

MS SQL 32 bit, while I install ODBC using 64 bit driver.

Thank you.
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
As stated by the author

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial