Instances of SQL

Hi,

Is it possible to install more than one instance of SQL on the same server?
I am thinking of the SQL that comes with Windows 2003 SBS (Small business)

--
Thank you
Please post onlyYes. Sql2k supports named instances.

http://msdn.microsoft.com/library/e...nstall_259u.asp

"!!bogus" <hello@.microb.com> wrote in message
news:Dwavc.95442$tb4.3789522@.news20.bellglobal.com ...
> Hi,
> Is it possible to install more than one instance of SQL on the same server?
> I am thinking of the SQL that comes with Windows 2003 SBS (Small business)
> --
> Thank you
> Please post only|||"!!bogus" <hello@.microb.com> wrote in message news:<Dwavc.95442$tb4.3789522@.news20.bellglobal.com>...
> Hi,
> Is it possible to install more than one instance of SQL on the same server?
> I am thinking of the SQL that comes with Windows 2003 SBS (Small business)

SQL2000 supports multiple instances (see Books Online), but you need
to consider the impact on the server resources - you will need to
manage CPU and memory carefully to give each instance enough to work
with, as well as leaving enough for the OS and other applications. I
don't know anything about SBS specifically, but my feeling would be
that since SBS already installs a bunch of different applications on
the same server, you probably don't want to add the complexity of
multiple MSSQL instances.

Depending on what you want to achieve, you might want to look at MSDE,
which is a free version of MSSQL with some limitations:

http://www.microsoft.com/sql/msde/

Simon