Solved

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

Posted on 2006-06-14
7
6,217 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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

726 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