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

inter DB connections

Ok been a while.
I have one db that uses DBname..Procname to execute a proc in another dB.
works fine.
On the same server I have created some new DB's and tried the same thing.
I get "Can not find the DB on the server"
I created the DB using the ADP upsize
is there a registration that I need to-do?forgot
this is being called from AmericanBridalInterface db
here is the sp call
execute AmercianBridal..SP_LkUpSupplier @.SupplierID
here is what the profiler shows
[AmericanBridalInterface]..sp_procedure_params_rowset N'SP_LkUpSupplier', 1,
N'dbo', NULL
if exists (select * from syscomments where
id=object_id(N'[dbo].[sp_procedure_params_rowset]')) select c.text,
c.encrypted, c.number, xtype=convert(nchar(2), o.xtype), datalength(c.text),
convert(varbinary(8000), c.text) from syscomments c, sysobjects o where
o.id = c.id and c.id = object_id(N'[dbo].[sp_procedure_params_rowset]')
order by c.number, c.colid
select o.name from sysobjects o where o.xtype = N'P' and
(OBJECTPROPERTY(o.id, N'ExecIsStartup') = 1) and (o.name =N'sp_procedure_params_rowset')
"BJ Freeman" <bj_newsgroups@.free-man.net> wrote in message
news:eQ7zEvGWDHA.548@.tk2msftngp13.phx.gbl...
> Ok been a while.
> I have one db that uses DBname..Procname to execute a proc in another dB.
> works fine.
> On the same server I have created some new DB's and tried the same thing.
> I get "Can not find the DB on the server"
> I created the DB using the ADP upsize
> is there a registration that I need to-do?
>|||never mind. went to sysdatabases and got the name from there.
works now.
"BJ Freeman" <bj_newsgroups@.free-man.net> wrote in message
news:eQ7zEvGWDHA.548@.tk2msftngp13.phx.gbl...
> Ok been a while.
> I have one db that uses DBname..Procname to execute a proc in another dB.
> works fine.
> On the same server I have created some new DB's and tried the same thing.
> I get "Can not find the DB on the server"
> I created the DB using the ADP upsize
> is there a registration that I need to-do?
>