Installing WWF: Stuck at "msSQL_server_setup

I am currently stuck at the "Web Wiz Forums Database Microsoft SQL Server Setup" page.  

- I have installed both MS SQL Server Express and the MS SQL Server Management Studio Express.  

- I have created a database called "Forums". 

- I have created a user under Security > Logins also called "forums".  

- I have added the user "forums" to the Database I built under Security > Users.  After adding the user, I went into it's properties and set "dbo" as the default schema.  

- For the two boxes underneath, I have checked every schema/role that seemed relevant.  

- Under IIS, I created a virtual directory called "forums" and set the IUSR_MACHINENAME permissions for both read and write.

Which takes me to where I'm stuck.  I enter http://localhost/forums/msSQL_server_setup.asp into the address bar and the Web Wiz setup page comes up.  I have tried just about every kind of login combo I can think of.  I've even replaced "DBO" with the user I created in SQL Server.

Depending on how I set the database_connection.asp file, I get two different error messages.  


with the strSQLServerName set as: "COS-SITESRV\SQLEXPRESS", I get the following error message INSTANTLY:

Error Connecting to database on SQL Server
"Login failed for user 'forums'. The user is not associated with a trusted SQL Server connection."


With the strSQLServerName set at just "SQLEXPRESS", I get the following error message within 30 seconds:

Error Connecting to database on SQL Server
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.


Here is my config file, with the password and server name changed.


    strSQLServerName = "FORUMSERVER\SQLEXPRESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
    strSQLDBUserName = "forums" 'Holds the user name (for SQL Server Authentication)
    strSQLDBPassword = "password" 'Holds the password (for SQL Server Authentication)
    strSQLDBName = "Forums" 

Edited by Flapjack - 07 September 2007 at 10:19pm

Not sure what you mean by "make sure the forums username is attached".....

right ok, thats good

you need ot go to the main /default section and under security and then logins make sure the username "Forum" or one used is attached to the Forum database, is usually a check box of the databases it can use etc

Thanks for the reply. Sorry it took so long for me to get back to this thread, but I got it a motorcycle accident on the way home and have been at home healing a bit.  I broke both my hands in several places, and my wrist needed to be put back together with a plate and screws.  I'm working again with the help of Dragon Naturally Speaking and the few good fingers I have left.

So, is there any way to find out if I did not install SQL in mixed mode?  I don't remember that option, but it's been awhile since I installed it.  

-boRg- wrote: To me the error:- Error Connecting to database on SQL Server "Login failed for user 'forums'. The user is not associated with a trusted SQL Server connection." Suggests that you didn't install SQL Server in mixed mode, and so only trusted connections are permitted. You need to install SQL Server in mixed mode, allowing TCP/IP connections to the SQL Server.