sql server msde: hi Faraz,
[quoted text, click to view]

you should try fixing MDAC stack which can be corrupted...
try having a look at http://www.macropool.com/en/download/mdac_xp_sp2.html
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
--------- remove DMO to reply

Hi All

I have got problem in installing MS SQL Server 2000 Enterprise Edition
on Windows Server 2003 ... after completion of 99% of setup this error
was occured ... I don't know how to deal with thta .... I am new with
SQL server ... error log is given below ..... Please do help me ...

Cheers

Faraz

16:34:10 Grant Right for TDF-22A01C85037\Administrator returned : 1, 0
16:34:11 D:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -F "D:\WINNT\sqlstp.log" -I
MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 327938 -U sa
-P
###############################################################################


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql server};server=TDF-22A01C85037;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

driver={sql server};server=TDF-22A01C85037;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

driver={sql server};server=TDF-22A01C85037;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

SQL Server configuration failed.

###############################################################################

16:34:37 Process Exit Code: (-1)
16:38:02 Setup failed to configure the server. Refer to the server
error logs and D:\WINNT\sqlstp.log for more information.
16:38:02 Action CleanUpInstall:
16:38:02 D:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service SQLSERVERAGENT
16:38:02 Process Exit Code: (1060) The specified service does not exist
as an installed service.

16:38:02 D:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service MSSQLSERVER
16:38:02 Process Exit Code: (0)
16:38:02 StatsGenerate returned: 2
16:38:02 StatsGenerate (0x0,0x1,0xf00000,0x100,1033,303,0x0,0x1,0,0,0
16:38:02 StatsGenerate -1,Administrator)
16:38:02 Installation Failed.