I am attempting to use a "standard" user name / password combo to use access to run a sql server stored procedure. This is the connection string part
Code:
con.Open "Provider=SQLOLEDB;Data Source=PServer;Initial Catalog=Test;User Id=testuser;Password=testpwd;Integrated Security=SSPI;Trusted_Connection=Yes;"
But whenever a user tries to run this they get the error,
Code:
Error user Domain\user Does not have access
Why is it even attempting to authenticate with a specific users credentials when I have passed the credentials I want to use in the syntax?