Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 138
  • Last Modified:

SQL Timeout expired issues

Hi All,

  I have an application which connects to my SQL 2008 R2 server, I have 200 users connected and using it, one week before I some users started to get an error while opening the application . the error ( could not connect to database, Microsoft OLE DB provider for SQL. SQLState HYT00 timeout expired .

I have tested the network from the client to server and see no slowness and the ping is stable. the user will connect after clicking the message, my SQL application is client/server and I don't user any ODBC.

This issue happeining for some users and not for all. my link fiber and its stable

Please advise
0
ITMaster1979
Asked:
ITMaster1979
  • 2
  • 2
3 Solutions
 
ste5anSenior DeveloperCommented:
HYT00 errors are network layer associated. Thus it maybe really that these users have a network problem (nic, switches).

Where do they get the error? When connecting or executing SQL statements? Consider using SQL Profiler..
0
 
ITMaster1979Author Commented:
they get it when they try to open the application , some of the users are connected to the same switch and working fine.
0
 
ste5anSenior DeveloperCommented:
Gosh, what does this mean? Open the application? Are you the developer of this application, a DBA of the servers behind or just the guy to fix it?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
It always the same users having this issue?
It always occurs at the same time of the day?
It always occurs in the same option inside the application?
0
 
ITMaster1979Author Commented:
good
0

Featured Post

Choose an Exciting Career in Cybersecurity

Help prevent cyber-threats and provide solutions to safeguard our global digital economy. Earn your MS in Cybersecurity. WGU’s MSCSIA degree program was designed in collaboration with national intelligence organizations and IT industry leaders.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now