[Microsoft][ODBC SQL Server Driver]Login timeout expired

  • hi everyone! i am a student working with SQL SERVER 2008R2 on windows 8 64-bit os.. from a month i am facing this error whenevr i try to login after 6:30 p.m. this creates a great mess for me.. as i can't do any work after this error..please help me.. its urgent as i am pissed off with this error.i am using SQLServer authentication mode..i even tried to change the connection timeout and running as an administrator..but no improvement-error remains the same

    Microsoft SQLServer Login //this is the title of the dialog box

    Connection Failed:

    SQLState:'HYT00'

    SQL Server Error:0

    [Microsoft][ODBC SQL Server Driver]Login timeout expired

    i have come to this forum with great hope..i want to get rid off with this error..PLEASE help me!!!!!!!!!

  • It only happens after 6:30pm? Do you have other applications running at that time? Do you have login triggers? I take it that at other times of the day everything is fine?

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Do you only get this error after 6:30 pm? Are you a member of sysadmin on the server? If you are, there should be no reason you can't get on. If you're not, speak to the administrator of the server. Alternatively, it may be something that doesn't have anything to do with SQL Server, such as a problem (or planned outage) on the network. Can you even ping the server when you get that message?

    John

  • Ask your network people to see if they can find anything big going across at that time.

  • yes it happens only after 6:30 pm. i don't have any other login trigger...i don't run any other application at that time......

  • John Mitchell-245523 (9/3/2013)


    Do you only get this error after 6:30 pm? Are you a member of sysadmin on the server? If you are, there should be no reason you can't get on. If you're not, speak to the administrator of the server. Alternatively, it may be something that doesn't have anything to do with SQL Server, such as a problem (or planned outage) on the network. Can you even ping the server when you get that message?

    John

    yes it only occurs after 6:30 pm.. i am admin myself... ping command is not recognized on my cmd as i have set its path according to java..n i even don't know the exact syntax to run the ping command..

  • lptech (9/3/2013)


    Ask your network people to see if they can find anything big going across at that time.

    which network people?? i am not getting your point..please explain.

  • Sean Lange (9/3/2013)


    It only happens after 6:30pm? Do you have other applications running at that time? Do you have login triggers? I take it that at other times of the day everything is fine?

    yes it happens only after 6:30 pm. i don't have any other login trigger...i don't run any other application at that time......

  • ritika rishi (9/4/2013)


    John Mitchell-245523 (9/3/2013)


    Do you only get this error after 6:30 pm? Are you a member of sysadmin on the server? If you are, there should be no reason you can't get on. If you're not, speak to the administrator of the server. Alternatively, it may be something that doesn't have anything to do with SQL Server, such as a problem (or planned outage) on the network. Can you even ping the server when you get that message?

    John

    yes it only occurs after 6:30 pm.. i am admin myself... ping command is not recognized on my cmd as i have set its path according to java..n i even don't know the exact syntax to run the ping command..

    the syntax is pretty straight forward.

    ping [servername or ip]

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • There has to be something going on. SQL won't just arbitrarily decide to deny connections after 6:30pm because it is done working for the day. There has to be something happening. About all we can do from here is offer some suggestions about what to look for. Dig through the server logs and sql logs. See if there is a large amount of activity at that time. Maybe there is a sql job or a windows scheduled task? I am just throwing out ideas here...

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Sean Lange (9/4/2013)


    There has to be something going on. SQL won't just arbitrarily decide to deny connections after 6:30pm because it is done working for the day. There has to be something happening. About all we can do from here is offer some suggestions about what to look for. Dig through the server logs and sql logs. See if there is a large amount of activity at that time. Maybe there is a sql job or a windows scheduled task? I am just throwing out ideas here...

    i appreciate your help honestly.:-) .. but please try to understand my situation.. believe me i've gone through all the logs,permissions ,task manager,scheduler n all..but i am unable to configure the error generator..Moreover i tried to run by changing my pc's time..it worked for only an hour..

    i can't change my pc's time again & again n restart my pc..

    even yesterday it stopped working after 6:30, ran for an hour(after changing time),and did not run even till today morning 8:00 a.m..

    please tell me any solution that i can do by changing some specific settings.. (being just a student i don't know much how to deal with logs)

  • We had a similar issue and it appears to have happened when a network backup was running. The backup failed and we got the error on the local server. SQL Management Studio was unable to log into local SQL Instance until SQL Services were restarted. Once the restart of services was complete, everything worked normally. Troubleshooting the network backups and rescheduling the SQL jobs seemed to prevent it from happening again.

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply