CODEWITHSUNDEEP
sql-server
Farhad paikan
Farhad paikan

Reputation: 89

Access database over network

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?

Upvotes: 1

Views: 175

Answers (3)

Lucbert
Lucbert

Reputation: 74

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.

Upvotes: 1

Michał Komorowski
Michał Komorowski

Reputation: 6238

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.

Upvotes: 0

Manish Kumar
Manish Kumar

Reputation: 507

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

Upvotes: 1

Related Questions