Solve the problem of access denied IN Bulk Insert, bulkinsert

Solve the problem of access denied IN Bulk Insert, bulkinsert

Batch import txt and other files to SQL Server:

Truncate table dbo. lb _ Broadband off-network forecast modeling data 1501

Bulk insert lb _ Broadband off-network forecast modeling data 1501
From 'f: \ bandwidth list \ 201501.txt'
With
(
FIELDTERMINATOR = '$ ',
ROWTERMINATOR = '\ n ',
Maxerrorrs = 100
)
Truncate table dbo. lb _ Broadband off-network forecast modeling data 1501

However, during import:

"The file cannot be opened..., so it cannot be loaded in large capacity. The operating system error code is 5 (Access denied )".

Cause:

When you try to import a remote network file through bulk insert, you actually use the SQL SERVER built-in account to access network files. By default, you do not have the permission to access network files.

Solution:

Change the logon identity of the SQL SERVER service to a system administrator or another account with access permissions.

(1) Open SQL server configuration managaer and double-click SQL SERVER Service

(2) In the displayed dialog box, change the logon identity to "Local Account" and enter a user with the permission to access the remote network file.

(3) restart the service.

"Failed to open file... the system could not find the specified path" error. Generally, the file is not imported into the disk of the SQL Server.