Sql server database could not connect in Lan

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi i am developing window application through vs 2008 and sqlserver 2008. its running perfectly in my system. but. i need to install and access my application to multiple system. so i put one system as server. i installed sql server in my server only. its running perfectly by (local). but i cannt access Db through LAN
Here is my connection string

Data Source=MyServer;Initial Catalog=SampleDb;User ID=sa;Password=abc

.

Its not working through LAN. Is any configuration in sqlserver product. help to resolve it.

Posted 4-Apr-14 0:09am

sencsk

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andrius Leonavicius · Answer 1 · 2014-04-04T00:36:00

Hi,

First of all, you need to check several things:
1. Is TCP / IP enabled in SQL Server Configuration?
2. Is Windows Firewall not blocking SQL Server port?
3. Are remote connections enabled in SQL Server Management?

Please refer to this post:
SQL Server Manager can not connect to a remote database[^]

Sql server database could not connect in Lan

1 solution

Solution 1

Add your solution here

Preview 0

Sql server database could not connect in Lan

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us