>-----Original Message-----
>I'm trying to troubleshoot a SQL Server 2000 Developer
>edition install on Win2000 Pro SP4. 2 local accounts
>created for MSSQLServer and SQLServerAgent services to
>run under.
>
>The install seems to go fine but I cannot connect to the
>server in enterprise manager. It displays (Local)
>(Windows NT) instead of the desktop name.
>
>When I attempt to connect in Enterprise manager I get the
>following message:
>"A connection could not be established to (local).
>Reason: General network error. Check your network
>documentation. ConnectionRead(WrapperRead())..
>Please verify SQL server is running and check your SQL
>server registration properties (by right-clicking on the
>(local)node and try again."
>
>I am starting with someone else's base install, so I
>believe there is some config or parameter that is
>blocking connection. Maybe an IPSEC policy??
>
>Any insight or a pointer to a detailed document on how
>the various components talk to the SQL server would be
>helpful.
>
>I've tried SQLDiag.exe and the message is "Unable to
>connect to server".
>
>I've tried SQL Profiler and I get a 'general network
>error'.
>
>Server Network Utility is set to use TCP/IP only.
>Although it also failed when Named Pipes was still there.
>
>Can't add it to a new SQL Server group.
>Can't start the SQLServerAgent.
>
>ErrorLog file shows databases starting up and then "SQL
>Server is terminating due to 'stop' request from Service
>Control Manager."
>
>Can ping system by name
>netstat -a doesn't show it listening on port tcp 1433 or
>UPD 1434.
>netstat -e shows unknown protocols but no discards or
>errors.
>nbtstat -A shows the MSSQLServer account
>
>There is an exception.log in the SQL logs with an
>Exception_Stack_Overflow
>Can anyone give me any info on that?
>
>SQLAgent.out file contains following info:
>[298] SQLServer Error: 11, General network error. Check
>your network documentation. [SQL State 08S01]
>[298] SQL Server Error: 4, ConnectionRead (WrapperRead
>()). [SQL State 01000]
>[000] Unable to connect to server '(local0';
>SQLServerAgent cannot start
>[098] SQLServerAgent terminated (normally)
>
>Any help would be appreciated.
>.