Wednesday, March 28, 2012

MSDE Setup Failed

Need Help !!!!

I'm trying to install MSDE on my computer - Dell 2.4 ghz
Operating system is Windows XP Professional.
I have already installed the WEB Matrix but having problems installing MSDE.
I keep getting this error message.

I receive this error message:

(Setup failed to configure the server. Refer to the server error logs and setup error
logs for more information.)

Thanks In AdvanceSigh. Setting up MSDE is one of the most complex things that Microsoft has imposed on us.

What do the logs say? They're usually a pretty good source of information.

Don|||Hi Don,
Thanks for taking the time, Here's the latest log I found. see if this can help?
Thanks again

Jeff

2003-08-02 18:32:43.26 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)

2003-08-02 18:32:43.26 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-08-02 18:32:43.26 server All rights reserved.
2003-08-02 18:32:43.26 server Server Process ID is 1592.
2003-08-02 18:32:43.26 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2003-08-02 18:32:43.28 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2003-08-02 18:32:43.29 server SQL Server configured for thread mode processing.
2003-08-02 18:32:43.29 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2003-08-02 18:32:43.32 spid3 Warning ******************
2003-08-02 18:32:43.32 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2003-08-02 18:32:43.32 spid3 Starting up database 'master'.
2003-08-02 18:32:43.78 server Using 'SSNETLIB.DLL' version '8.0.760'.
2003-08-02 18:32:43.79 spid5 Starting up database 'model'.
2003-08-02 18:32:44.01 server SQL server listening on 192.168.0.2: 1433.
2003-08-02 18:32:44.03 server SQL server listening on 127.0.0.1: 1433.
2003-08-02 18:32:44.09 spid3 Server name is 'CDISLAND'.
2003-08-02 18:32:44.09 spid3 Starting up database 'msdb'.
2003-08-02 18:32:44.59 spid5 Clearing tempdb database.
2003-08-02 18:32:45.54 spid5 Starting up database 'tempdb'.
2003-08-02 18:32:45.78 spid3 Recovery complete.
2003-08-02 18:32:45.78 spid3 SQL global counter collection task is created.
2003-08-02 18:32:45.79 spid3 Warning: override, autoexec procedures skipped.
2003-08-02 18:32:46.28 server SQL server listening on TCP, Shared Memory, Named Pipes.
2003-08-02 18:32:46.28 server SQL Server is ready for client connections
2003-08-02 18:32:54.10 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.|||Finally got it to work, here's what I did:

·Went to my Add/Remove Programs located in Control Panel.
·Removed MSDE from the Add/Remove Programs.
·Went to my C Drive and removed/deleted the (sql2ksp3 folder)
·Next I went to my Programs files folder and also removed/deleted the (Microsoft SQL server) folder.
·Then Restart computer, and reinstall (sql2ksp3) again – thus eliminating the roll back error

Reinstalling sql2kDesksp3
·Double clicked on sql2kDesksp3 bringing up the installation wizard
·And just followed the installation instructions.
·Now your asked to specify where the files in the SQL2KdeskSP3.exe should be unpacked. Leave the default value, C:\sql2ksp2.
·Once this step is complete the installation wizard will quit.
·Next go to Start, Run, and type in cmd and this opens the command prompt. And enter your commands here.
·Type in cd\sql2ksp3 and hit enter
·Next type dir and hit enter
·Next type cd MSDE and hit enter
·Next type dir and hit enter
·Next type setup SAPWD=password SECURITYMODE=SQL and hit enter
And Installation will begin – this may take a few minutes.

Note: where “password” is the password you want for the administrative MSDE account. [Make sure that you write down and remember your password. You will
Need to provide this supplied password when working with MSDE.

After installation is complete, Restart your computer. Upon returning to Windows, you
Should see a new icon in your system tray. The icon will look like a computer tower with a green arrow in a white circle. That's your Done.

Hope this helps Somebody
Cheers!!|||Thanks loads it has helped me...|||Cool! Glad you got it worked out!

Don

No comments:

Post a Comment