Unable to install MSDE

[farqua]

I've been trying to install MS SQL Server 2000 sp3 on a stand alone
WinXP box. I've tried using the version that came on the Office Pro
2003 cd as well as the latest download from MS (apparently they are
the same). This is a new install and I am install from an account with
administrative privileges (actually it's the only account on this
box).

I've tried installing from a DOS box and from an explorer window. I've
tried inputing different options at the commandline (all of them with
the SAPWD switch or else I get the SA password dialog box) and by
altering the setup.ini file. I've tried creating the target and data
directories first and running setup (both at the commandline and
through explorer and using the different variations of passing the
startup variables).

The results have all been the same. I get a configuring MS SQL DE
dialog box with a running progress bar. It seems about finished
configuring but stops near the end. Then the progress bar actually
goes in reverse and the whole thing stops without installing a thing.
This is truly puzzling and am wonder what I am missing.

[Tony Toews]

farqua <fa****@news.com> wrote:

I've been trying to install MS SQL Server 2000 sp3 on a stand alone
WinXP box.
I've been battling the same problem the last day or so.
The results have all been the same. I get a configuring MS SQL DE
dialog box with a running progress bar. It seems about finished
configuring but stops near the end. Then the progress bar actually
goes in reverse and the whole thing stops without installing a thing.
This is truly puzzling and am wonder what I am missing.

Here's what I've found. YMMV of course.

Here's my setup string that finally worked. You may want to choose a different
option for disable network protocols.

setup SECURITYMODE=SQL SAPWD="xxxx" DISABLENETWORKPROTOCOLS=0
/L*V C:\msde.log

Look for value=3 in the log file and review the previous and 10 next lines.

INF: How to Secure Network Connectivity for SQL Server 2000 Local Databases
http://support.microsoft.com/default...b;en-us;814130
"If you specify DISABLENETWORKPROTOCOLS=1, no network protocols are enabled for that
instance."

FWIW I found most of my answers by searching at groups.google.com.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[farqua]

On Mon, 26 Jan 2004 00:35:25 +0000, Tony Toews wrote:

farqua <fa****@news.com> wrote:

I've been trying to install MS SQL Server 2000 sp3 on a stand alone
WinXP box.

I've been battling the same problem the last day or so.

The results have all been the same. I get a configuring MS SQL DE dialog
box with a running progress bar. It seems about finished configuring but
stops near the end. Then the progress bar actually goes in reverse and
the whole thing stops without installing a thing. This is truly puzzling
and am wonder what I am missing.

Here's what I've found. YMMV of course.

Here's my setup string that finally worked. You may want to choose a
different option for disable network protocols.

setup SECURITYMODE=SQL SAPWD="xxxx" DISABLENETWORKPROTOCOLS=0
/L*V C:\msde.log

Look for value=3 in the log file and review the previous and 10 next
lines.

INF: How to Secure Network Connectivity for SQL Server 2000 Local
Databases http://support.microsoft.com/default...b;en-us;814130
"If you specify DISABLENETWORKPROTOCOLS=1, no network protocols are
enabled for that instance."

FWIW I found most of my answers by searching at groups.google.com.

Tony

I don't have value=3 in my log at all and I believe that I've tried every
possible combination of setup parameters. The log's final message is
"MainEngineThread is returning 1603", which according to the SQL Server
Books Online documentation just means failure. I haven't found much
resolution in the google groups although this problem is not necessarily
rare. I'm afraid that I'm stuck.