need some dummy steps to solve this error

[2cxc]

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.

What are possible things i can do to the server to solve this? thanks in advanced

 

[SonOfEmidec1100]

As a start I would ensure that the latest service packs for Windows, SQL Server and MDAC have been applied.

 

[SQLBill]

Was the network down? Can you actually 'reach' the SQL Server from your computer (try a PING test: PING <ipaddress> where the <ipaddress> is the address of the SQL Server).

-SQLBill

 

[2cxc]

yes it was down and still is, and yes i can ping by ip and by name to both the index and sql servers, all successful. As well, i can ping out.

 

[SQLBill]

Is SQL Server up and working? Can you go to the actual machine, login and run a query without problems?

Are you on a WinXP client? If so, did you install Service Pack 2? If so, did you turn off the internal firewall or adjust the ports to Allow TCP Port 1433 (default for SQL Server - automatically blocked with SP2)

-SQLBill

 

[SQLBill]

What is your setup? Are you on a different computer than the SQL Server? Are you on a different network than SQL Server?

-SQLBill

 

[2cxc]

SQLBill, thanks, i'm on the sql server, got it so it can connect to the internet, how does one check the internal firewall? on a winNT

 

[2cxc]

also in the DHCp the sql server has an ip of 127.0.0.1?

 

[2cxc]

also i nthe enterprise manager when i right click>properties the server, i get teh same error message, and to check sql server registration properties

 

[SQLBill]

If the Client computer is WinXP with SP2 that's the only time you need to check the computer's firewall.

The IP is a problem. 127.0.0.1 is the loopback default. That's not good. Have the sysadmin check it out and get it set to the proper IP address.

It's looking like it's the IP Address problem. Someone may have set it up with an incorrect IP address. Start there. I don't know how to change it, but it shouldn't be 127.0.0.1.

-SQLBill

 

[2cxc]

it was a 169. ip and then bumped to a 127.
I think the drivers for the nic need to be reinstalled, i don't know how to set it to the proper ip address, anyone?

 

[SQLBill]

I believe the SQL Server IP address is really the computer's IP Address. Check what the computer/server is using for an IP Address.

-SQLBill