Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - MSDE installation problems
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MSDE installation problems

 Post Reply Post Reply Page  12>
Author
wolfie View Drop Down
Groupie
Groupie


Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfie Quote  Post ReplyReply Direct Link To This Post 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:

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--[
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
wolfie View Drop Down
Groupie
Groupie


Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfie Quote  Post ReplyReply Direct Link To This Post 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--[
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
wolfie View Drop Down
Groupie
Groupie


Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfie Quote  Post ReplyReply Direct Link To This Post 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--[
Back to Top
wolfie View Drop Down
Groupie
Groupie


Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfie Quote  Post ReplyReply Direct Link To This Post 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--[
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 15 August 2004 at 4:27pm
Back to Top
wolfie View Drop Down
Groupie
Groupie


Joined: 18 November 2002
Location: United Kingdom
Status: Offline
Points: 64
Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfie Quote  Post ReplyReply Direct Link To This Post 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--[
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.