you need to go into the sql server management studio and allow remote connections to that server. Do the following
1.MS Sql server 2. Configuration Tools 3.SQL Server Surface Area Configuration Go to allow remote connections. I would recommend tcp/ip and named pipes. On Sat, Dec 4, 2010 at 4: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
