I don't have a website to throw that on. Can I e-mail that to you or do you
have a place I can drop it?

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

smileyville via SQLMonster.com (u63758@uwe) writes:
There are places on the web where you can upload stuff like this,
although I don't recall any URL, but I've occasionally seen other
people do this, so I know they exists.

I prefer if to keep the discussion to the newsgroup.


--
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

That's fine, does anyone have a suggestion where I can upload this log?


Erland Sommarskog wrote:
--
Message posted via http://www.sqlmonster.com

smileyville via SQLMonster.com (u63758@uwe) writes:
I tried this site: http://www.google.com, and in the search box I entered

"upload files" free

A quick browse of the hits looked promising.

--
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

Sorry for the delay, I have placed the log file here for your review.

http://www.mediafire.com/?a8b1fgrqikq5r

Thanks.



Erland Sommarskog wrote:
--
Message posted via http://www.sqlmonster.com

smileyville via SQLMonster.com (u63758@uwe) writes:
Thanks for the log. It tells me that you tried to install SQL Server on
the D: disk, and that it failed when it tried to start SQL Server.

Is there any file
d:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
on the machine?

Or is there anything else interesting in this directory like a dump file
of some sort?

Have you checked the Windows event log if there is anything error message
that coincides with this failure and which has some new information?

Do I conclude right when I say that you are running 32-bit Windows?
Which file system do you have? There were some messages that indicated
that you are using FAT rather than NTFS.

--
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

Thank you for digging through that. I have not made any changes, so all
files/logs are intact, but there is no an error log in that directory.

I confirmed within Device Manager that both partitions (C and D), formatted
with NTFS which is what I selected during setup. And, yes, I ran the 32-bit
installation. I confirmed that as well. Hey... never hurts to check.

I don't see any dump files, or am looking in the wrong place. Simliar errors
in the Event Viewer as I had with 2000 though.

Here they are.

EventID: 10005, Source: MSInstaller

Product: Microsoft SQL Server 2005 Express Edition - Error 29503. The SQL
Server service failed to start. For more ifnormation, see the SQL Server
Books Online topics, "HOw to View SQL Server 2005 Setup Log Files" and
"Starting SQL Server Manually".
The Error is (1053) The service did not respond to the start or control
request in a timley fashion.


EventID: 1000, Source: Application Error

Faulting Application, sqlserver.exe, version 2005.90.1399.0, faulting module
sqlserver.exe, version 2005.90.13999.0, fault address 0x01019027.


The interesting thing here is that the SQL 2005 installation left the SQL
Services in the Services list, but disabled them. The Crystal Report Server
and MSDE 2000 rolled them back when it bombed.

The ultimate goal is Crystal Reports Server, but still believe firmly that
there is some kind of conflict or issue with the SQL part of the install
which is reflective here when even a more current version bombs out. It's
very strange indeed.

I hope to spend some time on this tomorrow and may wipe the box or at least
follow the removal instructions again to see if I am missing something when I
go through that. But, not likely as the problem existed even after a brand
new configuration of the OS on the machine after a reformat.

Thanks again for your help. This is perplexing, but there has to be a
solution!

Erland Sommarskog wrote:
--
Message posted via http://www.sqlmonster.com

smileyville via SQLMonster.com (u63758@uwe) writes:
Ah, that seems to be the ticket!

Check out
http://blogs.msdn.com/b/psssql/archi...-per-core.aspx

Does that apply to you?

Since you are installing Express, I think you can skip the acrobatics
mentioned in the blog post, and download the streamlined install. Get
it from
http://www.microsoft.com/downloads/e...displaylang=en



--
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

We are on the right track I think but this isn't working for me yet. I will
have to pack it up for the day, but think we are close, it might just be a
combination of these suggestions. I went back to MSDE 2000 as that's what
the Crystal Report server uses. If I can get that to go, Crystal should go.
At least that's my hope.

In this article (I am using the SQL 2000 MSDE installation will fail if you
have number of CPUs on a box which is not in the power of 2), it refers to
running setup in debug mode so some reg entries can be added during the
installation. I am using the syntax as noted the install path, setup.exe
k=dbg. I tried both with and without the modified setup.ini script. It
bombs if I don't due to the SA password.

So, if the sytax is not correct, please let me know what it should be. It
would be another starting point at this point.

If this was your server, what would your next step be?

Erland Sommarskog wrote:
--
Message posted via http://www.sqlmonster.com

smileyville via SQLMonster.com (u63758@uwe) writes:
Due to the sa password?

I'm afraid that I have no experience of running Setup in debug mode.

Seriously consider installing SQL 2008 Express SP1. Is there any particular
reason that you want to install MSDE 2000?

You could open a case with Microsoft to get help with the issue, but I don't
know how their support offering looks like for this ten year old product.

You could also investigate whether the BIOS permits you turn one of the
cores.


--
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