Connect to sql via ip adress.

Question

I have two computers in local network the first is the server with ip 192.168.1.10 the second is the client 192.168.1.12

How can i connect client to server via ip adress>?And also client to read sqldatabase from server. I have create a connection named sillogos.mdf and i used windows authentication 

 I found this: Data Source=192.168.1.10;Network Library=DBMSSOCN; Initial Catalog=sillogos;User ID=?;Password=?;

Also Which is username and  password( i used windowsauthentication)

I take massage login failed user'sa'

My server have this connection string Data Source=.\SQLEXPRESS;AttachDbFilename=C:\backup\sillogos.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

Answer 1

Hello,

Sure you can use the IP address to connect to a SQL Server, but if it's a named instance then you have to add the instance Name or the used IP port. To logon using Windows Authentication you have to use the Integrated Security, as in your connection string. Example with IP address and instance name

Source=192.168.1.12\SQLEXPRESS;AttachDbFilename=C:\backup\sillogos.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

and with IP port, here 1433 as example:

Source=192.168.1.12, 1433;AttachDbFilename=C:\backup\sillogos.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Thank you for reply.   I use this 

 SqlConnection con = new SqlConnection(@"Data Source=Source=192.168.1.11\SQLEXPRESS;AttachDbFilename=C:\backup\sillogos.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into customermaster(name) values ('" + textBox1.Text + "')",con);
            cmd.ExecuteNonQuery();

con.close();

and i have this message

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Answer 3

Can you connect to SQL Server using SSMS with the same Server Name?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 4

No i cant connect i use 

192.168.1.11\SQLEXPRESS

With windows authentication

Answer 5

Sure the SQL Server is running?
By Default remote Connections are disables for Express Edition => How to enable remote connections in SQL Server 2008?
Is IP network protocol enabled? => How to: Enable the TCP/IP Protocol for a Database Instance

See also: How to Troubleshoot Connecting to the SQL Server Database Engine

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 6

I have install in two computers visual studio 2010.

In first machine i add a connection "Microsoft SQL Server Database File (SqlClient)" and database filename 'sillogos.mdf'

In second computer i want to connect to sillogos.mdf

and to run this code

SqlConnection con = new SqlConnection(@"Data Source=Source=192.168.1.11\SQLEXPRESS;AttachDbFilename=C:\backup\sillogos.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into customermaster(name) values ('" + textBox1.Text + "')",con);
            cmd.ExecuteNonQuery();

Answer 7

Data Source=Source=192.168.1.11\SQLEXPRESS;AttachDbFilename=C:\backup\sillogos.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")

AFAIK starting a user instance on a remote machine is not possible, they work only local. You have to attach your database as a permanent database to SQL Server to access it from remote machines: Attach a Database

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 8

Sir it doesnt work . I have attached my database as you said. If i will try to connect with SSMS what will i write to server name?

192.168.1.11\SQLEXPRESS?

with windows authentication?

Answer 9

Please see:https://msdn.microsoft.com/en-us/library/jj653752%28v=vs.110%29.aspx?f=255&MSPPError=-2147217396

Answer 10

Have you modified your Connection string to

Data Source=Source=192.168.1.11\SQLEXPRESS;Initial Catalog=sillogos;Integrated Security=True;Connect Timeout=30;")

---

Olaf Helper

[ Blog] [ Xing] [ MVP]