database_connection.asp configuration for SQL 2005

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
carywinton Members Profile Find Members Posts Newbie Joined: 17 July 2006 Location: United States Status: Offline Points: 5	Post Options Post Reply Quote carywinton Report Post Thanks(0) Quote Reply Topic: database_connection.asp configuration for SQL 2005 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

carywinton Members Profile Find Members Posts Newbie Joined: 17 July 2006 Location: United States Status: Offline Points: 5	Post Options Post Reply Quote carywinton Report Post Thanks(0) Quote Reply 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum