Click here to Skip to main content
Rate this: bad
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
Edited 9-Nov-12 6:01am
digimanus at 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!
Smile | :)
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
0 Sergey Alexandrovich Kryukov 9,535
1 OriginalGriff 8,295
2 Peter Leow 4,839
3 Kornfeld Eliyahu Peter 3,210
4 Maciej Los 2,301

Advertise | Privacy | Mobile
Web01 | 2.8.150327.1 | Last Updated 9 Nov 2012
Copyright © CodeProject, 1999-2015
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