2. ASPRunnerPro General questions
  3. Single Login using AD account
This topic is locked

Single Login using AD account

 		7/1/2009 15:26:19
ASPRunnerPro General questions
Alberto author

Hello all, we need to convert all projects to single login or Single Sign On using the network login ID instead of the "asprunner user", so the user does not have to enter or remeber multiple user and passwords and it is more secure too. (new projects can probably be rebuilt but old ones probably not)
I can replace all my users in my ASPRunner users table to the network login ID but I dont know what need to be changed in the asprunner to actually achieve this.
Thanks in advance
J
 		Jane 7/2/2009

Hi,
you need to add Login page: Before process event, check network login ID, fill ASPRunner session variables and redirect to the list page.

You can check list of ASPRunner session variabls in the ASPRunnerPro Help --> Advanced topics --> Programming tips --> ASPRunnerPro session variables article:

http://www.xlinesoft.com/asprunnerpro/docs/
Alberto author 7/3/2009

Thanks Jane, it seems that it will work based on my tests...
Though, I have a question, how could I use only one domain account to access the SQL Server DB? I was using only one domain account before using an ODBC DSN with windows NT authentication checked and in the IIS authentication method was "enable anonymous access" checked and had there the only domain account with access to the DB.
Now it seems that I cannot do that anymore as the Request.ServerVariables("LOGON_USER") is blank when anonymous is checked. What do you think, any work around?
I just need the SSO only for asprunner at application level, database should be access with only one domain account with a hidden password
[font=Calibri]Thanks a lot