If a SQL Server user is logged in using Windows authentication, the user can read only the files accessible to the user account, independent of the security profile of the SQL Server process. In my opinion and with limited knowledge on 'delegation' the risk associated with allowing the privilege seemed higher than using sql authentication. The service which called the BULK INSERT sp was running under the context of a domain account, however I changed it to use a sql account after reading the article below. What can be the reason for such behaviour? Tried: 1) Given the read/write rights on shared folder, to user under which the SQL server service is running on Test ServerĢ) Given the read/write rights on shared folder to everyone.īULK ' \\ServerName\input\FileName.csv ' , If the command is run from Test Server connecting to any SQL Server instance including Test Server it is running fine. If the same command with same rights is run from any other SQL server instance say Dev1 its running fine. Operating system error code 5(Access is denied.).įor example: If the command is run from System A connecting to SQL Server instance on Test Server Test Server it gives this error. Issue: When running Openrowset command from SQL server other that Test Server query runs fine when trying to run the same command from Test Server it gives error.Ĭannot bulk load because the file " \\ServerName\input\FileName.csv " could not be opened. I am facing a issue with bulk upload on Test Server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |