Error when executing an esp – Sybase DC35823-01-1500-04 User Manual

Page 83

Advertising
background image

CHAPTER 5 Setting Up Communications Across the Network

Configuration Guide

67

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.

v

Investigating the port assignment

1

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

2

Determine 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.

3

To 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.

v

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

1

Do 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.

2

Start 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

Advertising