Integrated Security means that you are authenticating with your login credentials. It looks to me like you are able to identify yourself to the db server based on how you logged in to the operating system on the local computer (or the domain) rather than the user ID and password that you have built into the connection string. It's ignoring the user ID and password because you have Integrated Security turned on. When you turn it off, the user ID and password are examined and they are rejected.
On Dec 4, 5:47 pm, henry <[email protected]> wrote: > My code can connect my db with following connection string on the same > PC of SQL 2008 R2 DB: > > Data Source=XYZ\SQLSERVER;Initial Catalog=my_db;Integrated > Security=True;uid=user;pwduserpassword; > > But when I use the same connection string to login to the db from > another PC, I failed. If I take ";Integrated Security=True" out, I got > login error. > > How to fix this? > > -Henry
