Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - Moving from one hoster to another
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Moving from one hoster to another

 Post Reply Post Reply
Author
jpullam2 View Drop Down
Groupie
Groupie


Joined: 29 September 2004
Location: Canada
Status: Offline
Points: 52
Post Options Post Options   Thanks (0) Thanks(0)   Quote jpullam2 Quote  Post ReplyReply Direct Link To This Post Topic: Moving from one hoster to another
    Posted: 21 February 2022 at 10:26pm
The hosting company that I am doing business with has been purchased by another company and I am forced to migrate all of my sites to the new location. One customer uses WebWiz Forums and the application and database were moved automatically by their migration software.

At first when I tried to logon I received a blank page so I read various documents and I discovered that the necessary connection information was retained in database_settings.asp, so I revised the fields to reflect the new hosting domain. (It's a SQL implementation).

Unfortunately it still fails, and here is the output:

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:- database_connection.asp
Forum Version:- 11.04

Error details:-
Microsoft OLE DB Driver for SQL Server
Named Pipes Provider: Could not open a connection to SQL Server [53].

Can someone tell me what this means? Is there a proper way to do that migration that I need to follow? I'm kind of desperate to get the system back running after nearly a week of down time!

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Poole
Status: Offline
Points: 9748
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 22 February 2022 at 8:36am
The way you migrate Web Wiz Forums is;

1. Download all the files for Web Wiz Forums from the old host
2. Create a backup of the SQL Server database from the old host
3. Upload the Web Wiz Forum files to the new web host
4. Restore the SQL Server database backup to the new host
5. Edit the file database/database_settings.asp in notepad to put in the database connection details for the new webhost.

The error message you are getting says that there is an issue connecting to the database. Check with your new provider the database connection information they have given you is correct. The SQL Server needs to be installed in mix mode to allow TCP/IP connections.

If you get completely stuck we do provide hosting from our own Data Centre where we would be happy to get the forum running for you, and also maintain it by installing any updates.


Edited by WebWiz-Bruce - 22 February 2022 at 10:55am
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.06
Copyright ©2001-2023 Web Wiz Ltd.


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

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 unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

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