Another SQL Server 2k Setup failed to configure the server error. Please help

Hi all,
I realised that there are many postings regarding this error, however,
I have tried all possible proposed solutions based on the replies for
the past 24 hours trying to solve this problem, but failed. Frustrating
it is, but I hope you guys can help me with this.
Problem arises when I tried to install SQL Server 2k Developer's
Edition on a Windows XP Professional. I managed to get it installed
until towards the end when it tried to configure the server, it failed
miserably, with a message:
"Setup failed to configure the server. Refer to the server error logs
and sqlstp.log for more information."
Here is the snippet of the error log file (sqlstp.log)
10:32:59 C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I
MSSQLSERVER -V 1 -M 0 -Q "Latin1_General_CI_AS" -H 2360174 -U sa -P
###############################################################################
Starting Service ...
Latin1_General_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
SQL Server configuration failed.
###############################################################################
Please Help. Thanks.
Cheers
AlvinHave you read this article?
http://support.microsoft.com/kb/306345/EN-US/
Is it given you an idea?
"alvinyyt" <alvinyyt@.gmail.com> wrote in message
news:1154481632.633873.163050@.m79g2000cwm.googlegroups.com...
> Hi all,
> I realised that there are many postings regarding this error, however,
> I have tried all possible proposed solutions based on the replies for
> the past 24 hours trying to solve this problem, but failed. Frustrating
> it is, but I hope you guys can help me with this.
> Problem arises when I tried to install SQL Server 2k Developer's
> Edition on a Windows XP Professional. I managed to get it installed
> until towards the end when it tried to configure the server, it failed
> miserably, with a message:
> "Setup failed to configure the server. Refer to the server error logs
> and sqlstp.log for more information."
> Here is the snippet of the error log file (sqlstp.log)
> 10:32:59 C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I
> MSSQLSERVER -V 1 -M 0 -Q "Latin1_General_CI_AS" -H 2360174 -U sa -P
> ###############################################################################
> Starting Service ...
> Latin1_General_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> SQL Server configuration failed.
> ###############################################################################
> Please Help. Thanks.
> Cheers
> Alvin
>|||Hi Alvin,
It sounds to me that you may have a problem with your MDAC installation
which is causing SQLserver not to boot correctly.
I would suggest you try to either reinstall the current version of MDAC on
you server or install the latest version.
You can obtain a utility from MS (http://support.microsoft.com/kb/301202/)
to determine your current MDAC version.
Then try to perform the installation again.
Not sure of previous suggestions, so apologise if I'm susggesting something
you may have already tried?
Regards
Immy
"alvinyyt" <alvinyyt@.gmail.com> wrote in message
news:1154481632.633873.163050@.m79g2000cwm.googlegroups.com...
> Hi all,
> I realised that there are many postings regarding this error, however,
> I have tried all possible proposed solutions based on the replies for
> the past 24 hours trying to solve this problem, but failed. Frustrating
> it is, but I hope you guys can help me with this.
> Problem arises when I tried to install SQL Server 2k Developer's
> Edition on a Windows XP Professional. I managed to get it installed
> until towards the end when it tried to configure the server, it failed
> miserably, with a message:
> "Setup failed to configure the server. Refer to the server error logs
> and sqlstp.log for more information."
> Here is the snippet of the error log file (sqlstp.log)
> 10:32:59 C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I
> MSSQLSERVER -V 1 -M 0 -Q "Latin1_General_CI_AS" -H 2360174 -U sa -P
> ###############################################################################
> Starting Service ...
> Latin1_General_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> SQL Server configuration failed.
> ###############################################################################
> Please Help. Thanks.
> Cheers
> Alvin
>|||Hi
Thanks for responding to my queries, greatly appreciated. However, I
have tried installing MDAC separately and yet it still failed when
reinstalling SQL Server 2000. I have sorta given up on this problem,
but tried again on another machine and it worked fine. So again I don't
know what was wrong with the settings in the first PC. No resolution =(
Cheers
Alvin
Immy wrote:
> Hi Alvin,
> It sounds to me that you may have a problem with your MDAC installation
> which is causing SQLserver not to boot correctly.
> I would suggest you try to either reinstall the current version of MDAC on
> you server or install the latest version.
> You can obtain a utility from MS (http://support.microsoft.com/kb/301202/)
> to determine your current MDAC version.
> Then try to perform the installation again.
> Not sure of previous suggestions, so apologise if I'm susggesting something
> you may have already tried?
> Regards
> Immy
>
> "alvinyyt" <alvinyyt@.gmail.com> wrote in message
> news:1154481632.633873.163050@.m79g2000cwm.googlegroups.com...
> > Hi all,
> >
> > I realised that there are many postings regarding this error, however,
> > I have tried all possible proposed solutions based on the replies for
> > the past 24 hours trying to solve this problem, but failed. Frustrating
> > it is, but I hope you guys can help me with this.
> >
> > Problem arises when I tried to install SQL Server 2k Developer's
> > Edition on a Windows XP Professional. I managed to get it installed
> > until towards the end when it tried to configure the server, it failed
> > miserably, with a message:
> >
> > "Setup failed to configure the server. Refer to the server error logs
> > and sqlstp.log for more information."
> >
> > Here is the snippet of the error log file (sqlstp.log)
> >
> > 10:32:59 C:\Program Files\Microsoft SQL
> > Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I
> > MSSQLSERVER -V 1 -M 0 -Q "Latin1_General_CI_AS" -H 2360174 -U sa -P
> > ###############################################################################
> >
> > Starting Service ...
> > Latin1_General_CI_AS
> > -m -Q -T4022 -T3659
> > Connecting to Server ...
> > driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
> > [Microsoft][ODBC Driver Manager] Data source name not found and no
> > default driver specified
> > driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
> > [Microsoft][ODBC Driver Manager] Data source name not found and no
> > default driver specified
> > driver={sql server};server=AU-D01095;UID=sa;PWD=;database=master
> > [Microsoft][ODBC Driver Manager] Data source name not found and no
> > default driver specified
> > SQL Server configuration failed.
> >
> > ###############################################################################
> >
> > Please Help. Thanks.
> >
> > Cheers
> >
> > Alvin
> >