Solved

Installing sqlserver 2000 fails server error logs C:WINDOWS\sqlstp.log

Posted on 2006-06-14
7
6,136 Views
Last Modified: 2008-01-09
Installing sqlserver 2000 fails on windows xp with the following error "fails server error logs C:WINDOWS\sqlstp.log"  Below is the last part on the sqlstp.log  I have no idea whatthe problem is as I am new to sqlserver. Thanks in advance.


MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 67090 -U sa -P
###############################################################################


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=plinnane-us;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).

driver={sql server};server=plinnane-us;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).

driver={sql server};server=plinnane-us;UID=sa;PWD=;database=master

[Microsoft][ODBC SQL Server Driver][Shared Memory]General network error. Check your network documentation.

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (WrapperRead()).

SQL Server configuration failed.

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

15:58:35 Process Exit Code: (-1)
0
Comment
Question by:dplinnane
[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
  • 3
  • 2
7 Comments
 
LVL 21

Expert Comment

by:Yurich
ID: 16907832
it looks like you have network connection problem - do you have enought privileges to run installation? are you trying to specify a remote server during installation?

Regs,
Yurich
0
 

Author Comment

by:dplinnane
ID: 16922370
I found the answer please refund pints.

http://support.microsoft.com/kb/285100/en-us

FIX: Installation fails when Windows computer name is mixed or lowercase
View products that this article applies to.
Article ID : 285100
Last Review : October 7, 2005
Revision : 5.3
This article was previously published under Q285100
BUG #: 351711(SQL2000)
SYMPTOMS
Connection attempts over the shared memory network library fail on a server where GetComputerName returns a lower or mixed case server name.

When the shared memory connection attempt fails the SQL Server 2000 network library attempts to connect over an alternate protocol.

When you install any edition of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) on a computer whose name is all lowercase or mixed case, Setup may fail, and you receive one of the following messages:

For MSDE 2000:
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
For SQL Server 2000:
Setup failed to configure the server. Refer to the server error logs and sqlstp.log for more information.
 Back to the top

CAUSE
GetComputerName is used to obtain the local computer name. The client network library component (DBMSLPCn.dll) converts the name to all upper case. The server network library component (SSMSLPCn.dll) leaves the name as returned.
 Back to the top
etc
0
 

Author Comment

by:dplinnane
ID: 17424405
Found the bug FIX: Installation fails when Windows computer name is mixed or lowercase.
http://support.microsoft.com/kb/285100/en-us
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:dplinnane
ID: 17424412
Suggest point be refunded as I solved the question myself, maybe give 100 for effort.
0
 
LVL 21

Expert Comment

by:Yurich
ID: 17427427
no, thank you. you solved it yourself and that's fine - you can post a request in the community area to close the question (PAQ) and refund the points.
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 17631591
PAQed with points refunded (500)

CetusMOD
Community Support Moderator
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

733 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