Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 727
  • Last Modified:

SQL Server 2000 Stored Procedure - Operating system error code 5(Access is denied.).

Hi - I'm receiving an error in a SQL Server 2000 Stored Procedure using Bulk Insert.  

Here's the error:

"Could not bulk insert because file '\\server\<path>\file.txt' could not be opened. Operating system error code 5(Access is denied.)."

This has worked for several years, and it appears that there were some recent changes made that is causing this error.  If I log into the database server, I can get to the file path in question, so even though the message says "Access is denied" I'm not convinced that is the issue.

Has anyone seen this before?

Thanks.
Rob


BULK INSERT ProcedureName 
FROM '\\server\<path>\file.txt'
WITH (
   FIRSTROW = 2,
   DATAFILETYPE = 'char',
   FIELDTERMINATOR = '\t',
   ROWTERMINATOR = '\n',
   MAXERRORS = 1
 
)

Open in new window

0
Rob132332
Asked:
Rob132332
  • 4
  • 3
  • 2
4 Solutions
 
mohan_sekarCommented:
Are you sure your procedure has access to that folder/file?
0
 
Rob132332Author Commented:
mohan - could you give me some more info to check what you're suggesting?  steps, things to check?
0
 
mohan_sekarCommented:
If the txt file is in a shared folder on a different server, check if 'read' permission is granted to your user id

for more info - http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/137d2f16-bed3-4b98-a16f-f6db1a961c46
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Anthony PerkinsCommented:
Or to be more precise since you are using BULK INSERT that the SQL Server service startup account has access to those files and is not a Local System account.
0
 
Rob132332Author Commented:
and, how would I check that the SQL Server Service startup account has access?
0
 
Anthony PerkinsCommented:
You either check it yourself or ask your DBA.
0
 
Rob132332Author Commented:
After re-reading my last response, it was unclear.  
I'm asking "how" I would check it myself.  Specific steps would be great, as I'm not familiar with how to do this.  
Thanks.
0
 
Anthony PerkinsCommented:
Look for the SQL Server (MSSQLSERVER) service and see what account is being used?  For example is it a Local System account, is it a domain account?
0
 
Rob132332Author Commented:
That did it - the account that was listed under the MSSQLSERVER service did not have permissions to get to the necessary network path.  Thanks for your help.  Rob
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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