?
Solved

SQL 6.5 Upgrade

Posted on 1998-08-15
5
Medium Priority
?
163 Views
Last Modified: 2010-03-19
We have a Sql Server 6.5 and we removed it using the Remove Server from setup.exe... Later while trying to do a fresh installation, the Install new server radio button is disabled... Any inputs on how to go about reinstalling the server....

Thanks in advance
0
Comment
Question by:thondi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 28

Expert Comment

by:sybe
ID: 1089560
I know this is hard, I remember you have to edit the registry.
0
 

Author Comment

by:thondi
ID: 1089561
I already tried that but could not get it work... I could fool the installation program by placing a dummy master.dat and also recreating the directory structure.... That is as far as I got.
0
 
LVL 2

Expert Comment

by:jbiswas
ID: 1089562
Yeah the add/remove sometimes does not clear out all registry entries. This is what you do.
Go to the registry and search for SQL. Remove all entries related to SQL server. Go to the winnt/profiles directory and remove all Microsoft SQL server entries under administrator or your name, whoever installed the server. Now go to the control panel/ services and see that MS SQL Server services are disabled. Now reboot the NT box and come back and see that all entries in the control panel/ services are gone. Now reinstall the server. This should work.
0
 

Author Comment

by:thondi
ID: 1089563
Hi Jbiswas...
There is a problem in deleting the service name from the registry. I had this pblm right from the begining... LEGACY_xxx is the key i can't delete....

Any inputs...

As I needed to get the SQL server running ASAP I reformated NT and reinstalled it along with SQL....


0
 
LVL 2

Accepted Solution

by:
jbiswas earned 140 total points
ID: 1089564
Yes except the legacy_xxx entries delete all others. The legacy entries cannot be deleted. That however does not affect the installation process at all. The key is that after the cleaning operation you must and I repeat you 'must' reboot the NT box for the complete removal of all entries.
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question