Solved

SQL 6.5 Upgrade

Posted on 1998-08-15
5
158 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
  • 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 70 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
DTS Connection Failed 7 70
sql 2014,  lock limit 5 32
Simple SQL query from two tables 13 54
SQL invalid column name 5 13
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

803 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