April 1, 2003 at 2:25 pm
I receive an "access denied" error everytime I try to perform a BULK INSERT from a Network share. The 'Everyone' group has access to read and write to the network share. Why do I get this access denied? The SQL Service Server Manager is running as a Network Administrator. What are my options for performing a BULK INSERT from a SQL Client?
Gregory Olds
Systems Developer
Gregory Olds
Systems Developer
April 1, 2003 at 2:37 pm
Are you a member of sysadmin (sa) in SQL Server? Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
April 1, 2003 at 2:43 pm
I am executing under the sa login and this is the exact error I am receiving:
Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because file '\\server\fdata\sync.dat' could not be opened. Operating system error code 5(Access is denied.).
Gregory Olds
Systems Developer
Gregory Olds
Systems Developer
April 1, 2003 at 2:59 pm
Can you check whether SQL Server service account and your NT account are able to access this file?
Edited by - Allen_Cui on 04/01/2003 3:03:16 PM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply