Hi,
I am trying to connect to a database server that my domain login name does not have access too.
But in my connection string i am including a username and password that does have access but when i run my code, it throws an exception saying that my domain login and password does not have access. I am not using my domain login and password in my connection string.
my connection string>
connectionString="Data Source=server;User ID=allowedID;password=validPassword;Initial Catalog=database;Integrated Security=True;Trusted_Connection=True;"
Please help
I think you'll find that when you specify Integrated Security=true in a connection string, it totally ignores the UserID and Password. Take out the Integrated Security bit and I think it'll work how you expect.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)