April 1, 2010 at 6:41 pm
Since we switched over to the new system (SQL Server 2008), I am having problems staying connected. If I leave the system for a bit when I go back to use it, it gives me a runtime error #5, connection failure. Is there a time out setting that needs to be adjusted? Accounting has been calling me with the same problems and I have to log them out of the system because it tells them they are already logged in.
Thx in advance .... Dave Miller
April 2, 2010 at 12:17 pm
dmiller-745870 (4/1/2010)
Since we switched over to the new system (SQL Server 2008), I am having problems staying connected. If I leave the system for a bit when I go back to use it, it gives me a runtime error #5, connection failure. Is there a time out setting that needs to be adjusted? Accounting has been calling me with the same problems and I have to log them out of the system because it tells them they are already logged in.Thx in advance .... Dave Miller
It would seem that the application has a connection timeout that is now being enforced. I would check with the application.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 2, 2010 at 12:46 pm
Thx for the reply ... but the same application is running on another Server w/SQL Server 2005 without an issue.
It may be a Windows Server 2003 issue ... I've checked for MS Updates and DotNet 3.0, and that hasn't helped any.
April 2, 2010 at 1:07 pm
dmiller-745870 (4/2/2010)
Thx for the reply ... but the same application is running on another Server w/SQL Server 2005 without an issue.It may be a Windows Server 2003 issue ... I've checked for MS Updates and DotNet 3.0, and that hasn't helped any.
That is not relevant because to install SQL Server 2008 you must install .NET 3.5 and .NET 3.5 SP1. So check connection pooling and how the application is resolving your users. If your application is Winform you may have to manually add users to SQL Server.
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply