Windows Forum

Ask something
Discussion Locked

SQL Server setup, unexpected error

0 helpful
5 replies

by jlwk

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an question about SQL Server setup. I'm using win2000 server. After I have selected all options and entered the admin password and chose windows authentication mode during the installation, the setup program should start to install (copy andinstall file). However, the setup program closed and returned back to desktop unexpectedly. No error message has been pop up. sqlstp.log ended with '16:35:03 Begin Action: DlgCollation' with no error messages noted.

On the other hand, I have succeeded install it in other computers.

Can anyone tell me what to do?
Any feedback is much appreciated.

5 replies

by rstahler

I have had some problems in the past installing SQL Client side. Sometimes this works for me but it is kind of a pain. Try copying SQL CD to your hard drive then run the install from their. Hope that helps.

by jlwk

Thank you for your answer but it couldn't solve the problem. i'm sorry that i have to rate your answer unaccetable in order to leave the queston open.

in fact, i tried copying the whole disk to hard drive to perform the setup during the weekend. But it seemed that some path settings prevent the program from being installed from the hard drive. maybe that's because I was installing the standard edition of sql server 2000.

by maxwell edison

Review the Sqlstp.log file in the Windows directory. Review both the SQL error log in the MSSQL7\Log directory and the Cnfgsvr.out file in the MSSQL7\Install\ directory.
If your installation fails and you are unable to determine the cause, you should look for and save the sqlstp.log file in the Windows directory and the cnfgsvr.out file in the Mssql\Install\ directory, along with any other files that are left under your target program directory location (for example, C:\Mssql7). Of particularinterest is the cnfgsvr.out file and any error logs in the Mssql7\Log directory. If the Setup application fails, it will roll back changes to the file system, including removing any copied files, and also remove changes to the registry.

Also verify the system requirements:

A minimum of 183 megabytes (MB) free disk space (but as little as 30 MB for a compact installation).

An Intel-compatible or DEC Alpha processor; there is no Power PC or millions of instructions per second (MIPS) support.

A 133 MHz or better Pentium, Pentium Pro, or Pentium II processor.

A minimum of 32 MB RAM (but only 16 MB if you will not be doing any replication).

Microsoft Windows NT? Server 4.0 Service Pack 4, Windows NT Workstation 4.0 ServicePack 4, Windows? 95, or Windows 98.

Microsoft Internet Explorer 4.01 SP1.

Microsoft Systems Management Server, version 1.2 or later. SQL Server 7.0 is not compatible with Systems Management Server versions earlier than 1.2.

Maxwell

by jlwk

Thanks for the detailed answer, though the answer came too late that I couldn't test it. I simply got another server to have the sql server installed and run on it.

This discussion is closed to new replies.