Solved

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

Posted on 2006-06-14
7
5,956 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
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.

930 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now