Solved

Installation probmes with SQL Server 2000 Personal

Posted on 2001-09-10
2
630 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
2 Comments
 
LVL 9

Accepted Solution

by:
miron earned 100 total points
Comment Utility
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
Comment Utility
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

772 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