It seems we are asking the questions, but no one is providing the complete answer, and "PLEASE!" don't say go look at this document here:

http://www.webwiz.net/web_wiz_forums/docs_ms_sql_install.asp?mode=forum - http://www.webwiz.net/web_wiz_forums/docs_ms_sql_install.asp?mode=forum

Because it is very incomplete. I submit this is what I, and I believe, Contantine287 need.

First: a total working example of these lines:

strSQLServerName = "" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)

strSQLDBUserName = "" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "" 'Holds the password (for SQL Server Authentication)

strSQLDBName = "" 'Holds the name of the database 'Initilise the DB

Connection String strCon = "Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
Not just parts of it, all of it. Like so

strSQLServerName = "YourServerName\SQLEXPREESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)

strSQLDBUserName = "IUSR_SERVERNAME" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "If your using IUSR_YOURSERVERNAME (then there is no password, leave it blank? put in "null" or what?" 'Holds the password (for SQL Server Authentication)

strSQLDBName = "YOURSERVERNAME\SQLEXPRESS\DATABASES\FORUM" 'Holds the name of the database 'Initilise the DB

Connection String strCon = "Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
Ok? So does that look correct?

Now what about permissions in the SSMSE (SQL Server Management Studio Express) under our new forum database for IUSR_YOURSERVERNAME, should it be db_datareader and db_datawriter? Anything else needed here?

Now the actual folder on our harddrive for the forum "webwiz\forum" Permissions need to be set on this for "not" to allow inheritable permissions to propagate to this object from parent, so we "uncheck" this box. But wait? no other permissions need to be here? like "system" or "administrators"?

So if this is all correct all that should be left to do is run this file 'msSQL_server_setup.asp'

Then proceed to "upload" the files to your web hosting provider, but in my case I am hosting it on my own network and my own server, which all ready have working and dns resolving web sites, so I know my server is working properly.

Now I should be able to "log in" to the forums administration page, if I did not recieve any errors from the 'msSQL_server_setup.asp' script. But what if I did get an error here? what if it is one of those darned "cannot connect to database" errors, then what? Where do I look for the problem? A log file perhaps? Where would it be? What would it be called?

I am sorry if I have seemed to "rant" on a bit here, but I believe this is the proper form and required information needed to respond on a forum.

Thank you for your time and I hope there will be someone who will assist us further. If you desire to call it "having to hold my hand and spoon feed me, so be it" I just want to get this darn thing done and working.

 

 

All righty then -borg- , what part of this is "NOT" correct, please advise.

Thank you.

I made a discovery dealing with this last night. What I found was two fold dealing with the SQL database and IIS 5.0. First thing is to "NOT" add the Forum folder under or in the same directory as your web site. Why you might ask? Becuse, IIS and SQL will try to "duke" it out over permissions and authentication. When I got my web site to the point where it could be edited and changed to what I needed without difficulty, <enter the ability to use FrontPage here>, I added the "forums" folder as a "virtual directory", this is very important because it keeps the appropriate permissions seperate. Then I created my database using SQL Server 2005 Express with the really nice add-on feature of SQL Server Express Management Studio, commomly refered to as SSMSE. You can obtain it here for free.

http://msdn.microsoft.com/vstudio/express/sql/download/ - http://msdn.microsoft.com/vstudio/express/sql/download/

The management interface makes creating the database and new user much easier than in previous editions. Next thing is to make sure when you create your user for the database and connection string is to create them before you create the new database. This will give them the appropriate permissions and rights for the new user. You user needs to have these three rights or permissions, db_writer, db_reader and db_owner. Then you can edite the connection string for webwiz and proceed to run the setup script. I hope this helps, I fought with it for three weeks until I finally figured it all out.