June 13, 2011 at 3:27 pm
A user having sa permission and got the following error when running a stored procedure:
SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file
NULL
How to troubleshoot?
Any input will be greatly appreciated.
June 13, 2011 at 4:01 pm
The SQL service account doesn't have permission to the folder or file.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 15, 2011 at 1:55 pm
GilaMonster (6/13/2011)
The SQL service account doesn't have permission to the folder or file.
The weird thing is, I have sa permission on the database server and local admin permission on the server box. If I ran step-by-step, it worked. If I ran through, I got the above error.
June 16, 2011 at 12:40 am
SQL ORACLE (6/15/2011)
GilaMonster (6/13/2011)
The SQL service account doesn't have permission to the folder or file.The weird thing is, I have sa permission on the database server and local admin permission on the server box. If I ran step-by-step, it worked. If I ran through, I got the above error.
Can yo show me the codes
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy