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.
>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.
>
>.
>|||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...
> 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,
I tried it but it is grey. I can't select it.
>--Original Message--
>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...
>> 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
>> >.
>> >
>
>.
>|||How about in your SQL Server 2000 group? Or the "SQL Server 2000 - Switch" group?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Charles Lee" <leech@.dnb.com> wrote in message news:2279f01c45d7e$b92c57d0$a301280a@.phx.gbl...
> Hi,
> I tried it but it is grey. I can't select it.
> >--Original Message--
> >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...
> >> 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 Tiber/Charles Lee,
It seems your SQL 6.5 is not installed properly, Might be a registrry issue.
In this case only solution is
remove manually. But this may not make your SQl 2000 server as default. So
solution to
make your SQL 2000 up is:- Since your SQl 2000 service is down you can
detach aswell.
1. Remove SQL 6.5 manually and tr restarting SQL 2000. If it fails then:-
2. Copy the MDF and LDF (including system databases) to a safe location.
3. Remove SQL 2000 (Use control panel add remove programs)
4. Install SQl 2000 in the same folder structure as old
5. Install the service pack saem as old
6. Stop sql server
7. COpy the MDF and LDF (taken in step -2) to the same folders
8. Start SQl server service.
Link to manually remove sql 6.5
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/q198/6/80.asp&NoWebContent=1
Thanks
Hari
MCDBA
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:#of30aaXEHA.2364@.TK2MSFTNGP12.phx.gbl...
> How about in your SQL Server 2000 group? Or the "SQL Server 2000 - Switch"
group?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Charles Lee" <leech@.dnb.com> wrote in message
news:2279f01c45d7e$b92c57d0$a301280a@.phx.gbl...
> > Hi,
> >
> > I tried it but it is grey. I can't select it.
> >
> > >--Original Message--
> > >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...
> > >> 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
> > >> >.
> > >> >
> > >
> > >
> > >.
> > >
>