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

MSDE management

When I install msde on a W2K professional and go into My Computer/manage and
click on Services and Applications, it shows a MS Sql Server entry from which
I can manage msde. When I install on W2003 server, it's not there. Is this
by design ?
hi,
Dave Mc wrote:
> When I install msde on a W2K professional and go into My
> Computer/manage and click on Services and Applications, it shows a MS
> Sql Server entry from which I can manage msde. When I install on
> W2003 server, it's not there. Is this by design ?
Start -> Administrative Tools-> Services
Start -> Control Panel-> Administrative Tools-> Services
Start -> All Programs-> Administrative Tools-> Services
Start -> My Computer-> Change a setting-> Administrative Tools-> Services
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I guess I didn't make it clear. The service is there on my W2003 server.
What's different is on my W2k pro, under My Computer/Manage/Services and
Applications, It shows Microsoft SQL Servers/MYLOCALSERVER/ then all the
"normal" Enterprise Manager items -- Databases, Maintenance Plans, etc. As
far as I know, MSDE is the only SQL ever installed on my workstation. When I
do an MSDE install on the server, though, the service is there and running
but I don't get the management tools as above. I was surprised when I saw
them on my workstation because I thought to manage msde, you were either
stuck with command line osql statements or third party "Enterprise Manager
like" management tools. So, I'm a little confused.
Thanks
"Andrea Montanari" wrote:

> hi,
> Dave Mc wrote:
> Start -> Administrative Tools-> Services
> Start -> Control Panel-> Administrative Tools-> Services
> Start -> All Programs-> Administrative Tools-> Services
> Start -> My Computer-> Change a setting-> Administrative Tools-> Services
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Dave,
Dave Mc wrote:
> I guess I didn't make it clear. The service is there on my W2003
> server. What's different is on my W2k pro, under My
> Computer/Manage/Services and Applications, It shows Microsoft SQL
> Servers/MYLOCALSERVER/ then all the "normal" Enterprise Manager
> items -- Databases, Maintenance Plans, etc. As far as I know, MSDE
> is the only SQL ever installed on my workstation. When I do an MSDE
> install on the server, though, the service is there and running but
> I don't get the management tools as above. I was surprised when I
> saw them on my workstation because I thought to manage msde, you were
> either stuck with command line osql statements or third party
> "Enterprise Manager like" management tools. So, I'm a little
> confused.
> Thanks
MSDE comes with no management tool but oSql.exe, the command line tool, full
stop.
if you find them on your pc(s), they have been arbitrarily installed by the
SQL Server CD-Rom and no other way..

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You are right. I did some more checking and found that someone had been
doing development on this pc and installed sql 2000 from their msdn cd. Now,
my question is, am I violating a license agreement if I just install Client
Tools from a SQL cd even though I am only installing msde ?
Thanks
"Andrea Montanari" wrote:

> hi Dave,
> Dave Mc wrote:
> MSDE comes with no management tool but oSql.exe, the command line tool, full
> stop.
> if you find them on your pc(s), they have been arbitrarily installed by the
> SQL Server CD-Rom and no other way..
>
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Dave,
Dave Mc wrote:
> You are right. I did some more checking and found that someone had
> been doing development on this pc and installed sql 2000 from their
> msdn cd. Now, my question is, am I violating a license agreement if
> I just install Client Tools from a SQL cd even though I am only
> installing msde ?
AFAIK, unfortunately YES...
in order to manage MSDE instance, you can only rely on self made tools or
third arty tools, but not on SQL Server Client Tools..
please have a look at this post, http://tinyurl.com/4u2zh , by a Microsoft
representative
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Installation Problem - very urgent

Hi,
I'm facing a strange problem with MSDE. I installed MSDE 2000 in a newly formatted Window 2000 professional Machine with SP2 and IE5.5. I restarted the machine after MSDE installation. Installed my application, which creates a database. Database creation failed, I got this error "Login failed for user 'spsadmin'. Reason: Not associated with a trusted SQL
Server connection.". I tried again, this time I restarted the machine thrice after installing MSDE, then ran my setup. Database installation was through. We can't ask the end user to restart the machine these many times. Any help will be appreciated.
Thanks in advance,
VardhiniHi,
I solved the problem. It was because of the authentication. In the setup the login mode was changed to 2 and it was not getting reflected as the service was running. So from the setup I stopped the service, changed the mode and started the service again, this time database had been created successfully.
Thanks,
Vardhini

MSDE Installation on a XP Professional WS.

Hello,
I'm experiencing 2 problems after MSDE installation on a XP Pro workstation
on a network.
1. The SQL Service Manager don't show the default instance. If I put
manually is OK, but on every reboot it lose the instance name and show me
nothing.
2. it's impossible to login from an external computer or create any kind of
connection (ODBC or .udl file).
For information the setup was make:
with an .ini file containing
[Options]
INSTANCENAME=fgsoftware
SAPWD=xyzxyz
SECURITYMODE=SQL
The computer is SP2 full patched.
After the first problems I deactivated the windows firewall.
Help me!!!
TIA
Francesco Garganese
FG software
Can't help you with 1 unfortunately - it has happened to me but I've never
quite worked out why...
To log in from an external computer you need to have set the
DISABLENETWORKPROTOLS flag to false when installing. See the readme that
comes with the installer for more details on command line switches.
Also, MSDE from Service Pack 3a onwards, installs in Windows Authentication
mode only by default. see the following kb article for more info:
http://support.microsoft.com/default...;EN-US;Q325022
If you're trying to access it from another machine that is not logged in as
a *domain* user on the same domain (i.e. you must be running a Windows 2003
Server Domain Controller somewhere) then you can only connect using Mixed
Mode Authentication, which as the above article will tell you is disabled by
default.
"Francesco Garganese" <FrancescoGarganese@.discussions.microsoft.com> wrote
in message news:CD18E7C6-6E32-4D27-974D-C744C580C820@.microsoft.com...
> Hello,
> I'm experiencing 2 problems after MSDE installation on a XP Pro
> workstation
> on a network.
> 1. The SQL Service Manager don't show the default instance. If I put
> manually is OK, but on every reboot it lose the instance name and show me
> nothing.
> 2. it's impossible to login from an external computer or create any kind
> of
> connection (ODBC or .udl file).
> For information the setup was make:
> with an .ini file containing
> [Options]
> INSTANCENAME=fgsoftware
> SAPWD=xyzxyz
> SECURITYMODE=SQL
> The computer is SP2 full patched.
> After the first problems I deactivated the windows firewall.
> Help me!!!
> TIA
> --
> Francesco Garganese
> FG software
|||Thank you very much Ben, adding DISABLENETWORKPROTOLS=0 in the paramenters
and reinstalling both problems are resolved!
Sincerely
Francesco Garganese
FG software

MSDE install

Dear Everybody,
When i am installing MSDE 2000 Release A on Windows XP Professional System.
It gives me Error "Invalid Instance Name".
What I done wrong please help me.
Ashok
hi,
Ashok wrote:
> Dear Everybody,
> When i am installing MSDE 2000 Release A on Windows XP Professional
> System. It gives me Error "Invalid Instance Name".
>
can you please provide the command line you passed to the setup.exe boostrap
installer?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 BLANKSAPWD=1
Here the instance name is NetSDK.
Once you are instlled successful with this instance name NetSDK, if you want
to install again with the same instance name, you need to remove instance.
"Ashok" wrote:

> Dear Everybody,
> When i am installing MSDE 2000 Release A on Windows XP Professional System.
> It gives me Error "Invalid Instance Name".
> What I done wrong please help me.
> Ashok
>
>

MSDE in WinXP Pro SP2

I have installed MSDE in WinXP Professional SP2, and already enabled the
TCP/IP protocol in SQL Server Network Utility. However, I find that it is
failure to connect the database by calling the IP Address even I test it
locally (use sa/window authorization) , but it is ok by calling the computer
name or (local) (also use sa/window authorization) . I have disabled the
firewall and the situation is no change.
Anyone have same experience on this case?

> Anyone have same experience on this case?
Yes, I have. But I have no answer how to fix it. There must be a bug
somwhere.
Regards,
Lars-Inge Tonnessen