i have just set up a new pc n my office with wink2 server on and with iis and i have some website on it that use a remote sql server now the pages work fine on my remote web server but not on my local one (the one i just set up). the server pc has zonealarm instaled on it and not much else. the error i get when i am on the local server looking at the page is:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Client unable to establish connection

and the error looking at the new server from another pc in the office is:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.


any ideas would be of help thank you very much