MSSQL v7.97 New Install -- Admin Button problems
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=18264
Printed Date: 13 April 2026 at 1:46am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MSSQL v7.97 New Install -- Admin Button problems
Posted By: jpwalters
Subject: MSSQL v7.97 New Install -- Admin Button problems
Date Posted: 05 February 2006 at 2:11am
|
Hello everyone,
I have a quick question about a new installation.
I've followed the documentation regarding the installation, and things seemed to go well.
1. The tables were created correctly, I was able to see them within the database.
2. I was able to login the first time using the administrator login, and was able to change the password.
The problem I'm having is that when I click on the Admin link, it requests the login information again, which seems to be a new feature. This is no problem, but when go through the process, I get "Web Wiz Forums: Access Denied" "Sorry, Only members with sufficient permission can access this page."
Sorry to repost this. I've notice that others have encountered the error message, but I didn't see a complete response. Someone mentioned that cookie settings could be the culprit, but I'd assume the initial login process would not have happened.
Does anyone know what the solution is to this problem? Is it because there are no forums created by the initial install?
Many thanks for your help!
Jason Walters
------------- Jason Walters |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 05 February 2006 at 5:22pm
|
It sounds like that for some reason your site/server is dropping the ASP session. The latest 7.97 version requires the ASP session for both the CAPTCHA image checking and to keep you logged in for the admin area. If for some reason the ASP session is dropped you will get the error you mention. Things that prevent the ASP sesison from working include, ASP files on your site using 'session.abandon' or server issues, such as:- The servers app pool is recyling all the time Multiple load balanced web servers Using Windows 2003 Web Farm in the app pool Not having the latest hotfixes on Windows 2003 (when it was released there where issues with ASP sessions) ------------- 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: jpwalters
Date Posted: 15 February 2006 at 8:07pm
Hi Borg,
Thanks for your quick response, you've been a great help..... I've been trying to make progress on this and look into your suggestions, but I'm still stuck.
What you say about the ASP session getting reset, makes sense, but I'm still not clear what's resetting the connection....
This webserver runs sever sites that do not use ASP session state. There would be no Session.Abandon's getting called, unless you think an ASP page containing sessionstateenabled = false is doing it.
1. I'm running Windows 2003 Server SP1 single server. I could not find the specific hotfix you mentioned, but I imagine it has been included in SP1, if not could you possibly send a KB link?
2. I'm not running Load Balancing.
3. I'm not running WebFarm or Web Gardens.
4. I did create a separate application pool for web wiz, rather than using the default application pool. I turned off the recycling but it has no effect. I still encountered same problem.
5. As a secondary experiment installed Web Wiz, to a server that has no current websites. I had mixed luck. It seemed to let me in the admin page, but then as soon as I tried to do something like create a forum, I got the familiar access denied message.
Thanks,
Jason Walters
------------- Jason Walters |
-boRg- wrote:Posted By: WebWiz-Bruce
Date Posted: 16 February 2006 at 10:25am
|
Have you tried with a different browser and/or PC? in case it is your browser that is coursing the issue, or some AV, ad-block, script block, firewall, etc. software that is coursing the issue. ------------- 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: jpwalters
Date Posted: 16 February 2006 at 3:36pm
|
Hi Borg,
Yes, I tried 3 machines, a couple browser variations.
Two machines running IE 6.0.2900.2180, also one of those machines I tested under FireFox v1.5
On another machine I tried IE 6.0.3790.1830.
In all cases the security is set to medium. The browser is succesfully accepting cookies.
I don't doubt that this is coming from the server side, but having checked several of the things you mentioned, I'm somewhat stuck.
Thanks for your help, I truly appreciate it...
Jason Walters
------------- Jason Walters |
Posted By: WebWiz-Bruce
Date Posted: 17 February 2006 at 1:20pm
|
What about Firewall, AV, script blocking, etc. software running on those machines, as they can often course issues.
------------- 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: Webmaster MJF
Date Posted: 17 February 2006 at 9:03pm
|
I have axacly the same problem. My ISP find the servers app pool is
recyling all the time, but can't fint out where and why. No other
application is running sessions on our site, so using sessions have to
be within the forum. Also the members can no longer upload any files to the forum. I have read somewhere else in this forum this can be set up in the admin module, and that every member has to be set to upload files or not. Is there a way to set this directly in the database, since I can't get into the admin section? PLEASE HELP! We are losing members and topics while these limits are on.. |
Posted By: pilot99
Date Posted: 20 February 2006 at 2:23am
well this happens to me sometimes too i found that i sometimes doent use capitals were it is need for the captcha  kinda of a silly mistake but its a possibility it happens to you also.------------- http://www.globaltornado.com"> 
|
Posted By: Webmaster MJF
Date Posted: 20 February 2006 at 8:53pm
| This is truely not the topic. I am logged in as the forum administrator and have all the rights needed for the rest of the forum. But still I can't get into the admin section. No login required as I am already logged in.. |
Posted By: WebWiz-Bruce
Date Posted: 21 February 2006 at 11:55am
|
In version 7.97 for extra protection against the latest hacking wave the login system for the admin section is completely different to the main forum. The admin section now requires the admin to re-login to the admin section, which now uses a more secure ASP session variable to keep the admin logged in throughout the admin section. If for some reason your browser or server is dropping the ASP session you will get issues logging into the admin section. Please see my other posts in this Topic for suggestions if you are having issues logging into the admin section. If the servers app pool is continually recycling like your host have said then it sounds like there is an issue with the server and it sounds like the server either has a bug that needs addressing, or the app pools have been setup incorrectly. Until this issue is resolved with your host server you will not be able to use software, such as web wiz forums that requires ASP sessions and application level variables. If the app pool is continually recycling then things like Active Users, Performance enhancements, logging into the admin area, uploading files and images, and lots of other features will not work or fail to work correctly. ------------- 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: jpwalters
Date Posted: 23 February 2006 at 6:54pm
|
Hi Borg,
1. There is a hardware firewall, however, the ip addresses we are testing from, are allowed open access (all ports).
2. No script blocking.
3. The only software programs running other than iis and sql would be veritas netbackup and mcaffee virusscan.
Would it be possible to download v7.96 and to try that?
Thanks,
Jason Walters
------------- Jason Walters |
Posted By: WebWiz-Bruce
Date Posted: 24 February 2006 at 9:02am
|
McAffee often courses issues, try disabling it see if it clears up the issue. Have you tested to see if your site can hold the ASP session? One way to do this is to run Firefox and have a look at the stored cookie for your site, if the ASP session ID keeps changing it means that your site has issues holding the ASP session. Also check that the application pool on the server is not set to be using a web garden and is not continually recycling. You can check that the app pool is not continually recycling by looking in the Windows Task Manager for the Image Name w3wp.exe, if the process ID for these keeps changing then the app pool is recycling, which could mean either an app pool setup problem or a bigger issue on the server. ------------- 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: jpwalters
Date Posted: 24 February 2006 at 3:06pm
Thanks for the info...
1. I added PID to the View in Task Manager and monitored the w3pwp.exe's. I watched them for about 30 minutes. The did not change at all. Though the Mem Usage and CPU usage for those processes varied.
2. Regarding the forum. I did seem to get a little further this time, which is a good thing, but I still ultimately end up at the same place. As you suggested I looked at the cookies from within FireFox, and here the ASP Session ID has not changed.
Cookie: ASPSESSIONIDSCCCDCDT
Content: PDNBEOIDKOIKALCNACFPAPKK Went to Web Wiz Forums License Agreement
Cookie Session ID the same...
Came to Forum Administration Menu
Cookie Session ID the same...
Created a forum...
Cookie Session ID the same..
Changed Password
Cookie Session ID the same..
Clicked on Membership Admin from the Admin Menu
Cookie Session ID the same..
Then....I received the famous message
"Sorry, only members with sufficient permission can access this page."
Checked Cookie one last time and it was still:
Cookie: ASPSESSIONIDSCCCDCDT
Content: PDNBEOIDKOIKALCNACFPAPKK So apparently, the session ID is not changing yet there is some other issue. Thanks,
Jason ------------- Jason Walters |
Posted By: WebWiz-Bruce
Date Posted: 24 February 2006 at 4:28pm
|
The only thing I can think then is a corrupted file of some kind. Try reuploading all the original files again making sure they are all from the same version. ------------- 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: Webmaster MJF
Date Posted: 27 February 2006 at 8:01pm
|
I think I fount it! The variable "strLoggedInUserCode" is not defined in the file admin/common.asp. When I defined it as the UID session it worked great! |
Posted By: oldgym
Date Posted: 04 March 2006 at 5:21am
Webmaster MJF! what have you changed in the code to fix it??? i found the code but am not sure how to manipulate it.
'Read in users ID number from the cookie strLoggedInUserCode = Trim(Mid(Session("UID"), 1, 44)) 'If a cookie exsists on the users system then read in there username from the database If strLoggedInUserCode <> "" Then 'Make the usercode SQL safe strLoggedInUserCode = formatSQLInput(strLoggedInUserCode) 'Initalise the strSQL variable with an SQL statement to query the database strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Username, " & strDbTable & "Author.Group_ID " strSQL = strSQL & "FROM " & strDbTable & "Author " strSQL = strSQL & "WHERE User_code = '" & strLoggedInUserCode & "';" Anyone wanna help me out???
|
Posted By: Webmaster MJF
Date Posted: 05 March 2006 at 4:13pm
|
It seams to be defined in yor code, but was somehow not in mine(?) Still I have problems uploading images, even I have given all users access to upload files and images in the forum. No error message; but the upload windows won't close after uploading. Before the uploaded image was sent to the post ed message. Any Ideas? |