Web Wiz Forums - SQL 2000 to 2008

Print Page | Close Window

SQL 2000 to 2008

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=27580
Printed Date: 02 April 2026 at 2:17pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: SQL 2000 to 2008

Posted By: MortiOli
Subject: SQL 2000 to 2008
Date Posted: 16 July 2009 at 6:41pm

Hi Bruce,

I'm looking to move my WWF install onto a 2008 version of MS SQL, from a 2000 install.

The process would be to move the database from a 2000 server to a 2008 server.

What would the steps be to move and upgrade my WWF database at the same time?

Cheers,

Oli

Replies:

Posted By: WebWiz-Bruce
Date Posted: 17 July 2009 at 8:02am

All you need to do is create a backup of the SQL Server 2000 database (.bak file), then restore this to the new SQL Server 2008. The database is then upgraded to SQL Server 2008.

To upgrade your forum have a look at the upgrade documentation at the link below:-

http://www.webwiz.net/webwizforums/kb/

-------------
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: MortiOli
Date Posted: 17 July 2009 at 8:31pm

How do you force the forum to think that it's a new install, and needs to run the setup file again? Because you have to put the database connection settings in the asp file (an error is thrown if they're not correct), and because the new database already has WWF data in it, the forum thinks it doesn't need to run setup.

Posted By: Nick-V
Date Posted: 17 July 2009 at 8:42pm

With the new install instructionsyou do not edit the asp file with your connection settings. Thats what the upgrade does for you. Replace the default asp file and run the forum.

Posted By: MortiOli
Date Posted: 17 July 2009 at 8:58pm

That's what I thought when I first downloaded the upgrade, but it just said the db connection settings were incorrect:

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

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid authorization specification

Just removed them again, and tried, and the same thing happens.

Posted By: Nick-V
Date Posted: 17 July 2009 at 9:05pm

I would put the 9.6 asp files there and edit nothing. The upgrade wizard will work.

Posted By: MortiOli
Date Posted: 17 July 2009 at 9:49pm

They are 9.60 files - I'm basically moving (or test moving) my forum from one server to another, so I can change from SQL 2000 to SQL2008.

Posted By: Nick-V
Date Posted: 17 July 2009 at 10:20pm

You asked "How do you force the forum to think that it's a new install..."

I believe that if you use the standard 9.6 asp files and do not edit them at all the upgrade wizard will start instead of your home page and will ask you to enter database connection info and other stuff as documented.

From what you say I am not convinced you are doing this to the absolute letter. You have entered and removed connection info and that's not the process...reinstall the asp pages...I can add nothing else.