Monday, March 26, 2012

Error installing MSDE (Yes, another ;) )

Hi all,
Hope someone will be able to help me out with this one.
First, i'm using a Dell Inspiron 5100 laptop with WinXP Pro installed.
I'm trying to install MSDE2000A with a cmd like "setup SAPWD=xxxx /l* .\log.txt"
Everything seem to works fine until there's about 5sec left.
At this point there's a MessageBox popping-up saying "Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."
I've look at my log.txt file, and search for words like "error" or "failed" like stated by a MVP in a previous post. The only hit i've got was for "failed", like in "Setup failed to config..." the previous line might seem interesting to some : "Execut
ing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "French_CI_AS""
After i've take a look at the server logs in ...\Microsoft SQL Server\MSSQL\LOG\ and Found...
(there's a few lines before, dont think they are interesting... )
2004-05-06 16:05:01.78 spid3 Warning ******************
2004-05-06 16:05:01.78 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-05-06 16:05:01.78 spid3 Starting up database 'master'.
2004-05-06 16:05:02.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-05-06 16:05:02.24 spid5 Starting up database 'model'.
2004-05-06 16:05:02.29 spid3 Server name is 'JOLAPTOP'.
2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 5
2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 6
2004-05-06 16:05:02.29 spid3 Starting up database 'msdb'.
2004-05-06 16:05:03.02 spid5 Clearing tempdb database.
2004-05-06 16:05:04.83 spid5 Starting up database 'tempdb'.
2004-05-06 16:05:05.04 spid3 Warning ******************
2004-05-06 16:05:05.04 spid3 Attempting to change default collation to French_CI_AS.
2004-05-06 16:05:05.12 server SQL server listening on Shared Memory.
2004-05-06 16:05:05.12 server SQL Server is ready for client connections
2004-05-06 16:05:10.31 spid3 Clustered index restored for master.sysdatabases.
(here there's alot of 'index restored for msdb.xxxx' and 'Non-clustered index restored for tempdb.xxx' )...
2004-05-06 16:05:17.32 spid3 index restored for msdb.sysjobsteps.
2004-05-06 16:05:18.68 spid3 Default collation successfully changed.
2004-05-06 16:05:18.69 spid3 Recovery complete.
2004-05-06 16:05:18.69 spid3 SQL global counter collection task is created.
2004-05-06 16:05:18.75 spid3 Warning: override, autoexec procedures skipped.
2004-05-06 16:05:24.16 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
Then i've look at the event System log and found an entry similar to the last line of the server log...
Event Type:Information
Event Source:Service Control Manager
Event Category:None
Event ID:7035
Date:2004-05-06
Time:16:05:23
User:xxxxxxxxxxxxxxx
Computer:xxxxxxxx
Description:
The MSSQLSERVER service was successfully sent a stop control.
I've made some searches on google and nothing come up, i've read the posts here and didnt find any answers...
I can't figure this out. Any help would be appreciated ;)
P.S. There's a folder called 'C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr' on my Computer, MSDE seems to be installed but is not working.
Thanks for your help !
Jonathan
hi Jonathan,
"Jonathan" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:A09AB00D-B6F1-4E5F-B639-7FDDC468477F@.microsoft.com...
> Hi all,
> Hope someone will be able to help me out with this one.
> First, i'm using a Dell Inspiron 5100 laptop with WinXP Pro installed.
> I'm trying to install MSDE2000A with a cmd like "setup SAPWD=xxxx /l*
..\log.txt"
> Everything seem to works fine until there's about 5sec left.
> At this point there's a MessageBox popping-up saying "Setup failed to
configure the server. Refer to the server error logs and setup error logs
for more information."
> I've look at my log.txt file, and search for words like "error" or
"failed" like stated by a MVP in a previous post. The only hit i've got was
for "failed", like in "Setup failed to config..." the previous line
might seem interesting to some : "Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
"French_CI_AS""
>
> After i've take a look at the server logs in ...\Microsoft SQL
Server\MSSQL\LOG\ and Found...
> (there's a few lines before, dont think they are interesting... )
> 2004-05-06 16:05:01.78 spid3 Warning ******************
> 2004-05-06 16:05:01.78 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
> 2004-05-06 16:05:01.78 spid3 Starting up database 'master'.
> 2004-05-06 16:05:02.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2004-05-06 16:05:02.24 spid5 Starting up database 'model'.
> 2004-05-06 16:05:02.29 spid3 Server name is 'JOLAPTOP'.
> 2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 5
> 2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 6
> 2004-05-06 16:05:02.29 spid3 Starting up database 'msdb'.
> 2004-05-06 16:05:03.02 spid5 Clearing tempdb database.
> 2004-05-06 16:05:04.83 spid5 Starting up database 'tempdb'.
> 2004-05-06 16:05:05.04 spid3 Warning ******************
> 2004-05-06 16:05:05.04 spid3 Attempting to change default collation to
French_CI_AS.
> 2004-05-06 16:05:05.12 server SQL server listening on Shared Memory.
> 2004-05-06 16:05:05.12 server SQL Server is ready for client
connections
> 2004-05-06 16:05:10.31 spid3 Clustered index restored for
master.sysdatabases.
> (here there's alot of 'index restored for msdb.xxxx' and 'Non-clustered
index restored for tempdb.xxx' )...
> 2004-05-06 16:05:17.32 spid3 index restored for msdb.sysjobsteps.
> 2004-05-06 16:05:18.68 spid3 Default collation successfully changed.
> 2004-05-06 16:05:18.69 spid3 Recovery complete.
> 2004-05-06 16:05:18.69 spid3 SQL global counter collection task is
created.
> 2004-05-06 16:05:18.75 spid3 Warning: override, autoexec procedures
skipped.
> 2004-05-06 16:05:24.16 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
>
> Then i've look at the event System log and found an entry similar to the
last line of the server log...
> Event Type: Information
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7035
> Date: 2004-05-06
> Time: 16:05:23
> User: xxxxxxxxxxxxxxx
> Computer: xxxxxxxx
> Description:
> The MSSQLSERVER service was successfully sent a stop control.
>
> I've made some searches on google and nothing come up, i've read the posts
here and didnt find any answers...
> I can't figure this out. Any help would be appreciated ;)
> P.S. There's a folder called 'C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr' on my Computer, MSDE seems to be installed but
is not working.
please have a look at
http://support.microsoft.com/default...99&Product=sql
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Tanks for your reply,
I didnt have any previous instance installed but i tried it anyz... But unfortunatly it didnt worked.
I dont known if this can help someone or may affect the setup, but i will post it anyz because i've seen in your link a related page stating that having sql7 tools installed may affect the setup. I know its not the same symptoms as mine, but here it is:
My laptop is setup'ed' for programming and tech.. i mean i've alot of tools to support win2000 domain and troubleshooting services such as ActiveDirectory, Sql Server, ... i also have Visual Studio .NET 2003 and debugging tools installed
My laptop is also up to date with Windows Update, and i have alot of tools installed to manage my system (Norton Anti-Virus, DiskKeeper and such (i've try disabling those services before installing, same error))
Hope someone will find something, cause i'm about to give up... Need that MSDE to be able to code while i'm travelling
Thanks for your help all !!
Jonathan

No comments:

Post a Comment