Skip to main content
Answer

Authentication for Azure and other off-premise databases in SF

  • November 25, 2022
  • 3 replies
  • 84 views

Forum|alt.badge.img+13

Here’s a very simple question I somehow cannot figure out. How does one authenticate a connection to an off-premise SQL Server instance such as Azure in software factory? I’ve added a runtime configuration for the Azure database but there is no means here to store a username and password.

I assume the current runtime configurations pick up the domain user credentials to connect to on-premise databases but this obviously doesn’t work with Azure databases.

Best answer by Arie V

The SF currently simply uses the Application Pool user credentials for all Runtime configurations. That means in order for this to work the target database needs to work with the same credentials. See also: 

 

This topic has been closed for replies.

3 replies

Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • Answer
  • November 25, 2022

The SF currently simply uses the Application Pool user credentials for all Runtime configurations. That means in order for this to work the target database needs to work with the same credentials. See also: 

 


Forum|alt.badge.img+13
  • Author
  • Hero
  • November 26, 2022

In that case we will have to figure out whether it is possible to use a local user as application pool user on the machine with Indicium. Because currently that’s a domain user and the Azure database doesn’t accept creating DOMAIN\USER logins. It complains about invalid characters.


Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • November 28, 2022

@Roland I believe adding a local Pool user should normally not be a problem.