The maximum simultaneous error in SQL Server 7

Posted on 2007-07-20
Last Modified: 2008-02-01
I have a MS Sql Server 7 on MS Server 2000. When my application try to connect to the server and error
show: "The maximum simultaneous user count of 1 licenses for this 'Standard Edition' server has been exceeded".

Please tell me how to solve this problem.

Thank you.

Question by:emi_sastra
    1 Comment
    LVL 75

    Accepted Solution

    Hello mdasoft,

    In Enterprise manager, Right click on the SQL server registered , properties , Connections tab

    set the no of  connections to the no of licenses you have. Otherwise you can change to Enterprose Edition

    Aneesh R

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now