Help with setup !

I have a problem with connecting the DB. below is what I did.

I edited the DB config file as follows:

nter the details of your Microsoft SQL Server or MySQL Server and database below
    '*********************************************************************************
   
    strSQLServerName = "localhost" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
    strSQLDBUserName = "ala" 'Holds the user name (for SQL Server Authentication)
    strSQLDBPassword = "5801" 'Holds the password (for SQL Server Authentication)
    strSQLDBName = "forum"


--------
I placed the forum directory in c:\inetpub\wwwroot\forum

this is where im stuck at:



and this is how my SQL DB looks like.




any help appreciated.


Edited by motawa - 08 March 2008 at 2:53pm

It keeps giving the Access denied message.

I created a login account and granted it the access to create tables and all that stuff for the DB "forum" and still didnt work :s

Did you install SQL Server in mixed mode?

For ASP to be able to connect to an SQL Server database, SQL Server has to be instaleld in mixed mode with TCP/IP connections enabled.