I've got an existing installation of YAF on Windows 2000 Server & SQL Server 2000.
I need to move the database to SQL Server 2005.
I've made a copy of the existing database on the new DB server, preserving exact names, and recreated the same SQL login account with same name and password.
As a test, I've also made a copy of the forum folder (in the same directory as the original, with a slightly different name) on the web server. In this copy I've changed the web.config's connection string to point at the new DB server and changed the element to match the test folder.
When I try and access the test copy forum, it tries to browse to the install folder. As this has been renamed (as recommended), it doesn't find it.
Any ideas why this is happening and not loading the forum default.aspx?
I've searched, but have not found a guide for moving to a new database server.
I'm also soon moving web servers to Windows Server 2003/IIS 6.0 - is there issues I will face there?