We help IT Professionals succeed at work.

SQL State HYT00. Timeout expired proplem

Venkat Mani
Venkat Mani asked
on
440 Views
Last Modified: 2017-05-12
trying to connect sql using odbc from server ,
creater User Dsn and test ,success
but when i used to login from windows application "SQL State HYT00. Timeout expired proplem" this  error message  poped up
Comment
Watch Question

HainKurtSr. System Analyst
CERTIFIED EXPERT

Commented:
make sure that SQL Server mixed authentication mode (SQL Server and Windows Authentication mode) is chosen
HainKurtSr. System Analyst
CERTIFIED EXPERT

Commented:
how did you test it?
are you providing same username/password in your app?
are you sure parameters are passed correctly?
did you debug your app for username/password?
Venkat ManiAnalyst Programmer

Author

Commented:
created a User  DSN  With sa and paswd adding database to DSN

after that     <add name="Test"       connectionString=" Dsn=myCH;  uid=sa; PWD=******"      providerName="System.Data.SqlClient"/> by using this connection string i am trying to connect with the program ,

i tested this application locally no problem but now o tried to install on client netwrok i got this error
Dorababu MSenior Software Engineer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Try adding some timeout to your connection string and check once. Also what was the TCP/IP configuration is it default or name pipes?
Venkat ManiAnalyst Programmer

Author

Commented:
Thank you for your reply,
used timeout in connection string still same result,
tcp/it is default ,what should be best  for this tcp/ip or named pipes
Sr. System Analyst
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
ste5anSenior Developer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Venkat ManiAnalyst Programmer

Author

Commented:
thank you firewall problem in server solved
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.