How to connect to SQL Server from a C# program on another computer

Question

SqlConnection con = new SqlConnection("server=192.168.0.100,1400;user=Users;password=password;database=Example1;integrated security = true;");

SqlDataAdapter sda = new SqlDataAdapter();
DataTable dbdataset = new DataTable();

BindingSource bsource = new BindingSource();
SqlCommand cmd = new SqlCommand();

public void loaddata()
{
    try
    {
        SqlCommand cmdatabbase = new SqlCommand(" select * from Example1.dbo.Users ;", con);

        sda.SelectCommand = cmdatabbase;

        sda.Fill(dbdataset);

        bsource.DataSource = dbdataset;
        dataGridView1.DataSource = bsource;
    }
    catch (Exception ex)
    {
       MessageBox.Show(ex.ToString());
    }

This is my code in C# Winforms application. On my computer it is working but from another computer it shows error (it can't load table in datagridview). I added rule in firewall and I enable tcp in SQL Server Configuration Manager but it still doesn't work! I tried every solution that found in internet but it didn't work.

a busy cat http://non-98.ucoz.com/Untitled5.jpg

I saw this in another computer when running a program.

Give us more details. What is the error? On which line do you get ? — Soner Gönül
– Soner Gönül, Commented Nov 24, 2013 at 9:12
@Sudhakar Just want to ask....did you mess up " User2012384" with "user2971569"? — User2012384
– User2012384, Commented Nov 24, 2013 at 9:18
Try removing "integrated security = true", see if it works.. — User2012384
– User2012384, Commented Nov 24, 2013 at 9:22

Thilina H · Accepted Answer · 2013-11-24 09:50:56Z

1

You must change the integrated security from true to false. Check this connection strings

edited Nov 24, 2013 at 9:50

Thilina H

5,8267 gold badges28 silver badges56 bronze badges

answered Nov 24, 2013 at 9:34

ms_devel

4921 gold badge10 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Binier Over a year ago

can I use public ip address and my port as my sql server name in managment studio

Binier Over a year ago

I just used in your link this "Connect via an IP address" constring And used my public ip and it worked!!!

Waleed.alhasan Over a year ago

And also check that port 1400 open in firewall of each computer

user2968347 · Accepted Answer · 2013-11-25 09:43:50Z

0

I think this is due to accessibility of the sever.Try either integrated security =False or update connection string

answered Nov 25, 2013 at 9:43

user2968347

211 silver badge6 bronze badges

Collectives™ on Stack Overflow

How to connect to SQL Server from a C# program on another computer

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related