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.
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:
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.