I got MSDE with a ASP.NET resource CD (seeming as I am new to ASP.NET) and tried to install it as it was the only componant that I didn't have (I used Access to develop ASP thus far).

Any way, after extracting the files from SQL2KDeskSP3.exe and then running the setup file from that, I almost immediately come across this error message:

Now, I read the help files... no use. Check XP Pro's help... got head ache. Now I am coming to you guys for the rescue.

Cheers!

Install it from the commandline like so:

C:\dirofinstallfiles\setup.exe SAPWD=yoursuperstrongpasswordhere SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

I recomment Securitymode=SQL as opposed to windows as in most web applications you may use sql authentication

Okay, done what you said, and the installation almost completed till their was something wrong with my server and the thing rolled back. Said to check the log files, but I don't know where they are - I'm using IIS 5.1 on Windows XP Pro.

Also, another problem came up after the installation; even though it didn't properly install, the ADODB connection drivers didn't work and the my sites bombed out. Luckly, I rolled my system back to yesterday and it works fine again.

Sorry, to be a pain (amatures!) but seems I need a little more help.

Cheers very much any way!

2004-08-15 12:02:13.66 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)

2004-08-15 12:02:13.66 server    Copyright (C) 1988-2002 Microsoft Corporation.
2004-08-15 12:02:13.66 server    All rights reserved.
2004-08-15 12:02:13.66 server    Server Process ID is 3116.
2004-08-15 12:02:13.66 server    Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2004-08-15 12:02:13.69 server    SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-08-15 12:02:13.74 server    SQL Server configured for thread mode processing.
2004-08-15 12:02:13.76 server    Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-08-15 12:02:13.79 spid3     Warning ******************
2004-08-15 12:02:13.79 spid3     SQL Server started in single user mode. Updates allowed to system catalogs.
2004-08-15 12:02:13.79 spid3     Starting up database 'master'.
2004-08-15 12:02:13.98 server    Using 'SSNETLIB.DLL' version '8.0.760'.
2004-08-15 12:02:13.98 spid5     Starting up database 'model'.
2004-08-15 12:02:14.04 spid3     Server name is 'SIKENE-LVIW4DOK'.
2004-08-15 12:02:14.04 spid3     Skipping startup of clean database id 5
2004-08-15 12:02:14.04 spid3     Skipping startup of clean database id 6
2004-08-15 12:02:14.04 spid3     Starting up database 'msdb'.
2004-08-15 12:02:14.45 spid5     Clearing tempdb database.
2004-08-15 12:02:15.39 spid5     Starting up database 'tempdb'.
2004-08-15 12:02:15.85 spid3     Recovery complete.
2004-08-15 12:02:15.85 spid3     SQL global counter collection task is created.
2004-08-15 12:02:15.97 spid3     Warning: override, autoexec procedures skipped.
2004-08-15 12:02:19.31 server    SQL server listening on 127.0.0.1: 1433.
2004-08-15 12:02:19.32 server    SQL server listening on TCP, Shared Memory, Named Pipes.
2004-08-15 12:02:19.32 server    SQL Server is ready for client connections
2004-08-15 12:02:29.18 spid3     SQL Server is terminating due to 'stop' request from Service Control Manager.

----------------------

No idea what all that means. I am sure I managed to install MSDE before with no problems... may have a look around the MS site for the program.

Ahh think I may of sussed it.

I orignally suspected that I got a update file for MSDE, not the app it's self, and http://www.microsoft.com/sql/downloads/2000/sp3.asp - this comfirms my suspicions . So what I am doing now is downloading http://www.microsoft.com/sql/msde/downloads/download.asp - this  and hoping it works.

Damn amatures eh? lol

Cheers for the help.

Okay, on installing both sets of files I said. I get the same problems.

1. During a point on installing, it gets to a point and pops up with the message "Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."

2. After that install (dispite it not working), my ASP scripts don't work. Namely the database connections; it comes up with this message...

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

So I dunno really...
Cheers for any help!

To your error 1, well check the log files.

As for the 2nd, it seems that you are using some old ODBC drivers, update your MDAC to at least 2.7 and see if that changes anything. WInXP comes with that already, but I have seen them getting corrupted on occasion. (Actually just a regkey) so to make it easy intall MDAC 2.8