When putting Trusted_Connection=false in the
connectionstring for SQL Connection in VB .net, I get a GRANT ACCESS
error. We have a user setup with SQL server and I am
logging in with that user in the connectionstring.

I've granted access to all tables and stored procedures on
the SQL server to that SQL user.

I only get this error on some forms. As well I don't get it if the computer
user has administrator access in Windows XP.

Any idea what it could be?

Thanks

Sebastian

Use QA to log on to SQL Server with that specific user and password. Try to
run the query from there.
Turn on the Profiler to see what's getting sent to the server on the forms
that are failing. I suspect that there is a backdoor that's still using SSPI
authentication or you missed a table or SP when setting permissions.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Seb Santacroce" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When putting Trusted_Connection=false in the
> connectionstring for SQL Connection in VB .net, I get a GRANT ACCESS
> error. We have a user setup with SQL server and I am
> logging in with that user in the connectionstring.
>
> I've granted access to all tables and stored procedures on
> the SQL server to that SQL user.
>
> I only get this error on some forms. As well I don't get it if the
computer
> user has administrator access in Windows XP.
>
> Any idea what it could be?
>
> Thanks
>
> Sebastian
>
>