Cannot start SQL 2000

I installed a SQL6.5 to a server which is already have a
SQL 2000 running. However, both sql 6.5 and 2000 are
failed to start. Anyone have an idea?
Thanks.
What errors are you getting in the SQL Server error logs and the event
viewer?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Charles Lee" <leech@.dnb.com> wrote in message
news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
I installed a SQL6.5 to a server which is already have a
SQL 2000 running. However, both sql 6.5 and 2000 are
failed to start. Anyone have an idea?
Thanks.
|||Hi,
If you have an default instance of SQL 2000 installed already, then you can
not start the SQL 6.5 service and run in parellel.
To trobleshoot , Go to command prompt and go to the SQL 6.5 folder
(\MSSQL\BINN folder).
Now execute
SQLSERVR -m
THis will give you the correct error mesasge to troubleshoot.
Do the same for SQL 2000 as well.
Right way to do is :-
1. Install SQL 6.5
2. Install SQL 2000 Named instance.
So both the services can run in parellel.
Thanks
Hari
MCDBA
"Charles Lee" <leech@.dnb.com> wrote in message
news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
> I installed a SQL6.5 to a server which is already have a
> SQL 2000 running. However, both sql 6.5 and 2000 are
> failed to start. Anyone have an idea?
> Thanks.
|||Hi,
If you have an default instance of SQL 2000 installed already, then you can
not start the SQL 6.5 service and run in parellel.
To trobleshoot , Go to command prompt and go to the SQL 6.5 folder
(\MSSQL\BINN folder).
Now execute
SQLSERVR -m
THis will give you the correct error mesasge to troubleshoot.
Do the same for SQL 2000 as well.
Right way to do is :-
1. Install SQL 6.5
2. Install SQL 2000 Named instance.
So both the services can run in parellel.
Thanks
Hari
MCDBA
"Charles Lee" <leech@.dnb.com> wrote in message
news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
> I installed a SQL6.5 to a server which is already have a
> SQL 2000 running. However, both sql 6.5 and 2000 are
> failed to start. Anyone have an idea?
> Thanks.
|||The message is:
The system is older than SQL Ssrver 7.0 RTM version and
is not supported by this server.

>--Original Message--
>What errors are you getting in the SQL Server error logs
and the event
>viewer?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Charles Lee" <leech@.dnb.com> wrote in message
>news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
>I installed a SQL6.5 to a server which is already have a
>SQL 2000 running. However, both sql 6.5 and 2000 are
>failed to start. Anyone have an idea?
>Thanks.
>
>.
>
|||The message is:
The system is older than SQL Ssrver 7.0 RTM version and
is not supported by this server.
Now, I just want to get rid of 6.5 and keep 2000 since
there are database in 2000.
Thanks.

>--Original Message--
>Hi,
>If you have an default instance of SQL 2000 installed
already, then you can
>not start the SQL 6.5 service and run in parellel.
>To trobleshoot , Go to command prompt and go to the SQL
6.5 folder
>(\MSSQL\BINN folder).
>Now execute
>SQLSERVR -m
>THis will give you the correct error mesasge to
troubleshoot.[vbcol=seagreen]
>Do the same for SQL 2000 as well.
>Right way to do is :-
>1. Install SQL 6.5
>2. Install SQL 2000 Named instance.
>So both the services can run in parellel.
>Thanks
>Hari
>MCDBA
>
>
>
>"Charles Lee" <leech@.dnb.com> wrote in message
>news:21d3a01c45cfd$bcbd2450$a601280a@.phx.gbl...
a
>
>.
>
|||Charles
You can install diferent versions of SQL Server on the same server, however you need to install them in the right order. That is 6.5 first, then 7 and finally 2000. As you already had 2000 installed that is why you can not run 6.5. Also if you have mutipl
e versions of SQL Server you can only run one of them at a time. When you have mutiple versions you get the option to switch between them on your start menu.
You need to uninstall 6.5. If you really want it on the same server. After uninstall, take a backup of your 2000 master and detach all your user databases. Uninstall 2000. Install 6.5. Install 2000. Make sure 2000 is the active service and restore your ma
ster database (this is to synch user ID's and loggin's), attach your user databases and you should be up and running. You can then switch between 2000 and 6.5.
If you have some SQL jobs, you can either script them out before uninstalling 2000 or backup and recover the msdb database like the master.
Hope this helps
John
|||John,
Thanks for your detailed description. However, I tried
to uninstall 6.5 but it doesn't provide me an option to
do that. It only provide me a install option. Do you
have any idea?
Thanks.

>--Original Message--
>Charles
>You can install diferent versions of SQL Server on the
same server, however you need to install them in the
right order. That is 6.5 first, then 7 and finally 2000.
As you already had 2000 installed that is why you can not
run 6.5. Also if you have mutiple versions of SQL Server
you can only run one of them at a time. When you have
mutiple versions you get the option to switch between
them on your start menu.
>You need to uninstall 6.5. If you really want it on the
same server. After uninstall, take a backup of your 2000
master and detach all your user databases. Uninstall
2000. Install 6.5. Install 2000. Make sure 2000 is the
active service and restore your master database (this is
to synch user ID's and loggin's), attach your user
databases and you should be up and running. You can then
switch between 2000 and 6.5.
>If you have some SQL jobs, you can either script them
out before uninstalling 2000 or backup and recover the
msdb database like the master.
>Hope this helps
>John
>.
>
|||John,
Thanks for your detailed description. However, I tried
to uninstall 6.5 but it doesn't provide me an option to
do that. It only provide me a install option. Do you
have any idea?
Thanks.

>--Original Message--
>Charles
>You can install diferent versions of SQL Server on the
same server, however you need to install them in the
right order. That is 6.5 first, then 7 and finally 2000.
As you already had 2000 installed that is why you can not
run 6.5. Also if you have mutiple versions of SQL Server
you can only run one of them at a time. When you have
mutiple versions you get the option to switch between
them on your start menu.
>You need to uninstall 6.5. If you really want it on the
same server. After uninstall, take a backup of your 2000
master and detach all your user databases. Uninstall
2000. Install 6.5. Install 2000. Make sure 2000 is the
active service and restore your master database (this is
to synch user ID's and loggin's), attach your user
databases and you should be up and running. You can then
switch between 2000 and 6.5.
>If you have some SQL jobs, you can either script them
out before uninstalling 2000 or backup and recover the
msdb database like the master.
>Hope this helps
>John
>.
>
|||Hi,
Please select the SETUP program from SQL 6.5 program group and run the
setup. If you go 2 screens further you have "REMOVE SQL SERVER Option".
If you do not have setup program in SQL Server 6.5 program groups then
select the EXE from \MSSQL\BINN folder of SQL 6.5 installation folder.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:2277001c45d78$98986780$a301280a@.phx.gbl...[vbcol=seagreen]
> John,
> Thanks for your detailed description. However, I tried
> to uninstall 6.5 but it doesn't provide me an option to
> do that. It only provide me a install option. Do you
> have any idea?
> Thanks.
> same server, however you need to install them in the
> right order. That is 6.5 first, then 7 and finally 2000.
> As you already had 2000 installed that is why you can not
> run 6.5. Also if you have mutiple versions of SQL Server
> you can only run one of them at a time. When you have
> mutiple versions you get the option to switch between
> them on your start menu.
> same server. After uninstall, take a backup of your 2000
> master and detach all your user databases. Uninstall
> 2000. Install 6.5. Install 2000. Make sure 2000 is the
> active service and restore your master database (this is
> to synch user ID's and loggin's), attach your user
> databases and you should be up and running. You can then
> switch between 2000 and 6.5.
> out before uninstalling 2000 or backup and recover the
> msdb database like the master.