Web Wiz Forums - Migrate to new server

Print Page | Close Window

Migrate to new 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=31777
Printed Date: 28 March 2026 at 1:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Migrate to new server

Posted By: Gh0s+
Subject: Migrate to new server
Date Posted: 20 January 2024 at 2:13pm

I need to migrate to a new server. Currently on a very old VPS with a shared SQL server plan. Need to migrate to a newer server that will host SQL as well as the web files.

Is there documentation or help that I can get?
I tried cloning the SQL database and modified the database_settings.asp file in the original/active site, to see if I can at least have the data transfer. It's a no go - forum freezes up. Changed the database_settings.asp files settings back to point to original SQL database, and that is working fine, but stuck on the first part - migrating the data.

Running version 12.01.

Replies:

Posted By: Gh0s+
Date Posted: 20 January 2024 at 2:18pm

I'm open to migrating the data from MSSQL to MDB if needed (or even possible!), I usually don't have more than 20 users on at the same time.

Posted By: WebWiz-Bruce
Date Posted: 20 January 2024 at 5:11pm

To move the database to the new server create a SQL Server backup, which should be a .bak file which you can then restore to the new server.

I am not sure what you mean by 'freezing up', if you mean the forum didn't load and you eventually got a database connection timeout, make sure that SQL Server is configured in mixed mode with TCP/IP connections enabled so you can connect remotely to SQL Server from your forum.

If you get stuck we do provide Web Wiz Forums hosting with a migration service, see; http://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - www.webwiz.net/web-wiz-forums/forum-hosting.htm

-------------
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: Gh0s+
Date Posted: 20 January 2024 at 5:49pm

Yes, it times out. It looks like the data is already transferred over.

In Sql Server Config Manager > SQL Server Network Config > TCP/IP is enabled.

Is there something else I'm missing?

Posted By: Gh0s+
Date Posted: 20 January 2024 at 5:56pm

Sql Server Config Manager > SQL Server Network Config > TCP/IP is enabled

TCP/IP Properties > "Protocol" tab > Enabled=Yes, KeepAlive=30000, ListenAll=Yes

TCP/IP Properties > "IP Addresses" tab > Active=Yes and Enabled=Yes

What port do I need to specify for "TCP Dynamic Ports" and "TCP Port"? I tried 1433 but it doesn't work.

Posted By: WebWiz-Bruce
Date Posted: 21 January 2024 at 9:56am

Under the IP Address Tab make sure that you set 'Active' to 'Yes' for the IP address you are using for SQL Server.

Also check Windows Firewall on the server has TCP port 1433 open.