| Author |
Topic Search Topic Options
|
wolfie
Groupie
Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Topic: MSDE installation problems Posted: 14 August 2004 at 11:47am |
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!
|
Wolfie--[ WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 14 August 2004 at 2:41pm |
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
|
|
|
 |
wolfie
Groupie
Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 August 2004 at 11:46am |
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!
|
Wolfie--[ WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[
|
 |
michael
Senior Member
Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 August 2004 at 12:37pm |
|
you sould have log files in your program files\microsoft sql server\mssql\logs directory. also check your event log.
|
|
|
 |
wolfie
Groupie
Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 August 2004 at 1:43pm |
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.
|
Wolfie--[ WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[
|
 |
wolfie
Groupie
Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 August 2004 at 3:59pm |
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 this comfirms my suspicions. So what I am doing now is downloading this and hoping it works.
Damn amatures eh? lol
Cheers for the help.
|
Wolfie--[ WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[
|
 |
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 August 2004 at 4:27pm |
|
|
 |
wolfie
Groupie
Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
|
Post Options
Thanks(0)
Quote Reply
Posted: 22 August 2004 at 4:12pm |
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!
|
Wolfie--[ WolfWeb.co.uk ]
PHP, .net--[ beginner ] ASP, VB, C, SQL--[ intermediate ] X/D/HTML, CSS, WML, XML--[
|
 |