«
»

Microsoft, SQL

You do not have permission to use the bulk load statement

05.09.09 | 1 Comment

I had a problem when trying to bulk load a CSV file into my Microsoft SQL 2005 database. The error was “You do not have permission to use the bulk load statement”. It turned out to be quite a simple solution.

The solution: It was simply a permission issue and your SQL login needs to be added to the bulkadmin server role. To do this connect to your SQL server as admin or SA and then go to “Security” > “Server Roles”. Then right click and select properties. Then using the add button, add your login to this role. Retry your bulk statement and you should be ready to go.

1 Comment

have your say

Add your comment below, or trackback from your own site. Subscribe to these comments.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

:

:


«
»