Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Cant get the Forum to run on my server
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Cant get the Forum to run on my server
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
stookie View Drop Down
Newbie
Newbie
Avatar

Joined: 23 July 2008
Location: Scotland
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote stookie Quote  Post ReplyReply Direct Link To This Post Topic: Cant get the Forum to run on my server
    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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
stookie View Drop Down
Newbie
Newbie
Avatar

Joined: 23 July 2008
Location: Scotland
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote stookie Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
irfanmusa View Drop Down
Newbie
Newbie


Joined: 10 November 2008
Status: Offline
Points: 1 		Post Options Post Options   Thanks (0) Thanks(0)   Quote irfanmusa Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
supertramp View Drop Down
Newbie
Newbie


Joined: 01 May 2006
Location: Australia
Status: Offline
Points: 25 		Post Options Post Options   Thanks (0) Thanks(0)   Quote supertramp Quote  Post ReplyReply Direct Link To This Post 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.


Edited by supertramp - 28 December 2008 at 8:23pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
supertramp View Drop Down
Newbie
Newbie


Joined: 01 May 2006
Location: Australia
Status: Offline
Points: 25 		Post Options Post Options   Thanks (0) Thanks(0)   Quote supertramp Quote  Post ReplyReply Direct Link To This Post Posted: 29 December 2008 at 4:55pm
Originally posted by WebWiz-Bruce 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.
Back to Top
supertramp View Drop Down
Newbie
Newbie


Joined: 01 May 2006
Location: Australia
Status: Offline
Points: 25 		Post Options Post Options   Thanks (0) Thanks(0)   Quote supertramp Quote  Post ReplyReply Direct Link To This Post Posted: 29 December 2008 at 6:14pm
Originally posted by supertramp supertramp wrote:

Will let you know the outcome.


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 Wacko.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.