Sybase DC35823-01-1500-04 manual Error when executing an ESP, Investigating the port assignment

CHAPTER 5 Setting Up Communications Across the Network

2
00:00000:00002:2003/09/22 12:37:23.68 server	Unable to initialize network 0
00:00000:00002:2003/09/22 12:37:23.68 kernel	ninit: All master network
listeners have failed. Shutting down.
00:00000:00002:2003/09/22 12:37:23.68 kernel	ueshutdown: exiting
00:00000:00016:2003/09/22 16:11:35.46 server	SQL Server shutdown by request.

vInvestigating the port assignment

1Look in the interfaces file to identify the port number assigned to the server.

2Determine whether another process is using the same port number by entering:

netstat -a

If the port number is presented as a local address in the netstat output, you cannot use that port for the server. Another process is already using that port.

3To verify that the server port is in use, start the server manually.

The server does not start if its assigned port number is already in use.

For information on starting servers manually, see the installation documentation for your platform and the Adaptive Server Utility Guide.

vIf a stale server process is retaining use of the port number

1Do one of the following:

•Use the operating system kill command to terminate the process.

•Use another port number for the server by modifying the interfaces file.

2Start the server manually to confirm that the port number is available.

For information on starting servers manually, see the installation documentation for your platform and the Utility Guide.

Error when executing an ESP

If you attempt to execute an ESP (extended stored procedure), you may see the following error:

00:00000:00008:1997/09/10 12:52:53.03 kernel XP Server failed to start. Try bringing up XP Server manually. Check SQL Server documentation for more

Configuration Guide 67