Web Wiz Forums - SQL server setup problem

Print Page | Close Window

SQL server setup problem

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6675
Printed Date: 03 April 2026 at 7:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL server setup problem

Posted By: Phoz
Subject: SQL server setup problem
Date Posted: 24 October 2003 at 3:58am

I'm trying to install Web Wiz Forums 7.5 with MS SQL 2000 but I keep getting an error when trying to execute the "msSQL_server_setup.asp"-step.

I've tried all things posted already in this forum and information available on the internet.

Situation:

Microsoft Windows 2000 5.00.2195 Service Pack 4
Microsoft SQL Server 8.00.194

Problem:

Executing msSQL_server_setup.asp and logging in gives the error: "Error Connecting to database on SQL Server" with some advices how to solve the problem.

Already tried/did:

Installed MDAC 2.8
Created an empty database and a user and given all required permissions
Quoted the "On Error Resume Next" line in "msSQL_server_setup.asp" which then gives the following error:

Server object error 'ASP 0177 : 8007007e'
Server.CreateObject Failed
/kennisbank/msSQL_server_setup.asp, line 180
8007007e

Double checked the login information (Login in with the Microsoft SQL Server Query Analyzer does work)
Manually registered msjetoledb40.dll and oledb32.dll

Somehow the "ADODB.Connection"-object can't be created (in the line "Set adoCon = Server.CreateObject("ADODB.Connection")")

I really don't have a clue what to try next or what the problem is. Help and suggesions are appreciated!