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

WebWiz-Bruce wrote: I take it this issue is with your local machine install and not our servers here at web wiz?

Correct, local machine only.

During the install it was pretty much automated. Don't remember any options. Might uninstall and run it again.

Thanks Bruce. Will let you know the outcome.

I'm having the same problem. Since moving my sites to web wiz hosting. My previous host was still running SQL Server 2000 so after the move here I needed to move to SQL 2005, actually I installed SQLEXPRESS 2008. A clean install not an upgrade of 2000 as I had a HD crash and installed a new HD. Aslo installed .Net framework and Visual Web Developer as I want to learn ASP.NET.

Everything reported as installing fine. I can connect to the DB Engine with SQL Server Management Studio with Windows Authentication. Set up new Databases and ran a restore of the backups from the files on WWHosting. However no matter what I do and I've tried everything for the past two weeks I can't connect to the websites on my local machine.

Server Error in Forum Application
An error has occured 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

Everytime.

I've tried for Server Name - COMPUTERNAME\SQLEXPRESS; LOCAL\SQLEXPRESS; .\SQLEXPRESS

User Name - COMPUTERNAME\WindowsLogonName; Etc

Password - Windows Password

Tried using sa and sa password.

Always get the error.

Server Error in Forum Application
An error has occured 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

Have checked and double checked the file for correct syntax. Probably have to go and top myself when I find the problem but I'm stumped.

If I try to logon to the DB Engine using SQL Server Authentication I get this message.

 
Need help before I tear out all my hair.


Edited by supertramp - 28 December 2008 at 8:23pm