September 3, 2013 at 8:10 am
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!!!!!!!!!
September 3, 2013 at 8:19 am
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/
September 3, 2013 at 8:22 am
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
September 3, 2013 at 8:44 am
Ask your network people to see if they can find anything big going across at that time.
September 4, 2013 at 7:36 am
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......
September 4, 2013 at 7:51 am
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..
September 4, 2013 at 7:52 am
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.
September 4, 2013 at 7:54 am
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......
September 4, 2013 at 7:55 am
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/
September 4, 2013 at 7:58 am
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/
September 5, 2013 at 10:14 am
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)
November 20, 2013 at 8:35 am
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