2005 SP2 Database Services failure

I applied SP2 to my XP box and am getting a Failure on the Database Services
component. Everything else went fine. I have protocols Shared Memory, Named
Pipes (turned off trying to resolve failure) and TCP/IP enabled. VIA is
disabled. The only 2 services prior to SP2 install running are the Main
Server process & Sql Browser - both are set to localsystem account.
I have included the error from "View Summary."
It talks about a connection getting closed.
Any help would be apprecieated.
Thanks, Glen
Error Description :
----
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has
encountered the following problem: [Microsoft][SQL Native Client]TCP
Provider: An existing connection was forcibly closed by the remote host.
. To continue, correct the problem, and then run SQL Server Setup again.Hi Glen
I am not sure why the connection was forced to close, if you are running AV
software you may want to suspend it during the installation, but then I
would expect you to be having problems with this during your normal use if
that was the case!!
John
"Glen M" <Glen@.newsgroup.nospam> wrote in message
news:6A9F5F90-6C7B-4C34-BB54-F917BCB41F64@.microsoft.com...
>I applied SP2 to my XP box and am getting a Failure on the Database
>Services
> component. Everything else went fine. I have protocols Shared Memory,
> Named
> Pipes (turned off trying to resolve failure) and TCP/IP enabled. VIA is
> disabled. The only 2 services prior to SP2 install running are the Main
> Server process & Sql Browser - both are set to localsystem account.
> I have included the error from "View Summary."
> It talks about a connection getting closed.
> Any help would be apprecieated.
> Thanks, Glen
> Error Description :
> ----
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 3042
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
> Error Number : 29537
> Error Description : MSP Error: 29537 SQL Server Setup has
> encountered the following problem: [Microsoft][SQL Native Client]TCP
> Provider: An existing connection was forcibly closed by the remote host.
> . To continue, correct the problem, and then run SQL Server Setup again.
>|||Hi,
I understand that your SQL Server 2005 SP2 setup program failed due to the
TCP provider error.
If I have misunderstood, please let me know.
For further research, I would like to collect the following information
from you:
1. Your SQL Server 2005 SP2 setup log files which are located in
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix;
2. Your SQL error logs which are located in %ProgramFiles%\Microsoft SQL
Server\MSSQL(.x)\MSSQL\LOG.
Please first mail me (changliw_at_microsoft_dot_com) an email response and
then I will create a public workspace for your uploading your files.
Also I would like to ask you two questions:
1. Could your SQL Server database service be started with TCP protocol now?
You can first check which TCP ports are configured for your SQL Server from
SQL Server Configuration Manager. After that, run "netstat -nba
>C:\Tcpport.log" from command line to check which TCP port your SQL Server
is listening.
2. Can you connect to your SQL Server instance at your client via
sqlcmd.exe?
For example: sqlcmd -Stcp:<servername>\<instancename> -E
3. What is the edition of your SQL Server 2005?
Look forward to your response.
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Glen,
I have not received your response. Could you please let me know the issue
status? If you have any questions or concerns, please feel free to let me
know.
Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================