Installing webwiz on 2003/sqlserver

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I am trying to install webwiz 8 on my win2003 server, with SQL server and IIS with ASP enabled runing on it.

I have created an empty database on the SQL Server.

I have edited 'database_connection.asp' found in the 'database' directory with correct user name , password, servername and database name.
next, I tried to run the http://localhost:8081/forum/msSQL_server_setup.asp  script.
the ASP page loads OK. but, after I enter database user and password details and click on "Enter" button. I receive below error message.

Error Connecting to database on SQL Server

Check the following is set up and correct:- 

SQL Server User Name
SQL Server Password
Name of the SQL Server
Database name set up by you on the server
Empty Database set up by you on the SQL Server

Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.
-----------------

I tried to use the same connection details from query analyzer, I was able to login with out any problems.
also, I tried configuring a system dsn ODBC, and connection went successfully.

Can you please help with overcoming this error.