Re: 'Instances' of SQL Server 2000?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John (John_at_discussions.microsoft.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 13:15:03 -0700

It is poor design IMO, but I have to live with it. On the matter of the multiple instances, what is meant by 'instance'? multiple installations? multiple 'spawnings' of SQL Server under a parent 'SQL Server manager-like' server process? does it end up looking like multiple servers systems each running a SQL Server, each with different names, data paths, etc, but actually all running on the same server system?

John

"Eric Sabine" wrote:

> I believe Standard edition is licensed per instance but Enterprise Edition
> can be installed with multiple instances on a server. It's best to check
> the EULA to be totally certain though. But having to buy one new copy of SE
> could be worth looking at why this very odd requirement was "assumed" in the
> application's design IMO.
>
> hth
> Eric
>
> John wrote:
> > Our application requires multiple instances of SQL Server 2000 in
> > order to have multiple databases, which the app clients use. Has
> > something to do with the name of the SQL Server instance; each
> > instance needs to be named differently.
> >
> > How does this work? Do I install SQL Server multiple times in
> > different locations, or is it simply a defined thing in SQL Server?
> > Is there a 'per instance' licensing issue, or will my one SQL Server
> > license cover the multiple instances of SQL Server on one server
> > system?
> >
> > Thanks,
> > John
>
>
>

Relevant Pages

  • Re: Quickbooks is eating up 300 megs of RAM and I want to reduce it to 150
    ... IT MUST go on the server in order to share out the datafile. ... John wrote: ... My client called me on a Saturday to ask what the admin password was so the bookkeeper could install Quickbooks 2006. ...
    (microsoft.public.windows.server.sbs)
  • Re: Firedaemon Application
    ... There's an exploit circulating that involves this software. ... system, and you didn't install it, then I'd say you been whacked. ... > from a w2k server. ...
    (microsoft.public.win2000.security)
  • Re: Add a W2K3 to a W2K domain
    ... fixes you need to install on your Win2000 servers, ... Microsoft MVP - Windows Server Networking ... "John Lu" wrote: ...
    (microsoft.public.windows.server.setup)
  • Full Text Search
    ... I did not install full text search on my server. ... install in order to select the FTS component? ... John ...
    (microsoft.public.sqlserver.server)
  • Re: "Classic logon" screen in XP does not remeber the user name
    ... John N ... XP Pro workstation [not for W2003 Server though]. ... user account to the Remote Desktop Users group which should show as ...
    (microsoft.public.windowsxp.security_admin)