I'm trying to develop a SSDT sln, where a .csv is parsed. However I get the error:
Operating system error code 5(Access is denied.)
According to this post: https://stackoverflow.com/questions/14555262/cannot-bulk-load-operating-system-error-code-5-access-is-denied it's a question of adding users. That specific user didn't exist on my local machine. I tried adding ALL the security principles from my Windows 10 machine and it worked. So one of the list of about 60 or so principles is the correct user to give access to SQL Server 2016 but I would prefer not to go through one by one...
This answer: https://social.technet.microsoft.com/Forums/Windows/en-US/58992456-ec8a-41e8-825b-1e56a075073a/sqlservermssqlusercomputernameinstancename-account-do-not-create-by-default?forum=sqlsetupandupgrade mentions a different user, but I can't find that user either. There are multiple users in the form MSSQLSERVER0x (I think I have the R server installed). But adding the group these users are part of doesn't help either
==== EDIT ====
It worked when I added the 'Users' group - which has 3 members:
- my login user
- NT AUTHORITY\Authenticated Users
- NT AUTHORITY\INTERACTIVE
None of these principles appeared in the list of principles that I could add directly to folder permissions. What are no 2 and 3? And why didn't the security settings tab find ALL the users that were listed in the
Local Users and Groups\Users\ folder (because it listed some that were)?