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
> >

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:[vbcol=seagreen]
> 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 somethin
g
> you may have already tried?
> Regards
> Immy
>
> "alvinyyt" <alvinyyt@.gmail.com> wrote in message
> news:1154481632.633873.163050@.m79g2000cwm.googlegroups.com...

Another Question for the MVP's

I have a quetion for one of the guru's on here...
You've never failed me yet so I'm hopeful you might help me out again.
Here's the scenario... (sorry, copy and paste with courier font for fixed
spacing if it doesn't look right)
Date EquipId Reading
04/01/05 12345 12
04/02/05 12345 10
04/03/05 12345 10
04/04/05 12345 11
04/05/05 12345 13
04/06/05 12345 11
04/07/05 12345 0
04/08/05 12345 0
04/09/05 12345 0
04/10/05 12345 44
04/11/05 12345 13
04/12/05 12345 11
04/01/05 55555 12
04/02/05 55555 10
04/03/05 55555 10
04/04/05 55555 11
04/05/05 55555 13
04/06/05 55555 11
04/07/05 55555 12
04/08/05 55555 11
04/09/05 55555 11
04/10/05 55555 14
04/11/05 55555 13
04/12/05 55555 11
I need to estimate the values that belong in 04/07 thru 04/10 for
EquipID 12345 based on the READING that is in 04/10. I want to put
11 (44/4 days) in each of the Reading fields. This would be only
for consecutive "missed" (or 0) reads. If we missed 1 day, I'd use
the next days reading and divide by 2.
Also, and I'm sure this is a dumb question...
Is there a function that returns the date as shown? "mm/dd/yyyy" I've been
"DATEPART"ing the dates and concatenating and it seems like a lot of
work for something that is probably already written and I just haven't
found.
I look forward to your creative suggestions!
Thanks
Travis Rushton - Systems Analyst
Kootenai Electric Cooperative
Life Is Not A Journey To The Grave With The Intention Of Arriving Safely In
A Handsome And Well Preserved Body. Rather, The Objective Should Be To Skid
In Broadside, Thoroughly Used Up, Totally Worn Out, Loudly Proclaiming:
"Wow... What A Ride!!"Doing this using set-based logic could become a bit tricky. If this is an
one-time deal, use a cursor & get it over with, otherwise here is one
solution:
UPDATE tbl
SET Reading = ( SELECT t3.Reading FROM tbl t3
WHERE t3.EquipId = tbl.EquipId AND t3.Reading <> 0
AND t3.dt = ( SELECT MIN ( t2.dt ) FROM tbl t2
WHERE t2.EquipId = tbl.EquipId
AND t2.dt > tbl.dt
AND t2.Reading <> 0
AND tbl.Reading = 0 ) ) /
DATEDIFF( d, ( SELECT MAX ( t2.dt ) FROM tbl t2
WHERE t2.EquipId = tbl.EquipId
AND t2.dt < tbl.dt AND t2.Reading <>
0 ),
( SELECT MIN ( t2.dt ) FROM tbl t2
WHERE t2.EquipId = tbl.EquipId
AND t2.dt > tbl.dt AND t2.Reading <>
0
AND tbl.Reading = 0 ) )
WHERE Reading = 0 ;
Anith

Anonymous Logon error since SP4

Since SP4 my application and SQL log are filling with "Login failed for user
"NT Authority\Anonymous Logon". Where can I find more information
concerning this?
I've seen one or two references to this error showing up with SQL
replication but this is a single server install.
-trevor
Trevor,
Check that SQL Server is running under a domain account - this error
commonly occurs when running as LocalSystem and you try to access network
resources.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Trevor Miller" wrote:

> Since SP4 my application and SQL log are filling with "Login failed for user
> "NT Authority\Anonymous Logon". Where can I find more information
> concerning this?
> I've seen one or two references to this error showing up with SQL
> replication but this is a single server install.
> -trevor
>
>
|||SQL server indeed runs as LocalSystem but it's always been configured this
way, is the error msg a result of SP4 or a change in behavior? What network
resources would SQL be trying to access? I've tried putting the computer
account into domain admins but the error persists.
Additional advise?
-trevor
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:30AAB157-EB94-4680-B088-44689F364AF9@.microsoft.com...[vbcol=seagreen]
> Trevor,
> Check that SQL Server is running under a domain account - this error
> commonly occurs when running as LocalSystem and you try to access network
> resources.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Trevor Miller" wrote:

Anonymous Logon error since SP4

Since SP4 my application and SQL log are filling with "Login failed for user
"NT Authority\Anonymous Logon". Where can I find more information
concerning this?
I've seen one or two references to this error showing up with SQL
replication but this is a single server install.
-trevorTrevor,
Check that SQL Server is running under a domain account - this error
commonly occurs when running as LocalSystem and you try to access network
resources.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Trevor Miller" wrote:

> Since SP4 my application and SQL log are filling with "Login failed for us
er
> "NT Authority\Anonymous Logon". Where can I find more information
> concerning this?
> I've seen one or two references to this error showing up with SQL
> replication but this is a single server install.
> -trevor
>
>|||SQL server indeed runs as LocalSystem but it's always been configured this
way, is the error msg a result of SP4 or a change in behavior? What network
resources would SQL be trying to access? I've tried putting the computer
account into domain admins but the error persists.
Additional advise?
-trevor
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:30AAB157-EB94-4680-B088-44689F364AF9@.microsoft.com...[vbcol=seagreen]
> Trevor,
> Check that SQL Server is running under a domain account - this error
> commonly occurs when running as LocalSystem and you try to access network
> resources.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Trevor Miller" wrote:
>

Anonymous Logon error since SP4

Since SP4 my application and SQL log are filling with "Login failed for user
"NT Authority\Anonymous Logon". Where can I find more information
concerning this?
I've seen one or two references to this error showing up with SQL
replication but this is a single server install.
-trevorTrevor,
Check that SQL Server is running under a domain account - this error
commonly occurs when running as LocalSystem and you try to access network
resources.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Trevor Miller" wrote:
> Since SP4 my application and SQL log are filling with "Login failed for user
> "NT Authority\Anonymous Logon". Where can I find more information
> concerning this?
> I've seen one or two references to this error showing up with SQL
> replication but this is a single server install.
> -trevor
>
>|||SQL server indeed runs as LocalSystem but it's always been configured this
way, is the error msg a result of SP4 or a change in behavior? What network
resources would SQL be trying to access? I've tried putting the computer
account into domain admins but the error persists.
Additional advise?
-trevor
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:30AAB157-EB94-4680-B088-44689F364AF9@.microsoft.com...
> Trevor,
> Check that SQL Server is running under a domain account - this error
> commonly occurs when running as LocalSystem and you try to access network
> resources.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Trevor Miller" wrote:
>> Since SP4 my application and SQL log are filling with "Login failed for
>> user
>> "NT Authority\Anonymous Logon". Where can I find more information
>> concerning this?
>> I've seen one or two references to this error showing up with SQL
>> replication but this is a single server install.
>> -trevor
>>

Analysis Services Step by Step - connection problem

On page 56 of SQL Server 2005 Analysis Services Step by Step, I tried to DEPLOY the project, and it failed with this msg:

Error 1 The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.

I downloaded the trial version from MS and installed in om my laptop from where im running my tutorial - what could be wrong? (Im a newbie to SQL so I have no clue)

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward Melomed wrote:

You need to make sure Analysis Server is running on your machine. Go into Service control manger and make sure SQL Server Analysis Services service is running.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

I have the following services running:

SQL Server, SQL Server Agent, SQL Server Browser, SQL Server FullText Search, SQL Server Integration Services and SQL Server VSS Writer - I can't see any Analysis related services on my services list?

|||

It is working now - thanks alot for your help.

I reinstalled my solution and for some reason I didnt have the Analasis services correctly installed.