Web Wiz Support and Community Forums : Basic setup question https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 02:15:21 +0000 Tue, 29 Jan 2008 21:24:33 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25230 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Basic setup question : Thanks. I googled the error code...]]> https://forums.webwiz.net/basic-setup-question_topic25230_post131145.html#131145 Author: willsteele
Subject: 25230
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.
]]> Tue, 29 Jan 2008 21:24:33 +0000 https://forums.webwiz.net/basic-setup-question_topic25230_post131145.html#131145 <![CDATA[Basic setup question : On the setup page leave DBO as...]]> https://forums.webwiz.net/basic-setup-question_topic25230_post131140.html#131140 Author: WebWiz-Bruce
Subject: 25230
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.]]> Tue, 29 Jan 2008 20:15:42 +0000 https://forums.webwiz.net/basic-setup-question_topic25230_post131140.html#131140 <![CDATA[Basic setup question : Sorry for being dense here:Server...]]> https://forums.webwiz.net/basic-setup-question_topic25230_post131138.html#131138 Author: willsteele
Subject: 25230
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?
]]> Tue, 29 Jan 2008 19:40:11 +0000 https://forums.webwiz.net/basic-setup-question_topic25230_post131138.html#131138 <![CDATA[Basic setup question : Thats seems correct. The only...]]> https://forums.webwiz.net/basic-setup-question_topic25230_post131136.html#131136 Author: WebWiz-Bruce
Subject: 25230
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.]]> Tue, 29 Jan 2008 18:49:54 +0000 https://forums.webwiz.net/basic-setup-question_topic25230_post131136.html#131136 <![CDATA[Basic setup question : I modified the connection.asp...]]> https://forums.webwiz.net/basic-setup-question_topic25230_post131134.html#131134 Author: willsteele
Subject: 25230
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.
]]> Tue, 29 Jan 2008 17:39:15 +0000 https://forums.webwiz.net/basic-setup-question_topic25230_post131134.html#131134 <![CDATA[Basic setup question : Generally you enter the same information...]]> https://forums.webwiz.net/basic-setup-question_topic25230_post131133.html#131133 Author: WebWiz-Bruce
Subject: 25230
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'
]]> Tue, 29 Jan 2008 17:19:06 +0000 https://forums.webwiz.net/basic-setup-question_topic25230_post131133.html#131133 <![CDATA[Basic setup question : I am new to the ww forums and...]]> https://forums.webwiz.net/basic-setup-question_topic25230_post131132.html#131132 Author: willsteele
Subject: 25230
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
]]> Tue, 29 Jan 2008 16:47:20 +0000 https://forums.webwiz.net/basic-setup-question_topic25230_post131132.html#131132