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
>>
>>
>>