Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved DB connection using Windows credentials

  1. How-to
0
Votes
Undo
  1. Miguel Alzate
    Miguel Alzate
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 8 August 2019 18:33 PM UTC

Hi. again!

How can the connection to the SQL Server database server be implemented, in Appeon Web/mobile applications, using Windows and not SQL Server credentials?

Thanks in advance for any answers!

Powerserver WEB - Picture Control property powerti...
Appeon multibrowser plugin
Accepted Answer
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Friday, 9 August 2019 00:23 AM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Hi Miguel,

PowerServer only can support the ‘SQL Server security authentication’, not
support the ‘Windows security authentication’ in the security of SQL Server.
And We don't have a feasible workaround for this currently, please change your
SQL server user security mode or add a new users which is using the ‘SQL Server
security authentication’.

If you have any issue when connect to SQL Server, please refer to article below to solve it.
http://support.appeon.com/index.php?/Knowledgebase/Article/View/48/0/cannot-connect-to-the-sql-server

Regards,
ZhaoKai

Comment
Miguel Alzate
  1. Miguel Alzate
  2. Friday, 9 August 2019 01:30 AM UTC
Thanks ZhaoKai.



What about integration of Appeon apps with Windows Active Directory? Wouldn't it be a possible workaround?
  1. Helpful
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Friday, 9 August 2019 01:43 AM UTC
Hi Miguel,



Please config LDAP security first..

https://www.appeon.com/support/documents/appeon_online_help/ps2019/server_configuration_guide_for_net/Server_Security.html#d0e6519



Then set application user authentitaion.

https://www.appeon.com/support/documents/appeon_online_help/ps2019/server_configuration_guide_for_net/Application_Security_Settings.html#application_security_aem



You can create your own login window and using AppeonLDAPLogon to log in to the LDAP server with the specified user name and password.

https://www.appeon.com/support/documents/appeon_online_help/ps2019/workarounds_and_api_guide/ch01s03s02.html#AppeonLDAPLogon_function



Regards,

ZhaoKai

  1. Helpful
Miguel Alzate
  1. Miguel Alzate
  2. Friday, 9 August 2019 11:15 AM UTC
Thanks again, ZhaoKai. I will check the links. Question resolved!
  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.