Filter
Top Products
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