Avatar of emi_sastra
emi_sastra
 asked on

The current user does not have permissions on that object.

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.
Microsoft SQL Server

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon
Pawan Kumar

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.
emi_sastra

ASKER
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ão

The SQL Server service account needs to have read and write permissions on the folder. Check if that is true for your case.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
emi_sastra

ASKER
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ão

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

ASKER
Hi Vitor,

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

Thank you.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Vitor Montalvão

Yes. That's for any Windows version.
emi_sastra

ASKER
Still same problem.
Pawan Kumar

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

Connect to DB

Then execute the select command.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Vitor Montalvão

emi_sastra, is this issue solved?
Pawan Kumar

Hi Eme_sastra,
Did you try my last comment?
ASKER CERTIFIED SOLUTION
emi_sastra

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Vitor Montalvão

As stated by the author
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.