Problem on Connecting to SQL Server on Network thru ODBC DSN

am using Sql Server 7 as my database and it resides on a server ruinning on
Windows XP.
I have used the ODBC DSN for sql server and it worked on stand alone
perfectly but
when i tried to reconfigure the ODBC DNS for other client syustems to
connect to the SERVer it is giving me this error
Connection Failed:
SQLstate:01000
SQL Server error:10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect())
Connection failed:
SQLstate:08001
SQL Server error: 17
[Microsoft][ODBC SQL Server DriverSQL Server does not exists or access denied.
Pls am highly frustrated and helpless, pls help me i need this thing to work
pls help me i need ur help
I have checked the Windows Firewall seetings and its even off, so what
exactly is blocking the connection or i dont know , pls just help me out.
I will be expecting ur reply earnestly
--
sammy dot comHello sammydotcom,
If you are connectin using the name of the SQL Server, make sure that Named
Pipes is turned on.
If you are connecting using an IP address, then IP access needs to be turned
on.
There should be a client tools in your SQL Server menu (off of All Programs)
that will allow you to configure the connection type. Additionaly, double
check the SQL Server setup itself and make sure that it can accept Remote
Connections.
Chris Anderson VB-MVP
> am using Sql Server 7 as my database and it resides on a server
> ruinning on
> Windows XP.
> I have used the ODBC DSN for sql server and it worked on stand alone
> perfectly but
> when i tried to reconfigure the ODBC DNS for other client syustems to
> connect to the SERVer it is giving me this error
> Connection Failed:
> SQLstate:01000
> SQL Server error:10061
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
> (Connect())
> Connection failed:
> SQLstate:08001
> SQL Server error: 17
> [Microsoft][ODBC SQL Server DriverSQL Server does not exists or access
> denied.
> Pls am highly frustrated and helpless, pls help me i need this thing
> to work
> pls help me i need ur help
> I have checked the Windows Firewall seetings and its even off, so what
> exactly is blocking the connection or i dont know , pls just help me
> out.
> I will be expecting ur reply earnestly
>