 |
|
 |
Cant get the Forum to run on my server |
Post Reply 
|
Page 12> |
| Author |
 Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search  Topic Options
|
stookie 
Newbie 
Joined: 23 July 2008 Location: Scotland Status: Offline Posts: 2 Points: 2 |
 Post Options
 Quote Reply
 Topic: Cant get the Forum to run on my serverPosted: 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.
|
|
 |
|
|
WebWiz-Bruce
Admin Group 
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Posts: 23183 Points: 6383 |
Post Options
Quote Reply
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. |
|
|
|
|
stookie
Newbie
Joined: 23 July 2008 Location: Scotland Status: Offline Posts: 2 Points: 2 |
Post Options
Quote Reply
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 |
|
|
|
|
irfanmusa
Newbie
Joined: 10 November 2008 Status: Offline Posts: 1 Points: 1 |
Post Options
Quote Reply
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.
|
|
|
|
|
supertramp
Newbie
Joined: 01 May 2006 Location: Australia Status: Offline Posts: 22 Points: 25 |
Post Options
Quote Reply
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 |
|
|
Don't eat the clown fish. They taste funny.
|
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Posts: 23183 Points: 6383 |
Post Options
Quote Reply
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. |
|
|
|
|
supertramp
Newbie
Joined: 01 May 2006 Location: Australia Status: Offline Posts: 22 Points: 25 |
Post Options
Quote Reply
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.
|
|
|
|
|
supertramp
Newbie
Joined: 01 May 2006 Location: Australia Status: Offline Posts: 22 Points: 25 |
Post Options
Quote Reply
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.
|
|
|
|
WebWiz-Bruce wrote:|
Post Reply
|
Page 12> |
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
All prices are shown excluding VAT, which is charged where applicable. $, € prices shown as a guideline only.