2nd Instance of SQL Server 7

How do I install a 'second instance' of MS SQL Server 7
along side my existing production database. I'm told it
is need to publish a second alias (seperate database)
from the same server.
Thanks,
Johnsql7 does not support named instances. hence, you only have 1 default
instance per server.
--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
"John" <anonymous@.discussions.microsoft.com> wrote in message
news:03cc01c3ae2e$95ab0e50$a101280a@.phx.gbl...
> How do I install a 'second instance' of MS SQL Server 7
> along side my existing production database. I'm told it
> is need to publish a second alias (seperate database)
> from the same server.
> Thanks,
> John|||Is it at all possible to have 2 databases on a single sql
7 server system?
Thanks,
John
>--Original Message--
>sql7 does not support named instances. hence, you only
have 1 default
>instance per server.
>--
>-oj
>RAC v2.2 & QALite!
>http://www.rac4sql.net
>
>"John" <anonymous@.discussions.microsoft.com> wrote in
message
>news:03cc01c3ae2e$95ab0e50$a101280a@.phx.gbl...
>> How do I install a 'second instance' of MS SQL Server 7
>> along side my existing production database. I'm told it
>> is need to publish a second alias (seperate database)
>> from the same server.
>> Thanks,
>> John
>
>.
>|||John,
Yes. You can have upto 32767 databases per instance of sql7/2k.
--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net
<anonymous@.discussions.microsoft.com> wrote in message
news:0e9d01c3ae34$31a2a160$a601280a@.phx.gbl...
> Is it at all possible to have 2 databases on a single sql
> 7 server system?
> Thanks,
> John
> >--Original Message--
> >sql7 does not support named instances. hence, you only
> have 1 default
> >instance per server.
> >
> >--
> >-oj
> >RAC v2.2 & QALite!
> >http://www.rac4sql.net
> >
> >
> >"John" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:03cc01c3ae2e$95ab0e50$a101280a@.phx.gbl...
> >> How do I install a 'second instance' of MS SQL Server 7
> >> along side my existing production database. I'm told it
> >> is need to publish a second alias (seperate database)
> >> from the same server.
> >>
> >> Thanks,
> >> John
> >
> >
> >.
> >|||yes, you can have maximum of 32,767 database per SQL Server 7 instance.
--
- Vishal|||I've inherited an app system that requires 1 database per
sql server installation. a huge waste in my thinking...
but I need to get the equivilent of multiple sql
instances (as in sql2k) with sql 7. any ideas?
Thanks,
John
>--Original Message--
>How do I install a 'second instance' of MS SQL Server 7
>along side my existing production database. I'm told it
>is need to publish a second alias (seperate database)
>from the same server.
>Thanks,
>John
>.
>|||I assume your application has a hard-coded database name. In this case,
your only supported option is to upgrade to SQL Server 2000 so that you
can have multiple instances.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
<anonymous@.discussions.microsoft.com> wrote in message
news:04bb01c3ae3d$4de18810$a501280a@.phx.gbl...
> I've inherited an app system that requires 1 database per
> sql server installation. a huge waste in my thinking...
> but I need to get the equivilent of multiple sql
> instances (as in sql2k) with sql 7. any ideas?
> Thanks,
> John
> >--Original Message--
> >How do I install a 'second instance' of MS SQL Server 7
> >along side my existing production database. I'm told it
> >is need to publish a second alias (seperate database)
> >from the same server.
> >
> >Thanks,
> >John
> >.
> >