Cant get the Forum to run on my server
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25989
Printed Date: 28 March 2026 at 6:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Cant get the Forum to run on my server
Posted By: stookie
Subject: Cant get the Forum to run on my server
Date Posted: 23 July 2008 at 2:09pm
|
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.
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 23 July 2008 at 2:39pm
|
As you were able to use the setup file to create the database schema on the SQL Server then the SQL Server must be correctly setup, so we can eliminate an incorrectly setup SQL Server as the issue. It could be a misplaced character in the database/database_connection.asp file. Try going back to the original unmodified file and try entering all the details again. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: stookie
Date Posted: 23 July 2008 at 3:15pm
|
Hi Bruce
That's done the trick, don't know what I changed in the database_connection.asp file but I must have changed something.
Everything seems to be running fine
Thanks for your help Bruce |
Posted By: irfanmusa
Date Posted: 10 November 2008 at 5:03am
|
Being a webmaster, this is a common error "Stookie". As when everything is running perfectly in the CMD(dos Mode) as you can connect to database then it must be problem in file. And that done the trick for you. That happened with me when i have started the work as a webmaster and managing few IIS servers hosting. So first thing is to check file for any misplaced character. ------------- http://www.incentaclick.com/online-advertising/best-affiliate-program.php - Best Affiliate Programs |
Posted By: supertramp
Date Posted: 28 December 2008 at 8:16pm
|
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. ------------- Don't eat the clown fish. They taste funny. |
Posted By: WebWiz-Bruce
Date Posted: 29 December 2008 at 8:37am
|
I take it this issue is with your local machine install and not our servers here at web wiz? If so make sure you have installed SQL Server Express 2008 in mixed mode with TCP/IP enabled, otherwise you can only connected using a trusted windows login. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: supertramp
Date Posted: 29 December 2008 at 4:55pm
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. ------------- Don't eat the clown fish. They taste funny. |
WebWiz-Bruce wrote:Posted By: supertramp
Date Posted: 29 December 2008 at 6:14pm
Thanks Bruce. As usual you were right. Was able to re-configure without re-install. It's all there when you know where to look  .
------------- Don't eat the clown fish. They taste funny. |
Posted By: shakir
Date Posted: 31 December 2008 at 2:10pm
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 |
Posted By: abhimi1
Date Posted: 04 March 2009 at 2:30pm
|
check file permission settings....... ------------- http://hubshout.com/" rel="nofollow - Seo services |