Uninstall second instance

[DMina]

Hello there!
I have on a machine (named SV-ISDEV) two MSSQL instances installed. The
local and the SV-ISDEV\PREPROD. Now I want to unistall the PREPROD
instance.
Which is the correct way to do this?
Do I have to run the installation again?

Thanks

[Simon Hayes]

See question 28:

http://support.microsoft.com/default...b;en-us;257716

Simon

[DMina]

Thanks a lot for your help.
I was trying to uninstall the instance using the "Add/Remove Programs"
option from the Control Panel but the procedure cancels due to the
following reason:

the isql.exe is running.

I tried to kill this process but I cannot. I tried to restart the
server but when it boots its started.

Any ideas about what is this and how can overcome it?

Regards
Simon Hayes wrote:

See question 28:

http://support.microsoft.com/default...b;en-us;257716

Simon

[Erland Sommarskog]

(DM***@laiki.com) writes:

Thanks a lot for your help.
I was trying to uninstall the instance using the "Add/Remove Programs"
option from the Control Panel but the procedure cancels due to the
following reason:

the isql.exe is running.

I tried to kill this process but I cannot. I tried to restart the
server but when it boots its started.
ISQL is a command-line program for sending queries interactively to
SQL Server. Have you checked that you don't have any command-line
windows open?

If this is run by some automatic process, check SQL Server Agent
for jobs, the Startup folder and the various Run keys in the
registry for Software\Microsoft\Windows\CurrentVersion.
Any ideas about what is this and how can overcome it?

Also, the link that Simon gave, included a second link,
http://support.microsoft.com/kb/290991. That appears to be a last
resort.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp