Web Wiz Forums - database_connection.asp configuration for SQL 2005

Print Page | Close Window

database_connection.asp configuration for SQL 2005

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=20723
Printed Date: 11 April 2026 at 10:09am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: database_connection.asp configuration for SQL 2005

Posted By: carywinton
Subject: database_connection.asp configuration for SQL 2005
Date Posted: 17 July 2006 at 4:05pm

I am rather new to both the Web Wiz Forum software, .ASP and SQL 2005 Express. I am unsure of what I need to do to change the database_connection.asp and the SQL 2005 Express configuration in order to set up the Web Wiz Forum. If anyone has done this and could give me an example of what permissions and such are needed, I would be very grateful. I would like the user IUSR_ServerName to be able to use the Forums once they have set up their username and password information.

This is all running on my local network which has a static IP. I am running Windows 2000 Server with IIS 5.0.

Thanks,

carywinton

Replies:

Posted By: WebWiz-Bruce
Date Posted: 18 July 2006 at 10:37am

For a start you need to setup SQL server to be running in mixed mode so that TCP/IP connections to it are allowed.

You then need to create a database in the SQL Sever and a new user for the database that has DBO permissions on the database.

Then in the database_connection.asp enter these details for this database and the new user. For the SQL Server IP address either enter the static IP address of the server, or if running on the same server as the web server use 'localhost' instead of the IP address.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: carywinton
Date Posted: 18 July 2006 at 8:17pm

Thank you -borg- for your speedy reply. I have SQL Server 2005 Express running in mixed mode. I have a database created with a new user. What I am unclear on is the "DBO" permissions you mentioned and the appropriate information and how it should be entered into the database_connection.asp file. I can only humbly appologize for my "lack" of knowledge here, but I guess everyone had to start somewhere, even if it is at the "newbie dunce cap bottom feeder" position.

Posted By: WebWiz-Bruce
Date Posted: 19 July 2006 at 9:19am

In SQL Server you need to give the user you have created DBO permissions on the database. DBO stands for Database Owner.

It's not totally necessary but does help, particularly when running the file to create the database, as the DBO user on the database has permission to create, and alter tables in the database.

Setting the database user as DBO in the database has no bearing on the database_connection.asp file.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting