I have been finding that I'm having trouble with the Crystal Reports Server
XI installation failing when it's dealing with SQL.

So, as a thought and in case there was something wrong with my SQL portion of
the isntall. I thought ok, I'll try installing the actual MSDE application
direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is
msde2000a.exe), set my switches and off to the races. It quit when it noted
there was about 4 seconds left to the installation and bombed with the same
errors as the Crystal Reports Server install.

The error is the same whether I try to install MSDE by itself or install
using Crystal Reports XI Server. The error is, "Setup failed to configure
the server. Refer to the server error logs and setup error logs for more
information. I have done so, but still cannot figure out what is getting
hung up, though it seems to be right after it creates the SQL services (from
my untrained eye though).

Is there a known trick to get around this? IS there a potential hardware
conflict? The OS Is Windows 2003 R2, SP2, the hardware is a brand new HP
Proliant DL385 G6. (**With the ERP app, this version of Crystal Reports
server is the only one that is supported and they are not supported via 2008
or 64-bit, so installed at the SmartStart level, 32-bit version of Windows
2003.)


Thoughts???? This is becoming a critical issue. Crystal Reports Server for
Crystal XI, is our means of delivering reports. All other applications are
working correctly on this box and this is my hold up.

Yes, I've cleaned the registry and files before performing each install
according to MS Article on removing MSDE. However; if there is an odd entry
that is causing the problem, please let me know.

Any thoughts are desperately appreciated! Thanks.

hi,
smileyville wrote:
the "traditional" problem related to this event is described in
http://support.microsoft.com/kb/816499/en-us
please try having a look at the referenced KB article..
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
http://www.hotelsole.com - http://www.hotelsolericcione.de
--------- remove DMO to reply

Hey thanks, I went through these documents step by step again. I have tried
a couple of different directory locations specified either by command line or
by using the script. Incidentally since the install rolls back, all that
remains for cleanup is the program files directory but it only contains the
logs. The registry only contains the keys for MSSQL under the HKLM\Software\
Microsof key, but there are no setup or data keys there. So, went through
the document and then rebooted and tried again.

Result- Same result. Is there a possibility that the downloaded version is
corrupt? Will there be a conflict with other system components such as .NET
Framework or some other item?

Andrea Montanari wrote:
--
Message posted via http://www.sqlmonster.com

hi,
smileyville via SQLMonster.com wrote:
yes, it "can" be corrupted.. but please try as well to install enabling the
full verbose log indicating the additional
/L*v "c:\MsdeLog.txt"
command line parameter.. a text file of about 2mb (for a succesfull
installation) will be written, and you can inspect that file for
RETURN VALUE 3
entries indicating problems/exceptions at install time..
these are sometime litle cryptic, but those additional info are usually
helpfull troubleshooting the faling installation..
additional manual uninstall/cleanup instructions can be found at
http://support.microsoft.com/kb/320873/EN-US/ and
http://support.microsoft.com/kb/290991/EN-US/
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
http://www.hotelsole.com - http://www.hotelsolericcione.de
--------- remove DMO to reply

Ok, I am totally confused! I decided, ok, let's wipe the system clean again
to make sure I have no conflicts. So, I went through Smart Start like a
clean system and loaded the OS. I did not join to the domain, apply any
updates, completely bare bone. I downloaded a fresh copy of the MDSE from
Microsoft at
http://www.microsoft.com/downloads/d...ng=en#filelist

hi,
smileyville via SQLMonster.com wrote:
hi,
ok, you wiped out the "system disk" (probably c:\), but did you clear the
d:\Program Files\Microsoft SQL Server\MSSQL$BOMSDE as well?
regards
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
http://www.hotelsole.com - http://www.hotelsolericcione.de

smileyville via SQLMonster.com (u63758@uwe) writes:
Did you look at
d:\Program Files\Microsoft SQL Server\MSSQL$BOMSDE\Log\ERRORLOG? There could
be more information there.

The "standard" meaning of return value 3 is "The system cannot find the
path specified". That is, there is a reference to a non-existent directory.
However, I don't know whether this is such a return code.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Yes, I formatted and then removed the D partition prior to redoing the system
disk.

Andrea Montanari wrote:
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...setup/201008/1

Would it help if I attached the full log?

Erland Sommarskog wrote:
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...setup/201008/1

smileyville via SQLMonster.com (u63758@uwe) writes:
At this moment, I think the most interesting is the SQL Server error,
which is located in

I you still installed SQL Server on the D disk and with that instance name.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx