Click here to Skip to main content
Rate this: bad
good
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 1:00am
Edited 9-Nov-12 5:01am
digimanus26.6K
v2
Comments
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
good
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 | :)
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Hi,
 
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.
  Permalink  

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

  Print Answers RSS
0 Maciej Los 589
1 OriginalGriff 379
2 CPallini 205
3 RyanDev 175
4 Sergey Alexandrovich Kryukov 170
0 OriginalGriff 5,649
1 Sergey Alexandrovich Kryukov 4,783
2 Peter Leow 2,954
3 Maciej Los 2,689
4 DamithSL 2,465


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