Solved

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

Posted on 2006-06-14
7
6,082 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

Title # Comments Views Activity
SQl Query to find x consecutive Nbrs in a Table 30 97
SQL Insert to Begin if data exists 2 31
SSMS Opening Mode 9 18
MS SQL query to show nearest date 6 32
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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 insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

839 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