Solved

Authentication for Azure and other off-premise databases in SF

  • 25 November 2022
  • 3 replies
  • 70 views

Userlevel 4
Badge +10

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.

icon

Best answer by Arie V 25 November 2022, 23:00

View original

3 replies

Userlevel 5
Badge +2

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: 

 

Userlevel 4
Badge +10

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.

Userlevel 5
Badge +2

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

Reply