2. ASPRunnerPro General questions
  3. Trouble with 'single login' feature in ASPRunnerPro app
This topic is locked

Trouble with 'single login' feature in ASPRunnerPro app

 		5/5/2009 11:49:16
ASPRunnerPro General questions
C
 cdl2 author

Hello All,
I found the post regarding the use of the following code for the LoginOnLoad event:
if Request.ServerVariables("LOGON_USER")<>"" then

SESSION("UserID") = Request.ServerVariables("LOGON_USER")

SESSION("AccessLevel") = ACCESS_LEVEL_USER

Response.Redirect "..._list.asp"

end if
However, I'm not having much luck getting it to work. I'm guessing this is an event that should be specified in the global asa file? For some reason it isn't passing that info on to any of the pages. I'm not using Anonymous login in IIS and I am able to retrieve the user id but it's not assigning it to the "UserId" at a global level. Any thoughts.
Thanks,
Sergey Kornilov admin 5/5/2009

You need to place this code to BeforeProcess event of the Login page.
C
 		cdl2 author 5/5/2009

You need to place this code to BeforeProcess event of the Login page.


Thanks for the quick response. It appears that that portion is now working.
I am now recieving an unable to connect to db message when I try to go the a page for any of my tables. The message says that the login is failing for the anonymous user (from IIS) even though I have allow anonymous logon disabled. The top of the page is showing that my id is logged in but for some reason it isn't being passed to the db table pages. This is the same ID I use to connect to SQL Server all the time so I know it isn't a permissions issue. Any other ideas?
Thanks,
Sergey Kornilov admin 5/5/2009

I recommend to use SQL Server authentication while connecting to SQL Server.
Configuring SQL Server and IIS to support Windows authentication is kind of tricky.

Just in case more info on this issue:

http://www.xlinesoft.com/asprunnerpro/faq.htm#loginfailed