Skip to main content
Solved

Authentication for Azure and other off-premise databases in SF

  • November 25, 2022
  • 3 replies
  • 82 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: 

 

View original
Did this topic help you find an answer to your question?
This topic has been closed for replies.

3 replies

Arie V
Community Manager
Forum|alt.badge.img+12
  • Community Manager
  • 1034 replies
  • 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
  • 149 replies
  • 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
  • 1034 replies
  • November 28, 2022

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings