How to access database in asp.net on Lan (IIS Server)

Question

I have an asp.net website that runs on my localhost and creates records on Sql server 2008 on my machine. When i try to run this website over LAN (from an other pc) the pages that don’t have any relation with the database run.
The other pages that shows records don’t run.
Any solution for this?

Thanks in advance.

What type of authentication are you using for your SQL database? — Andrei Dvoynos, Apr 18 '14 at 07:38
@AndreiD.. I am using Windows Authentication in the sql server — Abhinav, Apr 23 '14 at 07:23
@raja.. i am getting no exceptions. The records from the database doesn't get displayed. — Abhinav, Apr 23 '14 at 07:24

score 1 · Answer 1 · edited May 23 '17 at 12:20

1

Ensure your connection string is correctly pointing to the SQL Server with the right credentials.
Ensure the SQL server can be connected remotely by opening up port 1433, 1434 etc in the Firewall. (else you'll get an error like 'a network-related or instance specific error...')

Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?

edited May 23 '17 at 12:20

Community

1
1

answered Apr 18 '14 at 08:37

Raja Nadar

9,409
2
32
41

How to access database in asp.net on Lan (IIS Server)

1 Answers1