Web Wiz Support and Community Forums : database_connection.asp configuration for SQL 2005

Web Wiz Support and Community Forums : database_connection.asp configuration for SQL 2005 https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 10:12:26 +0000 Wed, 19 Jul 2006 09:19:45 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20723 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[database_connection.asp configuration for SQL 2005 : In SQL Server you need to give...]]> https://forums.webwiz.net/database-connection-asp-configuration-for-sql-2005_topic20723_post111121.html#111121 Author: WebWiz-Bruce
Subject: 20723
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.]]> Wed, 19 Jul 2006 09:19:45 +0000 https://forums.webwiz.net/database-connection-asp-configuration-for-sql-2005_topic20723_post111121.html#111121 <![CDATA[database_connection.asp configuration for SQL 2005 : Thank you -borg- for your speedy...]]> https://forums.webwiz.net/database-connection-asp-configuration-for-sql-2005_topic20723_post111097.html#111097 Author: carywinton
Subject: 20723
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.]]> Tue, 18 Jul 2006 20:17:35 +0000 https://forums.webwiz.net/database-connection-asp-configuration-for-sql-2005_topic20723_post111097.html#111097 <![CDATA[database_connection.asp configuration for SQL 2005 : For a start you need to setup...]]> https://forums.webwiz.net/database-connection-asp-configuration-for-sql-2005_topic20723_post111065.html#111065 Author: WebWiz-Bruce
Subject: 20723
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.]]> Tue, 18 Jul 2006 10:37:40 +0000 https://forums.webwiz.net/database-connection-asp-configuration-for-sql-2005_topic20723_post111065.html#111065 <![CDATA[database_connection.asp configuration for SQL 2005 : I am rather new to both the Web...]]> https://forums.webwiz.net/database-connection-asp-configuration-for-sql-2005_topic20723_post111003.html#111003 Author: carywinton
Subject: 20723
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

Edited by carywinton - 17 July 2006 at 4:06pm]]> Mon, 17 Jul 2006 16:05:34 +0000 https://forums.webwiz.net/database-connection-asp-configuration-for-sql-2005_topic20723_post111003.html#111003