To make sure you have the right permissions to use BULK commands follow the below Expand Security Expand Logins Right click on your username and choose properties (A dialog window appears) Choose Server Roles Select bulkadmin to be able to use bulk commands or sysadmin to be able to use any commands to your database. GRANT SELECT,UPDATE,INSERT,DELETE ON SCHEMA::dbo TO raji (User Name) Or Start SQL Management Studio. Expand the Server Node (in the 'Object Explorer'). Expand the Databases Node and then expand the specific Database which you are trying to access using the specific user. Expand the Users node under the Security node for the database. Right click the specific user and click 'properties'. You will get a dialog box. Make sure the user is a member of the db_owner group and other required changes using the view. (I used this for 2016. Not sure how the specific dialog look like in other version and hence not being specific) DROP LOGIN login_name ; Create User - Login New : raji map to creditial : Database name Security -> User Select User -> (Properties) - > Securables ( click on SELECT,UPDATE,INSERT,DELETE User Mapping select database