Solved

Installation probmes with SQL Server 2000 Personal

Posted on 2001-09-10
2
635 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
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

828 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