• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerServer
  • SQL Server login issue with PowerServer Web App

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

Resolved SQL Server login issue with PowerServer Web App

  1. Issue
0
Votes
Undo
  1. Mike Sinclair
    Mike Sinclair
  2. PowerServer
  3. Tuesday, 27 August 2024 20:36 PM UTC

I apologize if this is a basic question, or if I leave out significant details, but this is my first time creating a PowerApp.  I did search the forums and the web, but did not find a good answer. 

I am creating a new PowerApp using Powerserver 2022 r3 on Windows 11.  The app works fine running via Kestral/local server.  I have the powerapp project compiled and deployed to a ZIP file that I have passed to the Azure web server admins for deployment to an Azure web server.  It has been deployed, and we can start the app, but I am having trouble nailing down the database settings. 

This application will be available for internal and external users, all of whom login through AD, although the external customers' domains are not trust-affiliated to the domain where the SQL Server resides.

What is the suggested authentication method for the database in this scenario?  The database is running on MS SQL Server 15.0. 

Please let me know if I need to provide any other details.

Thank you,

Mike Sinclair

  1. Authentication
  2. Database
  3. PowerServer
  4. SQL Server
  5. Web API
Instalar app cloud en un server (IIS) desde el eje...
Powerserver Session Createtime and Lastvisttime ar...
Responses (2)
Mike Sinclair
Mike Sinclair Accepted Answer Pending Moderation
  1. Tuesday, 27 August 2024 23:31 PM UTC
  2. PowerServer
  3. # 1

Yes, I see now that I should not use the individual AD account of the user as that would add a lot of overhead with the constant connecting and disconnecting.  A single service account should do the trick.  thank you.  I will work with our DBA to set that up and give it a try.  I will update this post as appropriate. 

Comment
There are no comments made yet.
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 27 August 2024 21:26 PM UTC
  2. PowerServer
  3. # 2

Hi Mike,

Is logging into the database with each of the user's AD identity what you're after?

I'm not quite sure that is possible right now. I found the following in the documentation:

> In installable cloud apps, the Windows Authentication or Active Directory Integrated Authentication mode would use the Windows user account at the web server for authentication by the SQL Server;  

[Source]

I believe that's not what you desire, so there's another approach:

Using Azure AD for Web API authentication.

You would have to use a single DB credential for the Web API's to connect to the database, and then configure AD authentication for your users to connect to the Web API

 

HTH

Regards,
Francisco

 

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.