Cant get the Forum to run on my server

stookie wrote:    HI all   Server Details :- Windows Server 2003, IIS6, SQL Server - I have full access to server via remote connection.   I cant get my forum to run on my server, this is the error I keep getting:   Server Error in Forum Application An error has occurred while connecting to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_db_connection File Name:- common.asp Error details:- Microsoft OLE DB Provider for SQL Server Invalid connection string attribute   I have run the database setup file which successful entered the appropriate tables in my database. I have checked the connection strings in "database_connection.asp" more times than I can remember, everything seems to be correct. I can connect and view the SQL database using CMD and the same username and password that is in "database_connection.asp". Every time I try to run the forum it hangs for a few seconds then the above error is displayed.   Any help or pointers would be very much appreciated   I also have a shopping cart running with SQL and a few Access database driven sites running on the server and they all seem to work fine. The server has very little load.

make DNS less connection. First make user nam eor passowrd  or change the sa user password as urs then do the following script

Set cn = Server.CreateObject("ADODB.Connection")
strConn = "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;PWD=urpwd;Data Source=(Local);Database=dbname;"
cn.open strConn

Note: if db in same server u can use "Local" or IP of system too