RE: multiple instances of MSDE

From: Ashish Ruparel [MSFT] (v-ashrup_at_online.microsoft.com)
Date: 04/27/04

  • Next message: Willem van den Broek: "Re: MSDE licensing rules" 
    Date: Tue, 27 Apr 2004 04:37:44 GMT

    Hi Rein,

    Workload Governor in brief :
    Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and
    MSDE 2000 allow 32,767 connections to an instance of the database engine.
    There is no limit for the number of connections that can be executing
    operations at the same time. The only effect of the workload governor is
    that it starts slowing down the database engine when more than eight
    operations are actively running at the same time.

    The following link has more information on Workload Governor.
    http://msdn.microsoft.com/library/?url=/library/en-us/architec/8_ar_sa2_0ciq
    asp

    You can install multiple instance of MSDE, regardless of the number of
    VS.NET license you have.

    Ashish
    This posting is provided "AS IS" with no warranties, and confers no rights.

  • Next message: Willem van den Broek: "Re: MSDE licensing rules"

    Relevant Pages

    • Re: MSDE help
      ... there is no limit to the number of connections on an MSDE server. ... I'm working with SQL Server Magazine to put together a weekly newsletter ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Pros and Cons of SQL v/s MDB
      ... Just wanted to add a caveat to Steve's post: MSDE is *not* a good solution ... The delays increase as more connections are made to the server. ... If users are doing frequent updates to back-end data, ... a SQL Server back-end can be a good option. ...
      (microsoft.public.access.adp.sqlserver)
    • Re: ASP.NET With MS Access
      ... "Like all versions of SQL Server 2000, SQL Server 2000 Personal Edition and ... MSDE 2000 allow 32,767 connections to an instance of the database engine. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: error: not associated with a trusted sql server connection
      ... > trusted SQL Server connection." ... MSDE 2000 installs by default only allowing WindowsNT ... so SQL Server authenticated connections will not be granted ...
      (microsoft.public.sqlserver.msde)
    • Re: error: not associated with a trusted sql server connection
      ... > trusted SQL Server connection." ... MSDE 2000 installs by default only allowing WindowsNT ... so SQL Server authenticated connections will not be granted ...
      (microsoft.public.sqlserver.tools)