Solved

Installation probmes with SQL Server 2000 Personal

Posted on 2001-09-10
2
638 Views
Last Modified: 2011-10-03
Hi,

I have tried to install SQL Server 2000 Personal Edition now for 10 times and everything I tried results in the same error.

The error that shows first is (From the installation software):
"The procedure entry point ??_U@YAPAXI@Z could not be located in the dynamic link library MSVCRT.dll."

This happes after all files are installed.
The SQLSTP.LOG file ends with the following:
-------------
23:14:43 Begin Action: SkuIt
23:14:43 End Action: SkuIt
23:14:44 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL Server\MSSQL returned: 0, 0
23:14:44 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
23:14:44 Begin Action: UpdateSystemPath
23:14:44 Path successfully updated.
23:14:44 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\MSSQL7\BINN;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
23:14:44 End Action: UpdateSystemPath
23:14:45 Grant Right for JOHANNES\Johannes H returned : 1, 0
23:14:45 Grant Right for JOHANNES\Johannes H returned : 1, 0
23:14:46 Grant Right for JOHANNES\Johannes H returned : 1, 0
23:14:46 Grant Right for JOHANNES\Johannes H returned : 1, 0
23:14:47 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe  -F "C:\WINNT\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 589980 -U sa -P
###############################################################################


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

An error occurred while attempting to start the service (1053)

SQL Server configuration failed.

###############################################################################

23:15:18 Process Exit Code: (-1)
23:15:25 Setup failed to configure the server.   Refer to the server error logs and C:\WINNT\sqlstp.log for more information.
23:15:26 Action CleanUpInstall:
23:15:26 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service SQLSERVERAGENT
23:15:26 Process Exit Code: (1060) The specified service does not exist as an installed service.

23:15:26 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service MSSQLSERVER
23:15:26 Process Exit Code: (0)
23:15:26 StatsGenerate returned: 2
23:15:26 StatsGenerate (0x0,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0
23:15:26 StatsGenerate -1,Johannes H)
23:15:26 Installation Failed.
-----------

It does 4 "Grant rights"...
I thougt the rights problem was the problem so I turned on the login function.. And logged in as myself (Johannes H) that has administrations rights.
(Login name is "Johannes H" and computer name is "JOHANNES".)
But still I get the same error message.

The computer I'm setting this up on is a P-III 600Mhz running with Windows 2000 Professional (Latest SP installed (SP2?)).
I had SQL Server 7 desktop edtion installed prev. and tried to install SQL 2000 without uninstalling SQL7 first.
And I have tried to remove all SQL installations and tried to install SQL2000.. same problem...

Anyone got the solution for this?
I have tried to find the solution at MSDN but without any success.

Does this probles ring any bell with someone?
I hope so..

With hope for a solution,
~Johannes aka Gizmo
0
Comment
Question by:Gizmo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 9

Accepted Solution

by:
miron earned 100 total points
ID: 6472986
My guess is that you installed some development software, This software overwrites C run time libraries, regardless whether it is newer or older, or sets the OS to use a debug version of msvcrt.dll - "MSVCRTD.DLL" it can be quickly found by executing search for file msvcrtd.dll under C:\winnt\system32 directory. In my experience this is usually corrected by OS complete re - installation. It might sound drastic, but this is what needs to be done. The recovery path can be shortened, but it is not guaranteed to work. You can try to locate msvcrt.dll file on the CD distribution of Windows 2000 Personal edition in one of the cab files using WinZip and then replace the msvcrt.dll on your disk by copying the file somewhere else but C:\winnt\system32 , booting into Windows 2000 Recovery mode on start - up, chosing Safe Mode from the textual menu and overwriting present msvcrt.dll with previously stored file.
0
 

Author Comment

by:Gizmo
ID: 6475127
Yeah, that did work..

I don't know if there is going to be any more problems with other softwares... But that's the next thing to find out.. =)

I nog got SQL Server 2000 to install correclty and thats great.

Thanx,
That's was one of the later steps I was going to do myself.. And I thougt there might be another solution..
But you answerd me and it works..

So 100 fresh experts point is yours.  =)
And I loos 100.. =(

~JoGi
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

729 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