Running BULK INSERT from Man. Studio and files on network share - permissions?

• richlion2

  SSCrazy

  Points: 2484

  More actions

  November 6, 2020 at 1:22 pm

  #3804948

  Hello,

  I need a little bit of help here. I have a developer running sql BULK INSERT and importing a .CSV file that is on a network Share. He logs in as DOMAIN\Richard1 and has been granted BULK INSERT permissions.

  It looks like the server has no permissions to read the folder/file. I think I need to grant the SQL server access to that folder/file. We have the following services running using domain accounts:

  1. SQL Server is configured using DOMAIN\svc-SQL_Serv
  2. SQL Agent is configured using DOMAIN\sv-SQL_Agent

  Which of these would be running the SQL on behalf of the user? When I login to the Windows server using DOMAIN\svc-SQL_Serv it can open the Shared folders, but not where the CSV files is located.

  Thanks,

  Richard

   

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  November 7, 2020 at 2:10 pm

  #3805467

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.