Access database over network

Question

I want to access my database over network. It gives error:

Error: Cannot Connect to 192.168.0.2\SQLEXPRESS

I enabled the TCP/IP from SQL Configuration.

I turn off the firewall.

I allow SQL Server Authentication and Windows mode.

and I can ping to the ip-address.

Why I am not able to connect to database?

Have you tried connecting via SSMS? Is TCP/IP open for your SQL Server? — gofr1, Aug 02 '16 at 07:13
Open a DOS prompt. What does `PING 192.168.0.1` return? If you log on locally can you connect? If you log on locally, you should confirm that that is the correct instance name (SQLEXPRESS) — Nick.Mc, Aug 02 '16 at 07:18
@Nick.McDermaid it ping successfully, and on the server i am able to connect with 192.168.0.2\SQLEXPRESS — Farhad paikan, Aug 02 '16 at 07:20

score 1 · Accepted Answer · answered Aug 02 '16 at 07:07

1

Try to connect by specifying 192.168.0.2,1433 , here 1433 is port.

answered Aug 02 '16 at 07:07

Manish Kumar

509
5
15

like 192.168.0.2, 1433\SQLEXPRESS ? – Farhad paikan Aug 02 '16 at 07:17
only 192.168.0.2,1433 – Manish Kumar Aug 02 '16 at 07:21
If this is the case, you need to ensure the SQL Browser service is running on your server. Then you'll be able to connect by named instance. BTW SQLEXPRESS doesn't usually run on 1433 - are you sure you're connecting to the right instance? – Nick.Mc Aug 02 '16 at 09:02

score 1 · Answer 2 · answered Aug 02 '16 at 07:18

Probably is a server configuration problem. Try as follow.

On the server, open SQL Server Configuration Manager

Open SQL Server Network Configuration on the left panel and select Protocols for YOURSERVERNAME.

On the right panel double click on TCP/IP and be sure that Enabled is set to Yes.

Open the tab IP Addresses and set as Yes the Active and Enabled selection boxes where the IP Address is 192.168.0.2.

score 0 · Answer 3 · edited May 23 '17 at 10:28

You're probably using a wrong instance name. If you want to connect to a default one i.e. MSSQLSERVER use either dot (.) or a machine name or an IP address as a sever name.

If you are not sure what is the name of your instance just run SQL Server Configuration Manager. You can find it in Start menu. Then select SQL Server Services and there you should find something like SQL Server (NAME_OF_YOUR_INSTANCE).

It is also worth reading this article and this question.

Access database over network

3 Answers3