Bulk insert from netware problems after applying SP4

[gchavez]

I'm running MSSQL 2K on Win 2k and just upgraded SQL Server from SP3
to SP4 (that's when my problem started). I have a procedure that bulk
inserts from a text file that is located on a Netware 4.11 file server.
The procedure actually references the file using the UNC path to a
share on a NT 4 server that is connected to the novel server using
gateway services for NetWare. Now when it tries to reference the file I
get:

Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because file '\\NtServer\Netware Share\file.txt'
could not be opened. Operating system error code 5(Access is denied.).

I've tried running the process as a domain administrator and get the
same results.

I can run these commands and they work as expected

master..xp_cmdshell 'dir \\NtServer\Netware Share\file.txt'
master..xp_cmdshell 'type \\ NtServer\Netware Share\file.txt'

Also if I Bulk insert the file from the local drive of the same NT
server it works fine i.e.:
BULK INSERT #imp FROM \\NtServer\d$\file.txt'
Any thoughts would be appreciated.

[Erland Sommarskog]

(gc*****@aspenres.com) writes:

I'm running MSSQL 2K on Win 2k and just upgraded SQL Server from SP3
to SP4 (that's when my problem started). I have a procedure that bulk
inserts from a text file that is located on a Netware 4.11 file server.
The procedure actually references the file using the UNC path to a
share on a NT 4 server that is connected to the novel server using
gateway services for NetWare. Now when it tries to reference the file I
get:

Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because file '\\NtServer\Netware Share\file.txt'
could not be opened. Operating system error code 5(Access is denied.).

I've tried running the process as a domain administrator and get the
same results.

Make sure that the account under which the SQL Server service runs has
access to the file on the share. You can check which account this is
by right-clicking My Computer, Manage, find Services, then find the
MS SQL Server server, right-click, Properties and then the Log On
tab. Note that users such as Local System do not have network access
at all.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp