Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Installation probmes with SQL Server 2000 Personal

Posted on 2001-09-10
2
Medium Priority
?
648 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 300 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

721 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