Solved

Installation probmes with SQL Server 2000 Personal

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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Tempdb Contention - SQL SERVER 10 38
Display Date and Time 7 48
In T-SQL cursor convert smallint to varchar 15 50
Adding columns to a table which has non null columns 3 40
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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 combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

739 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