Re: SQL2005 Failed when installing SP2

Somehow the name of the Virtual Server already existed on the network. It may be that the system tried to start SQL on both nodes at the same time. Perhaps the instances were on different nodes and the installer became confused. I would move both instances to the same node and attempt to complete the SP install.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




"Arthur" <Arthur@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:42E35D3C-18F6-4116-8E35-6F23DD6EE261@xxxxxxxxxxxxxxxx
When I was installing SP2 in a server with Win2003 server then Database
Service failed with those messages bellow:

Product : Database Services (SQLA)
Product Version (Previous): 2047
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 : 29534
Error Description : MSP Error: 29534 Service 'MSSQL$SQLA' could not
be started. Verify that you have sufficient privileges to start system
services. The error code is (52) You were not connected because a duplicate
name exists on the network. Go to System in Control Panel to change the
computer name and try again.

----------------------------------------------------------------------------------
Product : Database Services (SQLB)
Product Version (Previous): 2047
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 : 29534
Error Description : MSP Error: 29534 Service 'MSSQL$SQLB' could not
be started. Verify that you have sufficient privileges to start system
services. The error code is (52) You were not connected because a duplicate
name exists on the network. Go to System in Control Panel to change the
computer name and try again.

So when I tried to start those services I got this errors in Error Log,
described bellow:

2007-06-08 20:17:56.15 spid5s Starting up database 'master'.
2007-06-08 20:17:56.26 spid5s CHECKDB for database 'master' finished
without errors on 2007-06-07 00:00:50.237 (local time). This is an
informational message only; no user action is required.
2007-06-08 20:17:56.26 spid5s SQL Trace ID 1 was started by login "sa".
2007-06-08 20:17:56.29 spid5s Starting up database 'mssqlsystemresource'.
2007-06-08 20:17:56.32 spid5s The resource database build version is
9.00.3042. This is an informational message only. No user action is required.
2007-06-08 20:17:56.51 Server Error: 17182, Severity: 16, State: 1.
2007-06-08 20:17:56.51 Server TDSSNIClient initialization failed with
error 0x34, status code 0x1e.
2007-06-08 20:17:56.51 Server Error: 17182, Severity: 16, State: 1.
2007-06-08 20:17:56.51 Server TDSSNIClient initialization failed with
error 0x34, status code 0x1.
2007-06-08 20:17:56.51 Server Error: 17826, Severity: 18, State: 3.
2007-06-08 20:17:56.51 Server Could not start the network library
because of an internal error in the network library. To determine the cause,
review the errors immediately preceding this one in the error log.
2007-06-08 20:17:56.51 Server Error: 17120, Severity: 16, State: 1.
2007-06-08 20:17:56.51 Server SQL Server could not spawn FRunCM thread.
Check the SQL Server error log and the Windows event logs for information
about possible related problems.

Well, after that I went to Conf. Manag. Tool and looked for Net libary
changes, I did one change in "Liscening All" in TCP/IP protocol properties
from NO to YES then I could starting Databases Services, but now database
version is 9.00.3042.00, I mean It's being in the middle SP2 install.

Someone knows what I have to do now? Go ahead and installing SP2 or
reinstall SQL 2005 and after installing SP2?

Thank You

.

Relevant Pages

  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... What's the error message you see when installing SQL? ... the easier way is to restore the server from recent backup. ... Screen shot of the error when you install SQL 2005 Workgroup edition. ... <The server-based applications that were running fine are: McAFee EPO, ...
    (microsoft.public.windows.server.sbs)
  • RE: SQL Server 2000 SP4 - Intermittent timeout/connection issues
    ... With a network problem nothing is ever simple dealing with sql. ... Could you put an LMHosts file on the web servers to the sql server ...
    (microsoft.public.sqlserver.server)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)