Unable to connect to SQL server 2000 using TCP/IP

Sounds like the machine you are trying to connect to the SQL server "yvgfaasql" from is NOT resolving its IP address correctly. In other words, the client machine can't tell what IP the SQL server has.
There are various ways to fix this. Personally, I would just put an entry in the HOSTS file on the client machine, resolving the IP address to the SQL server machine name.

Thanks for replying my question, Joseph. All ip and name are resolved OK. I can ping and DNS query (nslookup) either by names or ip addresses. I also added an entry to the client host files as you suggested but still no go ! Had a look at the MS support website too, but no clues.

If you don't use Novell Netware and you don't mind the overhead that TCP/IP has, remove the IPX/SPX protocol and only have the TPC/IP protocol. save ya a lot of headache.

Troubleshooting IPX/SPX can be anything. Like simply a non compliant NDIS driver or choosing the wrong frame type or mismatched frame type or broadcast type 20 frametype on being propogated or simply the protocol didn't start. If you've got routers SAP may not be enabled or you've got more than 8.

Thanks for your tips, D.R. The Corporate Groups. I could not get clients to connect to SQL server with pure TCP/IP from the begining and I was under pressure to get all clients connected to the server, I therefore had to add ipx/spx to get them connected. At the moment, I am trying to get clients connecting with TCP/IP prior to remove IPX/SPX.

Thanks for your tips, D.R. The Corporate Groups. Yes, my file & print servers are Novell Netware.

I could not get clients to connect to SQL server with pure TCP/IP from the begining and I was under pressure to get all clients connected to the server, I therefore had to add ipx/spx to get them connected. At the moment, I am trying to get clients connecting with TCP/IP prior to remove IPX/SPX off the SQL server.

ok your running Novell Netware and want to include in your network a SQL server for database. You want clients to access the SQL server and are using IPX/SPX protocol for network communications and are adding?? TPC/IP protocol for connecting to SQL??? I know theres a bug in SQL 2000 with IPX/SPX [see article 270667 Microsoft Help & Support] but that pertains to having more than one instance of SQL server on the network listening in on port 33854 . If everything your running is Novell and IPX/SPX protocol you want a SQL server included into your network, use IPX/SPX protocol for communications.

look at Micosoft Help & Support article 311836 and see if this is an instance you see in the event viewer.

The LAN is running a mixture of both IPX/SPX (Novell Netware) and TCP/IP(other such as internet access) and now SQL server.

All I want is to set up all clients to talk to SQL server 2000 with TCP/IP rather than IPX/SPX as I am starting to phase-out IPX/SPX prior to decommision all novell netware servers.

I'll defer to Microsoft's Help & Support Article 328306. I know SQL can be finicky with a lot of demand, That IPX/SPX can cause more problems that its worth when mixed with a TCP/IP network. other than that, cant say.

May be some other application/service is sitting on port 1433 on the server.

I would suggest that you run a scan using a tool like fport to see what is on port 1433

I already used SQLping and it pinged port 1433 successfully. Also from the sql log file, sql server is listening to port 1433.