i have a new c# web application in .net 4 hosted on iis7. this is an intranet application. i have a function that builds a DataTable then does a bulkcopy.write(datatable) to sql server 2008 table.
My connection string specifies a userid and password on sql server (sql authentication). I have given this user id sqladmin and bulkadmin rights, have added it to the users for the target table to bulk copy into, but still get a "login failed for 'dbAdmin' " error.