Web Wiz Forums - Basic setup question

Print Page | Close Window

Basic setup question

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=25230
Printed Date: 04 April 2026 at 2:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Basic setup question

Posted By: willsteele
Subject: Basic setup question
Date Posted: 29 January 2008 at 4:47pm

I am new to the ww forums and need some basic guidance. I created the database in SQL server, entered the paramters in the connection.asp file. Then, I navigated to the msSQL_server_setup.asp page. I don't know which pieces of information to enter here. Any advice would be great.

Thanks

Replies:

Posted By: WebWiz-Bruce
Date Posted: 29 January 2008 at 5:19pm

Generally you enter the same information as in the database_connection.asp file.

It only asks for the information again as sometimes people setup a SQL Server Login that only has read and write permissions, and no permissions to create and alter tables. However as you are having to ask I doubt you have gone this deep into SQL Server permission system, so you should be able to enter the same details as in the connection file and leave the grouping on 'DBO'

-------------
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: willsteele
Date Posted: 29 January 2008 at 5:39pm

I modified the connection.asp page to read the following:

strSQLServerName = "MACHINENAME\SQLEXPRESS"

strSQLDBUserName = "webwiz"

strSQLDBPassword = "BLAHBLAHBLAH"

strSQLDBName = "webwizforums"

where machinename and blahblahblah are replaced with real data. I also created a webwiz account via SQL Server 2005 Express Managment studio then:

On the General page for the login profile:

1) set the password to match what's in the strSQLDBPassword variable above

2) enabled enfore password policy

3) set the default database to webwizforums

On the Server roles I enabled all.

On the User Mapping tab I enabled map on the webwizforums db, user webwiz, default schema dbo

On the Securables tab I didn't do anything

On the Status tab Permission was granted and Login enabled.

Sorry for the simplicity of the question.

Posted By: WebWiz-Bruce
Date Posted: 29 January 2008 at 6:49pm

Thats seems correct. The only thing you have not mentioned is that SQL Server needs to be installed in mixed mode to allow TCP/IP connections.

-------------
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: willsteele
Date Posted: 29 January 2008 at 7:40pm

Sorry for being dense here:

Server username would be webwiz

Password would be BLAHBLAHBLAH

Server username would be either DBO or ???

Is that correct?

Posted By: WebWiz-Bruce
Date Posted: 29 January 2008 at 8:15pm

On the setup page leave DBO as DBO as this stands for Database Owner which the user you have created in SQL Server should be the DBO (Database Owner) on the database.

-------------
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: willsteele
Date Posted: 29 January 2008 at 9:24pm

Thanks. I googled the error code and found it was my SQL server install was not in mixed mode. I reset the registry value for login authentication mode and it popped right up.

Thanks.