HI,

Our production is running on Sql Server 2000. It works pretty goods
but for the last couple of weeks we are getting the below error! As a
fix we just restart the SQL Server service and it just works fine. It
has been happening quite often these days. The thing that surprises
me
is in the error message it talks about the SQL Server 2005. But our
production runs on SQL SErver 2000.


Here is the error message.


************************************************** *************************
*********************************
Error has occured while establishing a connection to ther server.
When
connecting to SQL server 2005 this failure may be caused by the fact
under the default settings SQL Server doesn't allow remote
connections. (provider named pipes provider, err : 40 couldn't open a
connection to SQL Server
************************************************** *************************
**********************************


Can some one me with this?


Thanks in advance.


-L

Check you firewall settings. You have to open port number 1433 on your
firewall, if you SQL Server is using this port otherwise you can always check
you port settings, and also check if your remote connection is enabled or not
by executing sp_configure command.

"Learner" wrote:

> HI,
>
> Our production is running on Sql Server 2000. It works pretty goods
> but for the last couple of weeks we are getting the below error! As a
> fix we just restart the SQL Server service and it just works fine. It
> has been happening quite often these days. The thing that surprises
> me
> is in the error message it talks about the SQL Server 2005. But our
> production runs on SQL SErver 2000.
>
>
> Here is the error message.
>
>
> ************************************************** *************************Â
> *********************************
> Error has occured while establishing a connection to ther server.
> When
> connecting to SQL server 2005 this failure may be caused by the fact
> under the default settings SQL Server doesn't allow remote
> connections. (provider named pipes provider, err : 40 couldn't open a
> connection to SQL Server
> ************************************************** *************************Â
> **********************************
>
>
> Can some one me with this?
>
>
> Thanks in advance.
>
>
> -L
>
>
>