Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shajimanjeri
Posting Yak Master
179 Posts |
 Posted - 2008-07-27 : 07:45:11
|
| Dear All,While I execute a stored procedure with bulk insert it shows some errors. I am accessing the file from a network share.Could not bulk insert because file '\\192.168.1.1\betaUploads\1.txt' could not be opened. Operating system error code 5(error not found).I did check on the server "MSSQLSERVER" under services and it is working under localSystem account.Does anybody have any Idea how to solve this issue?Shaji |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2008-07-27 : 09:27:25
|
| Try to open the file manually and see what happens. I wonder if it's still being written or another application has it held open for some reason.Mike"oh, that monkey is going to pay" |
 |
|
|
shajimanjeri
Posting Yak Master
179 Posts |
Posted - 2008-07-27 : 09:34:34
|
| Manually I opened this file from both server. It doesn't show any error. When I run it from SQL Query analyzer it shows this problem. Here the main issue isSQL server is running in one computer (server) and my stored procedure is trying to access one file (txt file) from another computer (server) which is connected locally.Does you think I need some special permission on it or ..Shaji |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-27 : 13:33:03
|
| http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1140586&SiteID=17WebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
|
|
|
shajimanjeri
Posting Yak Master
179 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-07-28 : 04:33:40
|
Does Query Analyzer user context have same privileges as the stored procedure?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
shajimanjeri
Posting Yak Master
179 Posts |
Posted - 2008-07-28 : 05:57:52
|
| Its not from query analyzer. same error showing even if I run my ASP page where I called this procedure. Something related to the network issue. I have given all the permission to the folder where the file located to read.SP is working fine if the file is on the same computer, but if the file is on the network then it shows this error.Does anybody have idea on this please?Shaji |
|
|
|
contrari4n
Starting Member
27 Posts |
Posted - 2008-07-28 : 10:18:13
|
| Your original post mentions the service is running under LocalSystem.Have you changed this to a domain account with permissions to access the network drive?Richard Fryarhttp://www.sql-server-pro.comSQL Server Articles and Tips |
|
|
|
|
|
|
Operating system error code 5