| Author |
 Topic  |
|
|
nugentgl
Starting Member
3 Posts |
 Posted - 11 October 2007 : 22:11:24
|
I was running the forum on a Windows 2k server with SQL 2k with no problems. I must migrate the forum to a new server that has Windows 2003 server and SQL 2005. I copied all files over to the new server and copied the DB to the new server. I created the same SQL user with the same password on the new server and modified the config.asp for snitz. I made sure that all the IIS settings and SQL settings on the old server were mirrored on the new server.
However, when I browse to the forum, I get an HTTP 403 Forbidden error and in the body of the page it says "Most likely causes: This website requires you to log in". I never get a chance to logon, it just goes straight to this page. I was using NT Authentication as the only way to access the forum and it was working. I must be missing something, but I can't figure it out.
Any clues where to start?
|
Edited by - nugentgl on 26 October 2007 17:28:49 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
nugentgl
Starting Member
3 Posts |
Posted - 26 October 2007 : 17:28:37
|
OK, finally got all that straightened out but the realized I didn't do the move procedure correctly. So I created a new database, edited the config.asp, ran setup.asp, and now I am attempting to move the data using SQL 2005 Import Export Wizard. I make all the selections and then it errors out at Validating (step 5). This is the error message:
- Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only column "B_ID".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task: "component "Destination 3 - FORUM_BADWORDS" (309)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)
Any clues what I am doing wrong? |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
nugentgl
Starting Member
3 Posts |
Posted - 27 October 2007 : 21:37:06
|
I forgot to and finally remembered. Guess what, it works when you FOLLOW directions.
Thanks. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 30 October 2007 : 12:47:41
|
quote:
Originally posted by nugentgl
I forgot to and finally remembered. Guess what, it works when you FOLLOW directions.
Thanks.
Haha - excellent ;-) |
|
|
| |
Topic |
|
Topic Locked
. Glad it worked 
.