error when connecting to SQLServer

thank -boRg-, but still something wrong when I followed steps at link:

http://webwiz.net/web_wiz_forums/docs_ms_sql_install.asp?mode=forum

even when I reinstalled SQL Server!

Here the step-by-step I worked:

Reinstalled SQL Server 2000:





Created a blank database:


Modified in database_connection.asp


and run msSQL_server_setup.asp


and finally got errors:

Server Error in Forum Application
An error initialising Global Variables from database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_getForumConfigurationData()_get_global_variables
File Name:- global_variables_inc.asp

Error details:-
ADODB.Recordset
Operation is not allowed when the object is closed. 

I have  .Net  Framework 1.1, .Net Framework 1.1 SDK installed!







Edited by Constantine287 - 08 August 2006 at 11:14am

Constentine287 all looks well although you should always give the SQL Server a password and never leave it blank otherwise anyone can get access to it.

It looks like you have sorted the connection issue and you are now connecting to the SQL Server database fine.

You mention you ran the SQL_server_Setup.asp file but didn't mention if it completed correctly with no errors?

Web Wiz Forums and the setup tool within it are ASP files.

This means you need to run it through an ASP enabled web server, simply opening the file in IE won't make it run.

-borg- ,