Solved

SQL 6.5 Upgrade

Posted on 1998-08-15
5
156 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
Comment Utility
I know this is hard, I remember you have to edit the registry.
0
 

Author Comment

by:thondi
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
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
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

728 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now