Concurrent MSDE SQL and SQL 2000/2005

We have two servers that need to be upgraded. One has an app that uses the
MSDE version of SQL. The second uses SQL 2000. Neither has very many users
.
Could we purchase a single new server, and run both versions of SQL on it
concurrently? Would it make a difference if the SQL 2000 is eventually
upgraded to SQL 2005, while the MSDE version stays at 2000 instead of going
to SQL Express?
Thanks!
EmilyYou could run both versions on one server, but it would require having
a named instance, which adds a little bit more hassle. One would be
the default instance and you would connect to it as per normal but the
for the named instance you would have to connect to it as
ComputerName\InstanceName. My recommendation would be to just install
SQL 2000/2005 on your new server and host all databases on the one
instance. Is their any particular reason you want them on seperate
instances?|||Thank you for your response, Paul. My hesitation in using two instances is
simply that I am new to SQL, and new to these applications, and there isn't
anyone here who knows much about them. Having never had SQL training, I am
a
little reluctant to change any of the default settings. However, the
financial people don't want to buy two servers. The vendors are not very
helpful.
"Paul T." wrote:

>
> You could run both versions on one server, but it would require having
> a named instance, which adds a little bit more hassle. One would be
> the default instance and you would connect to it as per normal but the
> for the named instance you would have to connect to it as
> ComputerName\InstanceName. My recommendation would be to just install
> SQL 2000/2005 on your new server and host all databases on the one
> instance. Is their any particular reason you want them on seperate
> instances?
>|||If you are reluctant to change default settings, and you have not had
much SQL training your best bet is to continue using the two servers
and upgrade either as needed. If you wanted them on the same server
you would have to change the default settings of at least one instance
as it would need an instance name. If you moved the msde databases
onto the SQL 2000 server, you would need to at least know how to attach
and detach the databases and ensure that all the logins still have the
proper access. If there is no business reason that these applications
are running on seperate servers then I would look into learning enough
about SQL Server to put the databases on the SQL Server 2000 box
together.|||You could run both versions on one server, but it would require having
a named instance, which adds a little bit more hassle. One would be
the default instance and you would connect to it as per normal but the
for the named instance you would have to connect to it as
ComputerName\InstanceName. My recommendation would be to just install
SQL 2000/2005 on your new server and host all databases on the one
instance. Is their any particular reason you want them on seperate
instances?|||Thank you for your response, Paul. My hesitation in using two instances is
simply that I am new to SQL, and new to these applications, and there isn't
anyone here who knows much about them. Having never had SQL training, I am
a
little reluctant to change any of the default settings. However, the
financial people don't want to buy two servers. The vendors are not very
helpful.
"Paul T." wrote:

>
> You could run both versions on one server, but it would require having
> a named instance, which adds a little bit more hassle. One would be
> the default instance and you would connect to it as per normal but the
> for the named instance you would have to connect to it as
> ComputerName\InstanceName. My recommendation would be to just install
> SQL 2000/2005 on your new server and host all databases on the one
> instance. Is their any particular reason you want them on seperate
> instances?
>|||If you are reluctant to change default settings, and you have not had
much SQL training your best bet is to continue using the two servers
and upgrade either as needed. If you wanted them on the same server
you would have to change the default settings of at least one instance
as it would need an instance name. If you moved the msde databases
onto the SQL 2000 server, you would need to at least know how to attach
and detach the databases and ensure that all the logins still have the
proper access. If there is no business reason that these applications
are running on seperate servers then I would look into learning enough
about SQL Server to put the databases on the SQL Server 2000 box
together.