Dear All,
Im trying to execute the follownf command:
(BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
from Query analyzer and I get the message:
(Server: Msg 4861, Level 16, State 1, Line 1
Could not bulk insert because
file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
opened. Operating system error code 5(error not found).)
what might be the problem:Hi,
This error normally comes when you are not able to access the remote share.
The problem might be the account under which your SQL Server runs, must be
authorized to access
the share on \\Ntp\app\HARRIS .
This will not work if SQL Server runs under the local system account. So
ensure that you start your SQL server using a domain account which has
access to \\Ntp\app\HARRIS share.
Thanks
Hari
MCDBA
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx
.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>|||1. \\server\shared is relative to the sqlserver.
2. check to see if the NT acct used to start sqlserver service has access to
network shared. LocalSystem acct will not have any access to network
resources.
-oj
http://www.rac4sql.net
"HARRIS ARISTOTELOUS" <harris@.glprodata.com> wrote in message
news:187bb01c41ae7$77752530$a101280a@.phx
.gbl...
> Dear All,
> Im trying to execute the follownf command:
> (BULK INSERT LOUIS_Publication.dbo.mbbmPlanSheetCache21
> FROM '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP')
>
> from Query analyzer and I get the message:
> (Server: Msg 4861, Level 16, State 1, Line 1
> Could not bulk insert because
> file '\\Ntp\app\HARRIS\MBSSTABRIXIROGA.TMP' could not be
> opened. Operating system error code 5(error not found).)
> what might be the problem:
>
No comments:
Post a Comment