PRB: LAN Manager Maxusers Limits SQL Server Connections

• Microsoft SQL Server Programmer's Toolkit, version 4.2

SYMPTOMS

DB-Library (DB-Lib) applications cannot connect to a SQL Server running on a LAN Manager network; they receive db-lib error 10004. DOS and OS/2 ISQL return the message, "DB-Library: Unable to connect: SQL Server is unavailable or does not exist." OS/2 SAF returns the message, "The specified SQL Server is not running. OK to start?" DOS SAF returns the message, "Error! Couldn't connect with server. Error number 10004."

CAUSE

The LAN Manager maxusers parameter limits the number of users who can use the server simultaneously. When LAN Manager is installed, maxusers is set to 10 by default.

WORKAROUND

Using the LAN Manager Setup program, choose View/Modify from the Actions menu and increase the Maximum Users setting in the Server Primary Parameters dialog box.

Note that the "Microsoft LAN Manager 2.1 Administrator's Reference" states on page 251 states that the value of maxusers should include the number allowed by your LAN Manager Additional User Pak(s), plus the number of users accessing the server through interprocess communication (IPC) connections. Examples of IPCs include the named pipes used by network application programs, such as the NET RUN command or Microsoft SQL Server. Please note that this also applies Microsoft LAN Manager 2.0 and 2.1.