?
Solved

installation fails

Posted on 2002-04-23
13
Medium Priority
?
441 Views
Last Modified: 2012-05-04
This is the scenario,

1-I had Sql sever 2000 on windows 2000 server installed and running.

2-Server got messed up

3-Hard drive got reformated and I restored the full system from tape using microsoft backup(We had the last backup)

4-Everything wroked fine expect Sql server, it could not rerstore the sql server. Some files were missing in dynamic libraray.

5-I went to add/remove program and remove the sql server 2000. It was success full

6-Trying to reinstall the Sql server. it fails every time. It gives the message at the and that "Setup failed to configure the server.   Refer to the server error logs and C:\WINNT\sqlstp.log for more information."

This is the end of sqlstp.log file.

09:40:03 SetFileSecuritySQLAndAdmin for e:\Program Files\Microsoft SQL Server\MSSQL returned: 0, 0
09:40:03 SetFileSecuritySQLAndAdmin for C:\Program Files\Microsoft SQL Server\MSSQL returned: 0, 0
09:40:03 SetRegSecuritySQLAndAdmin for Software\Microsoft\MSSQLServer\MSSQLServer returned: 0, 0
09:40:03 Begin Action: UpdateSystemPath
09:40:03 Path successfully updated.
09:40:03 %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Common Files\Network Associates\VirusScan Engine\4.0.xx\;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
09:40:03 End Action: UpdateSystemPath
09:40:03 Grant Right for TROUT\Administrator returned : 1, 0
09:40:04 Grant Right for TROUT\Administrator returned : 1, 0
09:40:04 Grant Right for TROUT\Administrator returned : 1, 0
09:40:04 Grant Right for TROUT\Administrator returned : 1, 0
09:40:05 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 65822 -U sa -P
###############################################################################


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=TROUT;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).

driver={sql server};server=TROUT;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).

driver={sql server};server=TROUT;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Named Pipes]Connection broken.

[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead (GetOverLappedResult()).

SQL Server configuration failed.

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

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

09:40:47 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe  -Silent 1 -Action 4 -Service MSSQLSERVER
09:40:47 Process Exit Code: (0)
09:40:47 StatsGenerate returned: 2
09:40:47 StatsGenerate (0x0,0x1,0xf00,0x200,1033,303,0x0,0x1,0,0,0
09:40:47 StatsGenerate -1,Administrator)
09:40:47 Installation Failed.


Help?

Thanks.
0
Comment
Question by:prokni
  • 6
  • 3
  • 2
  • +2
13 Comments
 
LVL 1

Expert Comment

by:jboyd
ID: 6963461
The cnfgsvr.exe needs to connect using a network protocol that can run in local shared memory. If, from your previous installation, you setup an alias in the client network utility program that specifies a protocol that can not run in local shared memory, cnfgsvr will attempt to use it anyway, and fail. Delete you alias in the client network utility, and you should be able to complete the install.
0
 
LVL 2

Author Comment

by:prokni
ID: 6963475
I will try your solution.
As long as I remember I could not run client network utility and it would gave me the error. ddl not found in dynamic libraray ....
Please do not lock the question. I will look at it by noon and get back to you. If it works I'll accpet  it. but leave it opne for other suggestion. I am pretty sure that I can not run client network utility any more. as I said. i rmeove dthe whole sql server that is why there is no client network utility any more. Just in case I will look at it again.

Thanks
0
 
LVL 1

Expert Comment

by:jboyd
ID: 6963968
User regedit and go to:

HKEY_LOCAL_MACHINE-->SOFTWARE-->Microsoft-->MSSQLServer-->Client-->ConnectTo

and remove the line with the alias for your server.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

by:prokni
ID: 6964052
jboyd
first solution did not work.
I'll try the second one tonight.
0
 
LVL 2

Author Comment

by:prokni
ID: 6964650
there is no such a key in reg
I can see Microsft Sql Server--> 8.00.000 and 80
under 80 I can see tools,registration and licenseinfo
there is no client
Any idea?
thanks for your help
0
 
LVL 35

Expert Comment

by:David Todd
ID: 6964695
Hi,

Have you tried a regclean or similar utiltiy?

Do you have a spare server? Suggest that you try restoring the system and reinstall SQL ...

What else was on the server? If it was just SQL, possibly the quickest resolution is to format, reinstall windows, reinstall SQL, restore the datbase files from tape. You may have the actual files, or copies of the databse backups. In one case you reattach the database files and then sort out the users, inthe other you restore from the files restored from tape ...

Regards
  David
0
 
LVL 2

Author Comment

by:prokni
ID: 6966261
I have not used regclean. Please advice.

About reinstalling windows, that is what I am trying  not to do. I have the last full backup of system files and my hard drives on tape. Actually this is what happend, My system got messed up and I tried to restore it from tape. As you know full restore does not work properly most of the time. this is a web server that has Sql server on it too. (Nothing else.)
everything got restored properly except sql server. It gave me some dll not found and stuff like that when I restart the system.
I have a backup form my database separately.
I am trying to restore the sql on this system and restore my database on it.
I know something is not cleaned up in reg but I can not find it.
Any more idea?
0
 
LVL 1

Expert Comment

by:jboyd
ID: 6966427
You did not go to the correct key. There should be one named "MSSQLServer" in addition to the "Microsft Sql Server" one.
0
 
LVL 2

Author Comment

by:prokni
ID: 6966452
I removed that one later.
I found a document in Mcrosoft primior web site about how to uninstall sql server manually. It was saying ot delete both keys and I did.
0
 
LVL 35

Expert Comment

by:David Todd
ID: 6969880
Hi,

Regclean is I believe available from Microsoft.

It removes old entries from the registry.

Regards
  David
0
 
LVL 4

Expert Comment

by:TheSpirit
ID: 6973153
It looks like the configure server part of the setup requires SQL to be running, I would try running setup with the k=dbg setting, and when the message asking if you want ton configure the server appears go to control panel and ensure that the service is started before pressing YES
0
 
LVL 2

Author Comment

by:prokni
ID: 6980702
How can I run the setup with the k=dbg ?
The service can not start in that time.
0
 

Accepted Solution

by:
ComTech earned 0 total points
ID: 7060492
In a note in Community support, this user claims to have reformatted his PC and re-installed SLQ. Since no one here as responded to prokni's last comment, which meets the 21 day period for a question to be considered abandoned.  I shall place this quetion in PAQ.

Best regards,
ComTech
CS Admin @ EE
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

829 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