I'm currently having a very frustrating time trying to connect a newly
installed Win 2003 Standard Edition (R2) web server to an existing SQL server
2000 db.

The web server needs to connect to three db's in all, one being server 2005
and the other both being 2000. But for what ever reason one of the Sql server
2000 db's cannot be connected to via the new server.

If i try to ping the server, this works, however when i try to telnet on
port 1433, this doesn't connect to the server in question. The internal
firewall rules have been configured as far as we can tell (after all the two
other database servers work OK) to allow access but we've now got a bit
stumped.

Any ideas would be greatfully recieved!

Many thanks,
--
=============
VB .NET Developer
http://www.rocketscience.uk.com
http://www.salesrus.eu

What is the error message?

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
http://kevin3nf.blogspot.com


"JumpingMattFlash" <JumpingMattFlash@discussions.microsoft.com> wrote in
message news:C557AD06-BC32-4382-97AA-0E7E433F772F@microsoft.com...
> I'm currently having a very frustrating time trying to connect a newly
> installed Win 2003 Standard Edition (R2) web server to an existing SQL
> server
> 2000 db.
>
> The web server needs to connect to three db's in all, one being server
> 2005
> and the other both being 2000. But for what ever reason one of the Sql
> server
> 2000 db's cannot be connected to via the new server.
>
> If i try to ping the server, this works, however when i try to telnet on
> port 1433, this doesn't connect to the server in question. The internal
> firewall rules have been configured as far as we can tell (after all the
> two
> other database servers work OK) to allow access but we've now got a bit
> stumped.
>
> Any ideas would be greatfully recieved!
>
> Many thanks,
> --
> =============
> VB .NET Developer
> http://www.rocketscience.uk.com
> http://www.salesrus.eu

On trying to create a new ODBC connection i get the error, access denied or
server cannot be found.

Thanks,
--
=============
VB .NET Developer
http://www.rocketscience.uk.com
http://www.salesrus.eu


"Kevin3NF" wrote:

> What is the error message?
>
> --
> Kevin Hill
> 3NF Consulting
> http://www.3nf-inc.com/NewsGroups.htm
> http://kevin3nf.blogspot.com
>
>
> "JumpingMattFlash" <JumpingMattFlash@discussions.microsoft.com> wrote in
> message news:C557AD06-BC32-4382-97AA-0E7E433F772F@microsoft.com...
> > I'm currently having a very frustrating time trying to connect a newly
> > installed Win 2003 Standard Edition (R2) web server to an existing SQL
> > server
> > 2000 db.
> >
> > The web server needs to connect to three db's in all, one being server
> > 2005
> > and the other both being 2000. But for what ever reason one of the Sql
> > server
> > 2000 db's cannot be connected to via the new server.
> >
> > If i try to ping the server, this works, however when i try to telnet on
> > port 1433, this doesn't connect to the server in question. The internal
> > firewall rules have been configured as far as we can tell (after all the
> > two
> > other database servers work OK) to allow access but we've now got a bit
> > stumped.
> >
> > Any ideas would be greatfully recieved!
> >
> > Many thanks,
> > --
> > =============
> > VB .NET Developer
> > http://www.rocketscience.uk.com
> > http://www.salesrus.eu
>
>
>

I'm not sure which instances of SQL Server are where, but the SQL Server
Browser Service on the SQL Server computer should be resolving the instance
name to the port number. Make sure it is started.
And SQL Server 2000 must be upgraded to at least SP3 to cooperate with the
SQL Server Browser Service.
--
Rick Byham, MS
This posting is provided "AS IS" with no warranties, and confers no rights.

"JumpingMattFlash" <JumpingMattFlash@discussions.microsoft.com> wrote in
message news:39DEF3F0-9068-4FDC-B847-23CB6AE53751@microsoft.com...
> On trying to create a new ODBC connection i get the error, access denied
> or
> server cannot be found.
>
> Thanks,
> --
> =============
> VB .NET Developer
> http://www.rocketscience.uk.com
> http://www.salesrus.eu
>
>
> "Kevin3NF" wrote:
>
>> What is the error message?
>>
>> --
>> Kevin Hill
>> 3NF Consulting
>> http://www.3nf-inc.com/NewsGroups.htm
>> http://kevin3nf.blogspot.com
>>
>>
>> "JumpingMattFlash" <JumpingMattFlash@discussions.microsoft.com> wrote in
>> message news:C557AD06-BC32-4382-97AA-0E7E433F772F@microsoft.com...
>> > I'm currently having a very frustrating time trying to connect a newly
>> > installed Win 2003 Standard Edition (R2) web server to an existing SQL
>> > server
>> > 2000 db.
>> >
>> > The web server needs to connect to three db's in all, one being server
>> > 2005
>> > and the other both being 2000. But for what ever reason one of the Sql
>> > server
>> > 2000 db's cannot be connected to via the new server.
>> >
>> > If i try to ping the server, this works, however when i try to telnet
>> > on
>> > port 1433, this doesn't connect to the server in question. The internal
>> > firewall rules have been configured as far as we can tell (after all
>> > the
>> > two
>> > other database servers work OK) to allow access but we've now got a bit
>> > stumped.
>> >
>> > Any ideas would be greatfully recieved!
>> >
>> > Many thanks,
>> > --
>> > =============
>> > VB .NET Developer
>> > http://www.rocketscience.uk.com
>> > http://www.salesrus.eu
>>
>>
>>

Many thanks for everyones input. Seems as though it was due to the firewall
settings. Changing the rules order has allowed the traffic through.

Thanks again,
--
=============
VB .NET Developer
http://www.rocketscience.uk.com
http://www.salesrus.eu


"Rick Byham, MS" wrote:

> I'm not sure which instances of SQL Server are where, but the SQL Server
> Browser Service on the SQL Server computer should be resolving the instance
> name to the port number. Make sure it is started.
> And SQL Server 2000 must be upgraded to at least SP3 to cooperate with the
> SQL Server Browser Service.
> --
> Rick Byham, MS
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "JumpingMattFlash" <JumpingMattFlash@discussions.microsoft.com> wrote in
> message news:39DEF3F0-9068-4FDC-B847-23CB6AE53751@microsoft.com...
> > On trying to create a new ODBC connection i get the error, access denied
> > or
> > server cannot be found.
> >
> > Thanks,
> > --
> > =============
> > VB .NET Developer
> > http://www.rocketscience.uk.com
> > http://www.salesrus.eu
> >
> >
> > "Kevin3NF" wrote:
> >
> >> What is the error message?
> >>
> >> --
> >> Kevin Hill
> >> 3NF Consulting
> >> http://www.3nf-inc.com/NewsGroups.htm
> >> http://kevin3nf.blogspot.com
> >>
> >>
> >> "JumpingMattFlash" <JumpingMattFlash@discussions.microsoft.com> wrote in
> >> message news:C557AD06-BC32-4382-97AA-0E7E433F772F@microsoft.com...
> >> > I'm currently having a very frustrating time trying to connect a newly
> >> > installed Win 2003 Standard Edition (R2) web server to an existing SQL
> >> > server
> >> > 2000 db.
> >> >
> >> > The web server needs to connect to three db's in all, one being server
> >> > 2005
> >> > and the other both being 2000. But for what ever reason one of the Sql
> >> > server
> >> > 2000 db's cannot be connected to via the new server.
> >> >
> >> > If i try to ping the server, this works, however when i try to telnet
> >> > on
> >> > port 1433, this doesn't connect to the server in question. The internal
> >> > firewall rules have been configured as far as we can tell (after all
> >> > the
> >> > two
> >> > other database servers work OK) to allow access but we've now got a bit
> >> > stumped.
> >> >
> >> > Any ideas would be greatfully recieved!
> >> >
> >> > Many thanks,
> >> > --
> >> > =============
> >> > VB .NET Developer
> >> > http://www.rocketscience.uk.com
> >> > http://www.salesrus.eu
> >>
> >>
> >>
>
>