I have sql server 2000 installed on my laptop. I use this laptop for demos
in standalone disconnected mode. I need to install a relatively old piece
of software which was developed for sql 7.
My question is if I can safely install sql 7 server on the laptop without
conflict with the already installed sql 2000 server?
Sincerely,
Zvi WeissYou can install SQL 7 and SQL 2000 on the same machine, but only if SQL 7 is
the default instance and SQL 2000 is a named instance.
The easiest is probably to install the database for your piece of software
on SQL 2000 and set the database to 70 compatibility mode.
If that doesn't work, I guess that you have already installed SQL 2000 as
the default instance on your laptop, so you would have to change that to a
named instance. The most "straightforward" way would be to detach the
databases from SQL 2000, uninstall SQL 2000, install SQL 7, install SQL 2000
as a named instance and reattach the databases.
Jacco Schalkwijk
SQL Server MVP
"Zvi Weiss" <zvweiss@.optonline.net> wrote in message
news:%23nE9eH6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> I have sql server 2000 installed on my laptop. I use this laptop for
demos
> in standalone disconnected mode. I need to install a relatively old piece
> of software which was developed for sql 7.
> My question is if I can safely install sql 7 server on the laptop without
> conflict with the already installed sql 2000 server?
> Sincerely,
> Zvi Weiss
>|||Perfect. Worked like a charm.
"Jacco Schalkwijk" <NOSPAMjaccos@.eurostop.co.uk> wrote in message
news:eZ1V4n6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> You can install SQL 7 and SQL 2000 on the same machine, but only if SQL 7
is
> the default instance and SQL 2000 is a named instance.
> The easiest is probably to install the database for your piece of software
> on SQL 2000 and set the database to 70 compatibility mode.
> If that doesn't work, I guess that you have already installed SQL 2000 as
> the default instance on your laptop, so you would have to change that to a
> named instance. The most "straightforward" way would be to detach the
> databases from SQL 2000, uninstall SQL 2000, install SQL 7, install SQL
2000
> as a named instance and reattach the databases.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Zvi Weiss" <zvweiss@.optonline.net> wrote in message
> news:%23nE9eH6KEHA.628@.TK2MSFTNGP11.phx.gbl...
> demos
piece[vbcol=seagreen]
without[vbcol=seagreen]
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment