Click here to Skip to main content
12,696,632 members (31,892 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# SQL-Server
I have created a windows LAN application, and successfully installed in server system. But when installing in client system and running it, it is showing a 'timeout expiry' error
Posted 9-Nov-12 2:00am
Updated 9-Nov-12 6:01am
digimanus 9-Nov-12 11:02am
in sql settings it is allowed to query the db from other ip? is the user set up in the database? Is a firewall blocking you? perhaps more information needed.
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Three steps clear them one by one to connect with database on server from remote location(Client - pc)

1. Lan connection is not proper
Solution : ping server from client

2. Server should have configured properly that it can allow to access database from remote location

3. Connection string is not proper

one by one try to solve steps
and search on google if stuck or ask us, in which step you need help

Happy Coding!
Rate this: bad
Please Sign up or sign in to vote.

Solution 2


As you must be knowing for SQL-SERVER we have different connections for different computers. Your problem might be that of improper connection string. To check the connection string you can do one thing. Install the Visual Studio in the client machine. From there in any application try to create any bound database connection to your database in server using any database control like DataGridView. In the process of establishing the connection you will be finding a step when Visual Studio will be generating a connection string. Check whether this connection string matches with the connection string provided by you. If not use this Visual Studio generated connection string. If there is a lan connection problem you can check it out with ping. Try disabling the firewall. It works many times.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 9 Nov 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100