| Author |
Topic Search Topic Options
|
mattjs
Newbie
Joined: 21 May 2007
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Topic: Windows Authentication Issues Posted: 22 May 2007 at 5:02pm |
|
Hello All. We are in the process of upgrading from WWF7.01 to 8.05a and we've run into two strange issues.
First the first is with the initial set-up of the Windows Authentication (WA) feature. After completing the database upgrade and following the directions for setting up WA, we get the following error when an Existing user tries to log in:
Support Error Code: err_Access_windowsAuthenticatin()_add_new_user
File Name: functions_windows_authentication.asp
Error details:
Microsoft Jet Database Engine
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
This only happens with existing users (of which we have quite a few), and we're not sure what the problem is.
The other problem we discovered while creating new users. The user is created perfectly fine in the database and WA functions as expected. However, when the user initially logs into the forum, the Quick Login box appears. This suggests to use that, at that moment, the user is not actually logged in, but that the forum software sees the user as "Guest."
If the user clicks any links on the page, or even hits Refresh and then they are logged in and everything is perfectly fine.
This is worrisome to use because we intend to lock down the forums and hide all topics / forum boards from the guest account once everything is all set. Any insight into what's happening here would be greatly appreciated.
Thanks for taking the time to look this over.
|
 |
mattjs
Newbie
Joined: 21 May 2007
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 May 2007 at 9:24pm |
|
Does anybody have any insight into these problems?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 29 May 2007 at 11:02pm |
|
At the present time if you want to use Windows Authentication it needs to be used from the start, you can't change between Windows Authentication and normal login.
|
|
|
 |
Jonathan8146
Newbie
Joined: 27 April 2004
Location: United Kingdom
Status: Offline
Points: 16
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2007 at 3:08pm |
|
Sorry for being dense, but where is the documentation concerning setting up windows authentication?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2007 at 3:41pm |
|
If you edit in notepad the file functions/functions_windows_authentication.asp it includes info all the information you need on how to enable it and use it.
|
|
|
 |
Jonathan8146
Newbie
Joined: 27 April 2004
Location: United Kingdom
Status: Offline
Points: 16
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 May 2007 at 3:45pm |
|
Ah, I saw that, but after reading the previous posts in this thread thought that there might be more elsewhere. I only found that by accident, too.
Thanks.
Edited by Jonathan8146 - 31 May 2007 at 3:45pm
|
 |
mattjs
Newbie
Joined: 21 May 2007
Status: Offline
Points: 6
|
Post Options
Thanks(0)
Quote Reply
Posted: 01 June 2007 at 9:16pm |
-boRg- wrote:
At the present time if you want to use Windows Authentication it needs to be used from the start, you can't change between Windows Authentication and normal login.
|
So, to clarify, if one has an existing set of forums from a previous version and then performs the upgrade to 8.x, they cannot use Windows Authentication for the forums? It has to be a fresh forum installation?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 June 2007 at 11:15am |
|
Yes that is correct as different type of data needs to be stored in the database to work with Windows Authentication as the standard login system data is not compatible with that required for Windows Authentication.
|
|
|
 |