• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 82
  • Last Modified:

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.
0
emi_sastra
Asked:
emi_sastra
  • 5
  • 5
  • 3
1 Solution
 
Pawan KumarDatabase ExpertCommented:
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.
0
 
emi_sastraAuthor 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.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
The SQL Server service account needs to have read and write permissions on the folder. Check if that is true for your case.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
emi_sastraAuthor 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.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Well, check in that folder who has permissions. If you don't know how to check that, then follow this article.
0
 
emi_sastraAuthor Commented:
Hi Vitor,

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

Thank you.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes. That's for any Windows version.
0
 
emi_sastraAuthor Commented:
Still same problem.
0
 
Pawan KumarDatabase ExpertCommented:
Open the SSMS using the user you are running the application.

Connect to DB

Then execute the select command.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
emi_sastra, is this issue solved?
0
 
Pawan KumarDatabase ExpertCommented:
Hi Eme_sastra,
Did you try my last comment?
0
 
emi_sastraAuthor Commented:
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.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
As stated by the author
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now