MS SQL Server 7.0 - connections limit

[Guest_imported]

Hi all

I installed typical version of MS SQL Server 7.0. But unfortunatelly I've done something wrong during instalation and it is 1 user server . I readed help and found that max connections limit could be increased. I've done as described in help and increased limit to 20 - but I still can't connect to server from 2 computers at once. Some person told me that I have to reinstall SQL Server and look where that limit is defined during installation. Is it the only way ?

Regards, Igor.

 

[tlbroadbent]

Make sure the server is not set in single-user mode. Check the start up options. -m is the option that starts SQL Server in single-user mode.

When you setup SQL Server, you must choose the licensing mode - per seat or per server - and number of licenses purchased. Make sure the number of licenses is correct. Use the licensing applet in Control Panel to check the number of licenses installed. You can change the number to match the number of licenses you purchased. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.