| Author |
 Topic  |
|
|
DJWillis
Starting Member
United Kingdom
39 Posts |
 Posted - 16 December 2002 : 11:04:07
|
1st off, we have been running 3.3.05 and older versions in an Intranet environment for ages using NT authentication and auto login without any problems. This has moved over 2 SQL servers, 3 IIS boxes and 2 Snitz upgrades during the last year however moving to 3.4.03 is proving to be the nightmare of all nightmares.
Doing a backup of database and code then deploying the 3.4 code to the same IIS server and upgrading the database as I would normally do renders the forum unable to process NT auto logins however all threads and forum data migrates correctly and using not NT auto works.
I have tried this upgrade on 2 different IIS servers and many web sites (all of which process other NT authorisation based apps fine) and the upgrade has completed without errors but still renders the forum unusable. All using copies of the same SQL database.
If I do a totally clean install with a fresh DB then NT auto login works under 3.4 however as there are over 10,000 threads on the forum loosing them is not an option.
I guess what I am asking for is some hint’s on what to look for in the SQL database that may be causing the problem (such as a missing config flag) as I am 99.9% sure that the IIS server is not causing the problem however I have been unable to track down anything obvious in the database that’s wrong. The ‘FORUM_CONFIG_NEW’ table looks correct.
I have tried the upgrade a few times and have had to back out each time.
EDIT: Changed to make a 'little' less confusing and fix the fact I mistyped the version numbers. |
Regards
John Willis
"You can have any error screen, as long a it's blue" |
Edited by - DJWillis on 17 December 2002 08:30:58 |
|
|
David K
Junior Member
494 Posts |
Posted - 16 December 2002 : 15:42:03
|
| 3.4.04 doesn't exist, which might explain why it doesn't work |
 |
|
|
DJWillis
Starting Member
United Kingdom
39 Posts |
Posted - 17 December 2002 : 08:32:22
|
quote:
Originally posted by David K
3.4.04 doesn't exist, which might explain why it doesn't work
Thanks for that  . Post edited to remove confision and get some usefull replies. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 December 2002 : 08:37:08
|
Just a thought on how you might overcome the situation: setup the forum as a new one, in a clean SQL Server database. Then use SQL Server DTS to import all your existing data, from the upgraded database. Make sure that for each table specified in the DTS window, you change the transform column so that existing table data is deleted and enable identity insert is selected. After changing these settings for each table, proceed with the transfer from the upgraded DB to the clean DB.
I'm not sure that this will work. However I know nothing about NT authentication, but since you say creating a new DB works, maybe this will work as well... |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 23 December 2002 : 10:20:11
|
RUIRIB is correct,
Every time I update to a new version of Snitz I install it new and then import all my data into the new database, it has always worked when everything else failed! |
{VAS}-Kal Corp
VAS Development NetWork - Forums for old Snitz Mods!
Creator of all things {VAS}
|
|
|
|
DJWillis
Starting Member
United Kingdom
39 Posts |
Posted - 09 January 2003 : 07:18:09
|
No sorted. Cheers Guys.
Took a lot of crowbar'ing with DTS but it works great now  . |
Regards
John Willis
"You can have any error screen, as long a it's blue" |
|
|
| |
Topic |
|
Topic Locked
