Web Wiz Forums - Migrating from SQL 2000 to SQL 2005

Print Page | Close Window

Migrating from SQL 2000 to SQL 2005

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

Topic: Migrating from SQL 2000 to SQL 2005

Posted By: jimmyloh
Subject: Migrating from SQL 2000 to SQL 2005
Date Posted: 27 October 2008 at 1:17am

Hi,

I have an existing Forum that I want to migrate from SQL 2000 to SQL 2005. What are the steps that are involved. I have backed up and restore a copy on SQL 2005. However, I am getting an error message.

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 made the necessary correction on database server name, user id, user password and database name.

Can you help me troubleshooting this?

thanks

Jimmy

Replies:

Posted By: WebWiz-Bruce
Date Posted: 27 October 2008 at 6:35am

You have not mentioned how you migrated the data.

The only way to move the database from SQL Server 2000 to 2005 or 2008 and keep the existing database schema intact is to either detach and reattach the database and then change the compatibility level, or how I would suggest that you do this is to create a backup of the database (a .bak file) and then use this to restore the database on SQL Server 2005.

You should also download the SQL Server 2005 version of Web Wiz Forums.

-------------
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: jimmyloh
Date Posted: 27 October 2008 at 10:51am

Hi,

I did a backup and restore of the database. Where can I find out the version of WebWizForum that I am running? Also, how can I figure out if I need a WebWizforum for SQL 2005?

thanks,

Jimmy

Posted By: WebWiz-Bruce
Date Posted: 27 October 2008 at 1:05pm

There should be a file called includes/version_inc.asp that will contain the version number you are running.

If you are running a version 9 then download the latest 9.53 SQL Server 2005 version, upload it to your website and then edit the file database/database_connection.asp to put in your SQL Server database connection details.

-------------
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: dougl
Date Posted: 24 February 2009 at 4:33am

Bruce,

I am sitting on SQL 2000 w/ 9.55 - going to SQL 2005 this weekend... are there a few specific files in the sql 2005 version that I can copy over?

Posted By: WebWiz-Bruce
Date Posted: 24 February 2009 at 8:28am

Just update the database/database_connection.asp file with that from the SQL Server 2005/2008 web wiz forums download. This is the only file that is different between the various versions.

-------------
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