Wednesday, March 28, 2012

Installtion failed

Hi,
I failed to install SQL Server 2005 to my Win2003 server which has AVG antivirus/firewall installed. It still not work even I disable the firewall. Please advice

Here is the error log

2006-11-17 13:45:12.25 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2006-11-17 13:45:12.25 Server (c) 2005 Microsoft Corporation.
2006-11-17 13:45:12.25 Server All rights reserved.
2006-11-17 13:45:12.25 Server Server process ID is 3300.
2006-11-17 13:45:12.25 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2006-11-17 13:45:12.26 Server This instance of SQL Server last reported using a process ID of 2768 at 11/17/2006 1:45:00 PM (local) 11/17/2006 9:45:00 PM (UTC). This is an informational message only; no user action is required.
2006-11-17 13:45:12.26 Server Registry startup parameters:
2006-11-17 13:45:12.26 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2006-11-17 13:45:12.26 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2006-11-17 13:45:12.26 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2006-11-17 13:45:12.28 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-11-17 13:45:12.28 Server Detected 2 CPUs. This is an informational message; no user action is required.
2006-11-17 13:45:12.43 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-11-17 13:45:12.45 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-11-17 13:45:13.48 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-11-17 13:45:13.48 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-11-17 13:45:13.48 spid5s Starting up database 'master'.
2006-11-17 13:45:13.51 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2006-11-17 13:45:13.59 spid5s SQL Trace ID 1 was started by login "sa".
2006-11-17 13:45:13.60 spid5s Starting up database 'mssqlsystemresource'.
2006-11-17 13:45:13.78 spid5s Server name is 'VSMRND'. This is an informational message only. No user action is required.
2006-11-17 13:45:13.78 spid9s Starting up database 'model'.
2006-11-17 13:45:13.85 Server The certificate was successfully loaded for encryption.
2006-11-17 13:45:13.85 spid9s Clearing tempdb database.
2006-11-17 13:45:13.85 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2006-11-17 13:45:13.85 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2006-11-17 13:45:13.87 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2006-11-17 13:45:13.87 Server Dedicated admin connection support was established for listening locally on port 1434.
2006-11-17 13:45:13.87 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2006-11-17 13:45:13.90 spid5s Starting up database 'msdb'.
2006-11-17 13:45:14.09 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2006-11-17 13:45:14.25 spid9s Starting up database 'tempdb'.
2006-11-17 13:45:14.31 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-11-17 13:45:14.32 spid12s The Service Broker protocol transport is disabled or not configured.
2006-11-17 13:45:14.32 spid12s The Database Mirroring protocol transport is disabled or not configured.
2006-11-17 13:45:14.39 spid12s Service Broker manager has started.
2006-11-17 13:57:11.79 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2006-11-17 13:57:12.34 Server The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required.
2006-11-17 13:57:12.34 Server Error: 17054, Severity: 16, State: 1.
2006-11-17 13:57:12.34 Server The current event was not reported to the Windows Events log. Operating system error = 31(A device attached to the system is not functioning.). You may need to clear the Windows Events log if it is full.
2006-11-17 13:57:12.49 spid12s Service Broker manager has shut down.
2006-11-17 13:57:13.15 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

Moved thread to SQL Server Setup & Upgrade. This is a better forum for your post.

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||Hi,
To whom may concern, I found the mistake.
The error happens is because I extracted SQL Server 2005 CD 1 and CD2 into two different folder (as I can't extract them into same folder, this will overwritten each other). When I run setup from CD1 folder, I tick SQL Server database engine and workstation component. As Workstation component is in CD2 cause setup unable to locate it.

Install workstation component only using setup.exe under CD2 folder will solve the problem.

HTH

No comments:

Post a Comment