 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008Security context?
SQL Server 2005 sp2 Windows Server 2003 I have a scheduled stored proc that executes Bulk Insert. It works fine. Agent runs under a domain, sys admin account. I know, I know, too much authority. When I run the Bulk insert command from a SSMS query window, I get this error: "Msg 4861, Level 16, State 1, Line 2 Cannot bulk load because the file "\\Server\\share\TextFile.txt" could not be opened. Operating system error code 5(Access is denied.)." I can use a text editor to open, modify and save the file I'm trying to bulk insert, so I know I have the rights I need to read the file. Why the error from SSMS? thanks Tom  SignatureE-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties. Are you connecting to SQL Server using a SQL Server login (not a Windows domain login)? If that is the case, the permissions of the SQL Server service account will be used to access the file. Give permissions to the SQL Server service account to this file or connect to the instance using Windows authentication. Hope this helps, Ben Nevarez > SQL Server 2005 sp2 > Windows Server 2003 [quoted text clipped - 16 lines] > thanks > Tom Thanks Ben. We're using Windows authentication. The same problem occurs when another developer tries Bulk Insert with a different file on a different server into a different database. She also can open and modify her text file with a text editor. I found a post on a Microsoft forum from someone who had the same problem. He said that Microsoft said it is a bug that will be fixed in SQL 2008. Thanks for taking the time to respond. Tom >Are you connecting to SQL Server using a SQL Server login (not a Windows >domain login)? If that is the case, the permissions of the SQL Server service [quoted text clipped - 28 lines] >>thanks >>Tom SignatureE-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.