Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - moving forums to new server
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

moving forums to new server

 Post Reply Post Reply Page  12>
Author
wolfman View Drop Down
Groupie
Groupie


Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51
Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfman Quote  Post ReplyReply Direct Link To This Post Topic: moving forums to new server
    Posted: 28 January 2009 at 8:52pm

Hi ,

I am using WWF Version 9.02 with MS SQL database.

I am trying to move my wwf to a new server and I have performed the following steps:

1.       I backed up the SQL.

2.       Created a new data base with the exact same name as the old one on the new server

3.       Restored the database and set up the permissions with the login and user as old

4.       Copied all wwf files from one sever to the other

After doing this I tried to launch the homepage and I received the following error:

=========================================================================

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 double and triple checked the syntax and entries within the database_connection.asp file and all is the same.

Can anyone advise as to what I might have missed?  I checked through these forums, but there are only a few topics with the same error.

Thank you,

Wolf

Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140
Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Posted: 28 January 2009 at 9:37pm
This error suggests that the database_connection.asp file does not have the correct attribute necessary to connect to your new server / database.

Are you using MSSQL Express? ANy difference of SQL servers between the old and new one?
"When it gets dark enough, you can see the stars"
-Charles A. Beard
Back to Top
wolfman View Drop Down
Groupie
Groupie


Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51
Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfman Quote  Post ReplyReply Direct Link To This Post Posted: 28 January 2009 at 9:51pm

Thanks for the reply iSec

I am Using SQL 2000 - same as was installed on the previous server.
Runing on Server 2003 - same as other
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140
Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Posted: 28 January 2009 at 10:27pm
Sometimes the SQL instance name matters... is this your own dedicated server? Try using 'localhost' as the server name...if you have already done that, try the IP address of the server.
"When it gets dark enough, you can see the stars"
-Charles A. Beard
Back to Top
wolfman View Drop Down
Groupie
Groupie


Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51
Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfman Quote  Post ReplyReply Direct Link To This Post Posted: 28 January 2009 at 10:35pm
yes - it's my own server -
I did try both localhost and ip address with no change.  very strange.  I cant help thinking it's something simple, but i cant put my finger on it.
 
thansk iSec - anything else you can advise?
 
 
Back to Top
iSec View Drop Down
Senior Member
Senior Member
Avatar

Joined: 13 February 2005
Status: Offline
Points: 1140
Post Options Post Options   Thanks (0) Thanks(0)   Quote iSec Quote  Post ReplyReply Direct Link To This Post Posted: 28 January 2009 at 10:41pm
i have the same setup as yours (or used to).. the only difference is that i have server 05 instead of 2000 now.

try re-uplloading a fresh copy of database_connection.asp file and put the new connection info on there and see what happens...



"When it gets dark enough, you can see the stars"
-Charles A. Beard
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 January 2009 at 9:15am
I would suggest that you use SQL Server 2005 or 2008 as you will get much better performance due to server side paging with Web Wiz Forums.

The free SQL Server 2008 Express Edition is fine for running web applications and will save you allot of money of licensing fees compared with SQL Server 2000.
Back to Top
wolfman View Drop Down
Groupie
Groupie


Joined: 04 August 2004
Location: United States
Status: Offline
Points: 51
Post Options Post Options   Thanks (0) Thanks(0)   Quote wolfman Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2009 at 4:07pm
HI Bruce,
 
Thanks - I can definetly do that.  Can I use the current database, or do I have to upgrade?
 
Wolf
 
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.