Hi!
I have an webapp that uses bulk insert to insert data into an sql server. This works fine when sqlserver and webserver is on the same machine. But when i tried to use seperate machines i get access denied message when trying bulk insert. Ive created a share on the webserver where i store the files to be bulk inserted. And I use the appropiate unc path to the file to be bulk inserted in SQL query. I guess it has something with permissions on the share or security.
What permissions do I need to make this work.
Thanks.
Niclas AhlqvistI've never tried a bulk insert using a UNC path to another machine, but at a guess:
You will need to give permission to the account that SQL Server is running in. Often, for security reasons, the account is a machine account so that, if the server is compromised, the SQL Server process cannot damage other parts of the network. If your SQL Server is running in a machine account you will need to give it a domain account to run in so that it can access the file.
Alternatively, copy the file to the SQL Server machine first.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment