Error Installing MSDE2000 Relase A

Hi there, This is the new installation of MSDE2000 Release A locally on the
Windows XP SP1 professional (Laptop). Never got it through the installation.
I have checked all the conditions in the Readme file, and they were met.
This is the log file:
2005-10-27 12:01:17.09 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2005-10-27 12:01:17.09 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-10-27 12:01:17.09 server All rights reserved.
2005-10-27 12:01:17.09 server Server Process ID is 2412.
2005-10-27 12:01:17.09 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2005-10-27 12:01:17.10 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2005-10-27 12:01:17.12 server SQL Server configured for thread mode
processing.
2005-10-27 12:01:17.12 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-10-27 12:01:17.12 spid3 Warning ******************
2005-10-27 12:01:17.12 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2005-10-27 12:01:17.13 spid3 Starting up database 'master'.
2005-10-27 12:01:17.35 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-10-27 12:01:17.35 spid5 Starting up database 'model'.
2005-10-27 12:01:17.37 server SQL server listening on 162.130.191.154:
1433.
2005-10-27 12:01:17.37 server SQL server listening on 127.0.0.1: 1433.
2005-10-27 12:01:17.37 spid3 Server name is 'HDQRKPC404445'.
2005-10-27 12:01:17.37 spid3 Skipping startup of clean database id 5
2005-10-27 12:01:17.37 spid3 Skipping startup of clean database id 6
2005-10-27 12:01:17.37 spid3 Starting up database 'msdb'.
2005-10-27 12:01:17.40 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2005-10-27 12:01:17.40 server SQL Server is ready for client connections
2005-10-27 12:01:17.50 spid5 Clearing tempdb database.
2005-10-27 12:01:18.12 spid5 Starting up database 'tempdb'.
2005-10-27 12:01:18.24 spid3 Recovery complete.
2005-10-27 12:01:18.24 spid3 SQL global counter collection task is
created.
2005-10-27 12:01:18.30 spid3 Warning: override, autoexec procedures
skipped.
2005-10-27 12:01:27.40 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
This is the cnfgsvr.out:
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=HDQRKPC404445;UID=sa;PWD=;database= master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=HDQRKPC404445;UID=sa;PWD=;database= master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=HDQRKPC404445;UID=sa;PWD=;database= master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
SQL Server configuration failed.
_____________
Please advice. Thanks
hi,
TomN wrote:
> Hi there, This is the new installation of MSDE2000 Release A locally
> on the Windows XP SP1 professional (Laptop). Never got it through
> the installation. I have checked all the conditions in the Readme
> file, and they were met. This is the log file:

> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> SQL Server configuration failed.
try fixing (or reinstalling) your MDAC stack...
http://msdn.microsoft.com/data/mdac/default.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Error in SSIS package after upgrade to SP2 release

I upgraded to SQL Server 2005 SP2 release today. I had been working with 9.00.1399. I had developed few packages in the older version which were getting invoked through the asp web application locally and it was working fine.

Today I upgraded to SQL server 2005 3042 version.
Now the same packages are not working when invoked through the web application. But it works fine stand alone. All errors refer to connection problem.

I need to resolve this urgently. Can anyone help me please?

Errors -

"SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.\r\nAn OLE DB record is available. Source: \"Microsoft JET Database Engine\" Hresult: 0x80004005 Description: \"The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.\".\r\n"

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

I have seen that error from time to time. it indicates that the excel file where the connection manager is pointing to is open by other application/process. I read a Phil's suggestions to use a third party to monitor and detect who is actually holding the file, but I don't remember the name.

In the mean time, try closing all applications that may be 'holding the file' and run the package again.

|||Hi,

The error appears due to the upgrade to the SP2 version.

I restarted my system. No other process accessing the excel.
But still the same error.
This functionality used to work fine with the older version of SQL.