isqlw won't start

[Andre Ma]

Hi there,

I tried to install MS SQL Server 2000 on my desktop computer after
uninstalling a version 7 instance. Everything worked fine. Using
Enterprise Manager I can manage databases and the database enginge itself.

My problem is now, that ISQLW.exe, i.e Query Analayzer won't start. The
taskmanager shows a process isqlw.exe but nothing happens. MSSQL Log
files give no hints, neither does the Windows 2000 event log.

I assume a problem with the previously installed MSSQL7 version, but
walked through the registry as well.

Are there any hints why isqlw doesn't want to speak to me?

Thanks,
Andre

[Andre Ma]

Andre Ma@ss schrieb:

Are there any hints why isqlw doesn't want to speak to me?

Meanwhile I have solved the problem. I have installed SP3 and have
repaired the registry entries. After that Query Analyzer worked fine.

Thanks,
Andre

[Erland Sommarskog]

Andre Ma@ss (Sa*******@gmx.de) writes:

I tried to install MS SQL Server 2000 on my desktop computer after
uninstalling a version 7 instance. Everything worked fine. Using
Enterprise Manager I can manage databases and the database enginge itself.

My problem is now, that ISQLW.exe, i.e Query Analayzer won't start. The
taskmanager shows a process isqlw.exe but nothing happens. MSSQL Log
files give no hints, neither does the Windows 2000 event log.

I assume a problem with the previously installed MSSQL7 version, but
walked through the registry as well.

Are there any hints why isqlw doesn't want to speak to me?

Tried rebooting? More importantly, have you installed any service pack
for SQL 2000? You should install at least SP3, but there is an SP4 as
well. There is a serious security threat in SQL 2000 RTM which is fixed
in SP3. (The Slammer worm.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx