Hi, I wonder if anyone can shed any light on my problem:
Hi have two accounts for the SQL server, a SA account and a User account. The user account has exec permissions only on the relevant stored procedures to allow select, insert, update and delete records on the underyling tables.
When I run the storedprocedures, under the user account from Query Analyser, they execute normally and work fine.
On my VB.NET form, I have a SQL data Adapter – which I go to configure with the DA Configuration Wizard. I use the ‘user’ login in the connection with the wizard, I select the appropriate select, update and insert stored procedures from the combos and the make sure the mappings are all OK. Then when the wizard goes to configure the DA, it suceeds on the SELECT, but fails on the insert and update stored procedures, return the message that it could not find the stored procedures in the database!
When I run the DA Configuration wizard with a connection using a SA account, it all works fine.
This to me seems like a permissions problem, however, I have confirmed that the permissions are all OK, by running the stored procedures from query analyser as the User account.
Anyone have any ideas (PS: I suspect that the same problem that is causing this is causing the application some problems, which is why I wish to resolve the cause of this).
Cheers
