Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Timeout expired

Author  Topic 

neilgilbert1234
Starting Member

9 Posts

Posted - 2008-08-29 : 08:56:41
Hi,

With have a client who is running Sage on SQL2005, which keeps recieving through out the day multiple timeout errors. We are trying to track down exactly what the issue is.
One thing that i have noticed is that the Collation on the main instance is SQL_Latin_General_CI_AS and the database is Latin_General_CI_AS could this cause the database to time out and fall over?

Thanks in advance...

Neil

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-08-29 : 09:01:17
First of all, when do you get timeout expired?

1) When connecting with proper username and proper password?
2) When trying to query the database?
3) Other. If so, what?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

neilgilbert1234
Starting Member

9 Posts

Posted - 2008-08-29 : 10:47:35
It seems to be at random, they can work away fine using the database and then all of a sudden the whole things almost seems to lock and grind to a halt.
No one can then log in, people who are logged in also get the timeout message
Go to Top of Page
   

- Advertisement -