'Instances' of SQL Server 2000?

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

Date: Thu, 22 Jul 2004 12:42:04 -0700

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: Running multiple instances in production environment. Good or bad?
    ... > Wayne Snyder, MCDBA, SQL Server MVP ... > that login sysadmin role membership... ... >> to be negative to running multiple instances in a production ... > There are several reasons why most of us would TRY very hard NOT to have ...
    (microsoft.public.sqlserver.server)
  • Re: Additional instances and licensing...
    ... "A Microsoft SQL Server 2005 Enterprise Edition license entitles you to install multiple instances of SQL Server 2005 Analysis Services on a single computer. ...
    (microsoft.public.sqlserver.setup)
  • Re: 3 queries about active/active and multi-instance
    ... To run multiple instances of SQL Server in the same machine. ... machines are servicing the same database. ... Multiple instance cluster is more ...
    (microsoft.public.sqlserver.clustering)
  • Re: Running multiple instances in production environment. Good or bad?
    ... Wayne Snyder, MCDBA, SQL Server MVP ... > to be negative to running multiple instances in a production ... There are several reasons why most of us would TRY very hard NOT to have ...
    (microsoft.public.sqlserver.server)
  • Re: Multiple databases
    ... I prefer multiple databases unless I have a reason to go multiple instances. ... Tibor Karaszi, SQL Server MVP ... > Multiple instances of Sql server, ...
    (microsoft.public.sqlserver.server)