Solved

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

Posted on 2006-06-14
7
6,020 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

786 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