Intermittent Connection Timeouts

I'm having an issue with what appears to be SQL Server 2005 deciding to randomly ignore new connections.

I currently have two virtual servers - one running just SQL Server 2005, the other running Reporting Services, Windows Sharepoint Services and Team Foundation Server.

For 3 weeks, it was all working perfectly, then on Wednesday night the server (and both Virtual Servers) was rebooted after installing the latest updates for Windows. Since then, I've had this issue.

It will work fine for a while, then it'll start throwing loads of Errors and Warnings into the Event Log, all along the lines of unable to connect to the database. The Reporting Services Configuration utility throws up the same problem. Then randomly, it'll start working again.

If anyone has any ideas, they would be much appreciated as this is driving me crazy!

Thanks!

How are users connecting to the database? If they are connecting through a webfarm, I've had similar troubles and might be able to help.
Tim|||

Hi Tim,

I have an ASP.NET 2.0 website connected to a SQL Server 2005 database hosted by a 3rd party that has been running without problems. In the last week we are experiencing intermittent connection problems with the following error - 'An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections'

Any ideas on what might be causing this?

Regards Andy

sql

Interfacing SSRS Deep Integration to Sharepoint - 3rd time lucky?!

I am looking for the actual interface that will allow me to interface with
the SSRS Web Part from the Sharepoint Deep Integration suite. It appears that
it needs a doclib interface, I guessed it was the IListProvder but now find
it is not and not even IRowProvider. Can you / they tell me what it needs to
be to properly interface with it both from the
'Get Report Definitions From' connection
but also
'Get Report Parameters From' connection
For The latter I also need to know how to marry up the Parameters in say a
Filter Web Part with the SSRS Web Part Deep Integration.
Now have finally configured no spam alias and set up profile - will this
make a difference to the response time! Come on Microsoft you can do this,
not rocket science surely?
--
Steve G16 days and counting still no response - what happened to 48 hours response
promise?
--
Steve G
"ezeget.com" wrote:
> I am looking for the actual interface that will allow me to interface with
> the SSRS Web Part from the Sharepoint Deep Integration suite. It appears that
> it needs a doclib interface, I guessed it was the IListProvder but now find
> it is not and not even IRowProvider. Can you / they tell me what it needs to
> be to properly interface with it both from the
> 'Get Report Definitions From' connection
> but also
> 'Get Report Parameters From' connection
> For The latter I also need to know how to marry up the Parameters in say a
> Filter Web Part with the SSRS Web Part Deep Integration.
> Now have finally configured no spam alias and set up profile - will this
> make a difference to the response time! Come on Microsoft you can do this,
> not rocket science surely?
> --
> Steve G
>