[Named Pipes]Specified Sql server not found]

I am trying to create Sql Server 2000 remotely using and getting following e
rror on some of the machine, but on some of the machine it is working fine.
All client machine having W2K Prof.
"[Microsoft[[ODBC Sql Server Driver][Named Pipes]Specified S
ql server not found"
Server alias/client using TCP/IP utility. Earlier it was working fine on all
the machine. I only installed Sql Server SP3a, after that it is starting gi
vig the problem.
Let me khow do I handle this.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.693 / Virus Database: 454 - Release Date: 05/31/2004I sort out the problem, by installing MDAC 2.8. Now it is working fine.
"Ashish Kanoongo" <ashishk@.armour.com> wrote in message news:OwSuidHSEHA.139
2@.TK2MSFTNGP09.phx.gbl...
I am trying to create Sql Server 2000 remotely using and getting following e
rror on some of the machine, but on some of the machine it is working fine.
All client machine having W2K Prof.
"[Microsoft[[ODBC Sql Server Driver][Named Pipes]Specified S
ql server not found"
Server alias/client using TCP/IP utility. Earlier it was working fine on all
the machine. I only installed Sql Server SP3a, after that it is starting gi
vig the problem.
Let me khow do I handle this.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.693 / Virus Database: 454 - Release Date: 05/31/2004|||Get the actual OS Error number. Example if the Error is 53, then the error
is Network Name not Found. Usually a WINS issue.
Test with a ODBC DSN to get the entire error message and re-post it here.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.